Syntax error in INSERT INTO statement in c# oledb?

[ayaz1982]

I am having a table called SubMaster_Accou nts, which contains 9 fields. In which I want to insert data to some fields and i want to store some other fields as NULL. I tried to write the query using query string, but it shows syntax error in Insert command. How can i do it?

insert into SubMaster_Account ([SMcode], [MSname], [Sname], [Openbalrs],
 [Openbalrs1], [Openbalmet], [Openbalmet1], [Creditdays], [Sdesc])
 values ('" + SMcode + "','" + MSname + "','" + Sname + "'," + 
Openbalrs + ",'" + Openbalrs1 + "'," + Openbalmet + ",'" + 
Openbalmet1 + "'," + Creditdays + ",'" + Sdesc + "')

[Plater]

A little hulky, but your SQL statement looks fine.

Are you remembering to check all your string fields for embedded single quotes ' ? And then escaping them out by adding another single quote ('' is not ")