Unhandled Exception while executing SQL command

[bardiyam]

hi
Im trying to create connection in c# with Access database
and got exception at command.ExecuteNonQuery()--

Unhandled Exception of type 'System.Data.OleDb.OleDbException' occured in System.Data.dll

Additional Information : Syntax Error in Field Definition

Thank you in advance,

[shweta123]

Hi,

Can you please specify your SQL query ? There must be some syntax error.

[bardiyam]

hi
it is
cmd = new OleDbCommand(Create Table a1 (no integer,name char(10)",s')

s is connection name;
it gives error at cmd.ExecuteNonQuery();

wat is going wrong?


thanks.

[shweta123]

Hi,

You should write it as

cmd = new OleDbCommand(Create Table a1 (no integer,name char(10),s)