how to immerse variable into SQL statement

Question

Hi I have the SQL statement and don't know hot to immerse a variable into it. Can someone help please? Example: SqlCommand cmd = new SqlCommand(insert into Vydaje values ('variable' '2008-05-19' 150 9788071698609) conn); And I need to insert the variable exp[0] instead the word variable in the statement. Thanks. Regards Petr.

Petr Puncochar · Answer

Thanks Ryan it works. Regards Petr.

Ryan Alford · Answer

opps...sorry...forgot the quotes. SqlCommand cmd = new SqlCommand(insert into Vydaje values (' + exp[0].ToString() + ' '2008-05-19' 150 9788071698609) conn);

Petr Puncochar · Answer

Ryan thanks for your help. Unfortunately this does not work. The row inserted looks like this: +exp[0].ToString()+ 2008-05-19 00:00:00.000 15000 9788071698609 Could you please clarify? Regards Petr.

Ryan Alford · Answer

SqlCommand cmd = new SqlCommand(insert into Vydaje values ('+ exp[0].ToString() +' '2008-05-19' 150 9788071698609) conn);