Database

      OleDbConnection thisConnection=new OleDbConnection(
    @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Inetpub\wwwroot\First\Testing.mdb");

thisConnection.Open();
// create DataAdapter object for update and other operations
    OleDbDataAdapter thisAdapter = new OleDbDataAdapter(
        "SELECT * FROM Table1", thisConnection);
// create CommandBuilder object to build SQL commands
OleDbCommandBuilder thisBuilder = new OleDbCommandBuilder(thisAdapter);
// create DataSet to contain related data tables, rows, and columns
DataSet thisDataSet = new DataSet();
// fill DataSet using query defined previously for DataAdapter
thisAdapter.Fill(thisDataSet, "Table1");
DataRow myRow=thisDataSet.Tables["Table1"].NewRow();
myRow["Column1"]="mazy";
myRow["Column2"]="Hello everybody!";
myRow["Column3"]=312;
thisDataSet.Tables["Table1"].Rows.Add(myRow);

thisAdapter.Update(thisDataSet,"Table1");

thisConnection.Close();