This program shows how to insert data in an access database using ADO and SQL query. I have an Access 2000 database in project\bin\debug directory. My database name is mcTest.MDB. You can create your own database and copy in your project's debug directory. I am not attaching database with this code because of size problem.I have a table 'Developer' in this database which has four columns. I am inserting values into two columns Name and Address in this code.
using System;using System.Data; using System.Data.OleDb; namespace ADONETWriteQuery { /// <summary> /// Summary description for Class1. /// </summary> class Class1 { static void Main(string[] args) { string strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=c:\\mcTest.MDB"; string strSQL = "INSERT INTO Developer(Name, Address ) VALUES('NewName', 'NewAddress')" ; // create Objects of ADOConnection and ADOCommand OleDbConnection myConn = new OleDbConnection(strDSN); OleDbCommand myCmd = new OleDbCommand( strSQL, myConn ); try { myConn.Open(); myCmd.ExecuteNonQuery(); } catch (Exception e) { Console.WriteLine("Oooops. I did it again:\n{0}", e.Message); } finally { myConn.Close(); } } } }