how to immerse variable into SQL statement

Thanks Ryan, it works. Regards, Petr.

0

opps...sorry...forgot the quotes.

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

0

Petr Puncochar18y ago

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 150,00 9788071698609 Could you please clarify? Regards, Petr.

0

Ryan Alford18y ago

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

0