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>