Loading

Insert data into database

Jagjit Saini

Hi

MySqlCommand myCommand = new MySqlCommand("INSERT INTO hs_hr_attendance (10,_dt2,_dt.ToString(),NULL,'',NULL,0,1)",con);it is giving error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '10,_dt2,_dt.ToString(),NULL,'',NULL,0,1)'
Thanks

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs15y ago
Also you are asking the same question many times. This question is the same as DateTime which is where you got your answer. Please do not ask the same question many times. What you really should do is to read the error message; it says "check the manual".
0
Jagjit Saini15y ago
Hi

Solved. I was using wrong syntax.

Thanks
0
15y ago
What is dt.ToString() ? Is it data table ?... Don't the use inline queries. Try to use stored procedures or parameterized queries....

0