sql server2000 "insert" in c# .net

[sowmyat]

hi Guys,

i developed one web based application in c# .net & with ASP .net.In that i put connection to a database in sql server 2000.how can i insert the values which are in a variable to the database.
i wrote like this,

string s="abc";
thisCommand3.Co mmandText = "insert into results values ( 'sowmya',1,"+s+ " 'ravi')";

but i am getting error.
can any one know this.
plz help.........

[nmsreddi]

Hello

try this one

thisCommand3.Co mmandText = "insert into results values ( 'sowmya',1,'"+s+"', 'ravi')";

you are missing singlecodes along with doublecode while passing parameter

and make that results table contains all the which you are inserting and datatypes are correct

Good luck

[kenobewan]

If that gives you an error try:

thisCommand3.Co mmandText = "insert into results values ( 'sowmya',1,'" & s & "', 'ravi')";

[sowmyat]

thank u
i got it