Tuesday, December 1, 2009

Getting our Tags/AdjDesc for a CoolGuy ID

sqlCmd.CommandText = "SELECT CoolGuy.LineID, Adj.AdjDesc " +
"FROM CoolGuy INNER JOIN " +
" Link ON CoolGuy.LineID = Link.LineID " +
" INNER JOIN Adj ON Link.AdjID = Adj.AdjID " +
" WHERE CoolGuy.LineID = '" + _LineID.ToString() + "'";
_SQLConnection.Open;
sda.Fill(_Tags);
_SQLConnection.Close;

No comments:

Post a Comment