Csharp/C Sharp by API/System.Data.OleDb/OleDbCommandBuilder

new OleDbCommandBuilder

<source lang="csharp"> using System; using System.Data; using System.Data.OleDb;

   public class UpdatingADataSource
   {
       static void Main(string[] args)
       {
           OleDbConnection MyConnection = new OleDbConnection(@"Provider=Microsft.Jet.OLEDB.4.0; Data Source = c:\MyAccessDB.mdb");
           OleDbDataAdapter MyAdapter = new OleDbDataAdapter("SELECT Column1, Column2, Column3 FROM MyTable", MyConnection);
           DataSet MyDataSet = new DataSet();
           MyAdapter.Fill(MyDataSet, "MyTable");
           MyDataSet.Tables[0].Rows[3]["Column3"] = "Test";
           OleDbCommandBuilder MyBuilder = new OleDbCommandBuilder(MyAdapter);
           MyAdapter.Update(MyDataSet.Tables[0]);
       }
   }
  
 </source>