OleDB using MS-Access

[s4_sabahatf]

i m unable to insert record in table using OLeDb follwoing command.it is drawing unhandled expection,please do tell me the easiest way /////////////////////////////////////////////////////////// OleDbConnection m_Connection = new OleDbConnection(Connection); m_Connection.ConnectionString=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:use.mdb"; m_Connection.Open(); Connection ="INSERT INTO user =(1,1)";

[pmarfleet]

3 things: 1. Don't post your questions twice. 2. Your code won't compile. The last line references a variable that hasn't been declared. 3. You should learn basic SQL syntax before attempting anything more complicated. This site[^] should help.

Paul Marfleet

[Hesham Amin]

You should create a command object, not pass the query to the constructor of the connection object. also the syntax of the SQL statement to insert is not true. It should be something like:

INSERT INTO user values (1,1)

that if the user table has just 2 columns. I think you really need to read about ADO.NET this can be a good place to start.[^]

---

Hesham A. Amin My blog