new OleDbCommandBuilder : OleDbCommandBuilder « System.Data.OleDb « C# / C Sharp by API

1. C# / C Sharp by API
2. System.Data.OleDb
3. OleDbCommandBuilder

new OleDbCommandBuilder

 

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]);
        }
    }

   
  

Related examples in the same category