Csharp/CSharp Tutorial/ADO.Net/OleDbDataAdapter

Updating a DataSource

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

class MainClass {

 static void Main(string[] args)
 {
   OleDbConnection MyConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source = c:\Northwind.mdb");
   OleDbDataAdapter MyAdapter = new OleDbDataAdapter("SELECT * FROM orders", MyConnection);
   DataSet MyDataSet = new DataSet();
   MyAdapter.Fill(MyDataSet, "orders");
   MyDataSet.Tables[0].Rows[1]["ID"] = "1";
   OleDbCommandBuilder MyBuilder = new OleDbCommandBuilder(MyAdapter);
   MyAdapter.Update(MyDataSet.Tables[0]);
 }

}</source>

Using ADO Managed Provider

<source lang="csharp">using System; using System.Collections.Generic; using System.ruponentModel; using System.Data; using System.Data.OleDb; using System.Drawing; using System.Windows.Forms;

  class ADONetForm1 : Form
  {
     public ADONetForm1()
     {
        InitializeComponent();
        string connectionString = "provider=Microsoft.JET.OLEDB.4.0; data source = c:\\nwind.mdb";
        string commandString = "Select CompanyName, ContactName from Customers";
        OleDbDataAdapter DataAdapter = new OleDbDataAdapter(
        commandString, connectionString );
        DataSet DataSet = new DataSet();
        DataAdapter.Fill( DataSet, "Customers" );
        DataTable dataTable = DataSet.Tables[0];
        // for each row in the table, display the info
        foreach ( DataRow dataRow in dataTable.Rows )
        {
           lbCustomers.Items.Add(
              dataRow["CompanyName"] +
              " (" + dataRow["ContactName"] + ")" );
        }
     }
     private void InitializeComponent()
     {
        this.lbCustomers = new System.Windows.Forms.ListBox();
        this.SuspendLayout();
        this.lbCustomers.FormattingEnabled = true;
        this.lbCustomers.Location = new System.Drawing.Point( 13, 13 );
        this.lbCustomers.Name = "lbCustomers";
        this.lbCustomers.Size = new System.Drawing.Size( 267, 225 );
        this.lbCustomers.TabIndex = 0;
        this.AutoScaleBaseSize = new System.Drawing.Size( 5, 13 );
        this.ClientSize = new System.Drawing.Size( 292, 262 );
        this.Controls.Add( this.lbCustomers );
        this.Name = "ADONetForm1";
        this.Text = "ADO.Net Form 1";
        this.ResumeLayout( false );
     }
     private System.Windows.Forms.ListBox lbCustomers;
     [STAThread]
     static void Main()
     {
        Application.Run( new ADONetForm1() );
     }
  }</source>

Using MultiTabled Datasets

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

class MainClass {

 static void Main(string[] args)
 {
   OleDbConnection MyConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source = c:\Northwind.mdb");
   OleDbDataAdapter MyAdapter = new OleDbDataAdapter("SELECT * FROM Orders", MyConnection);
   DataSet MyDataSet = new DataSet();
   MyAdapter.Fill(MyDataSet, "Orders");
   foreach (DataTable MyTable in MyDataSet.Tables)
   {
     foreach (DataColumn MyColumn in MyTable.Columns)
     {
       foreach (DataRow MyRow in MyTable.Rows)
       {
       }
     }
   }
 }

}</source>