Syntax error raised while insert a record into msaccess from VB.NET

[sivakumar mariappan]

Hi, I am inserting records into ms access using vb.net. insert into data(F01,F02)values(" & F01(k) & "," & IIf(Double.IsNaN(F01TA(k)), DBNull.Value, F01TA(k)) & ")" Showing syntax error in the insert statement. the output query is like below insert into Data(F01,F02)values(221,); Please share your ideas... Thanks, Sivakumar.M.

[Md Marufuzzaman]

check the value of the given parameters... your generated query probably like ... ....Values(1,2,,3)

I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

---

Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you. Thanks Md. Marufuzzaman

[Vimalsoft Pty Ltd]

What is the Error that you are getting ? Your insert is incorrect, Your expected number of parameters is less than the Supplied Parameters.

Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/

[David Skelly]

When you concatenate DBNull.Value into your query expression, it calls the DBNull.ToString method. This is defined to return an empty string, so your insert statement is missing a parameter after the final comma. Use the literal "null" in your SQL insert instead of DBNull.Value, that should work. Or use a DbCommand with query parameters, as someone else suggested.