data reader query

[winnie]

hi. i am using vb.net with sql server as database.
i am using data reader to display some data from my database. here are part of my code.

cd.CommandText = "SELECT *FROM Result WHERE User_ID = name "

the problem is "User_ID" cannot get the value of "name"

any help?? thanks.

 

[quwiltw]

At the risk of offering an insulting answer... have you tried
cd.CommandText = "SELECT * FROM Result WHERE User_ID=" & name

??? We can start with that and go from there.

 

[loquin]

or even better,

cd.CommandText = "SELECT * FROM Result WHERE User_ID=" & name & ""

 

[Nerseus]

One more:

cd.CommandText = "SELECT * FROM Result WHERE User_ID=" & name.Replace("", "") & ""

I may be off on the Replace syntax - Im trying to replace one single quote with two, in case "name" contains a single quote.

-ner

 

[winnie]

thank you everyone. my code can get the value now. i guess dotnet is very picky with the " and sign.
thanks for the help again