Syntax error in INSERT INTO statement
- by Amit Kr. Ghosh
conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\database.mdb");
conn.Open();
com = new OleDbCommand(@"insert into group
(groupid,groupname,nature,effect)
values
(@groupid,@groupname,@nature,@effect)", conn);
com.Parameters.AddWithValue("@groupid", intialtxt);
com.Parameters.AddWithValue("@groupname", groupnametxt);
com.Parameters.AddWithValue("@nature", groupnaturecombo);
com.Parameters.AddWithValue("@effect", efectivegroupcombo);
com.ExecuteNonQuery();
conn.Close()
i have write this connection ,but i get one error Syntax error in INSERT INTO statement
please someone help me.
