Csharp/CSharp Tutorial/ADO.Net/OleDbCommandBuilder

Delete data and reload to DataGrid

using System;
using System.Drawing;
using System.Collections;
using System.ruponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;
public class DeleteDataLoadDataGrid : System.Windows.Forms.Form
{
  private System.Windows.Forms.DataGrid dataGrid1;
  private System.Windows.Forms.Button InsertCommand;
  private System.Windows.Forms.Button UpdateCommand;
  private System.Windows.Forms.Button DeleteCommand;
  private System.Windows.Forms.CheckBox checkBox1;
  private System.ruponentModel.Container components = null;
  public DeleteDataLoadDataGrid()
  {
    InitializeComponent();
  }
  protected override void Dispose( bool disposing )
  {
    if( disposing )
    {
      if (components != null) 
      {
        components.Dispose();
      }
    }
    base.Dispose( disposing );
  }
  private void InitializeComponent()
  {
    this.dataGrid1 = new System.Windows.Forms.DataGrid();
    this.InsertCommand = new System.Windows.Forms.Button();
    this.UpdateCommand = new System.Windows.Forms.Button();
    this.DeleteCommand = new System.Windows.Forms.Button();
    this.checkBox1 = new System.Windows.Forms.CheckBox();
    ((System.ruponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
    this.SuspendLayout();
    // 
    // dataGrid1
    // 
    this.dataGrid1.DataMember = "";
    this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
    this.dataGrid1.Location = new System.Drawing.Point(8, 8);
    this.dataGrid1.Name = "dataGrid1";
    this.dataGrid1.Size = new System.Drawing.Size(336, 304);
    this.dataGrid1.TabIndex = 0;
    // 
    // InsertCommand
    // 
    this.InsertCommand.Location = new System.Drawing.Point(368, 24);
    this.InsertCommand.Name = "InsertCommand";
    this.InsertCommand.Size = new System.Drawing.Size(120, 32);
    this.InsertCommand.TabIndex = 1;
    this.InsertCommand.Text = "Insert Command";
    this.InsertCommand.Click += new System.EventHandler(this.InsertCommand_Click);
    // 
    // UpdateCommand
    // 
    this.UpdateCommand.Location = new System.Drawing.Point(368, 72);
    this.UpdateCommand.Name = "UpdateCommand";
    this.UpdateCommand.Size = new System.Drawing.Size(120, 32);
    this.UpdateCommand.TabIndex = 2;
    this.UpdateCommand.Text = "Update Command";
    this.UpdateCommand.Click += new System.EventHandler(this.UpdateCommand_Click);
    // 
    // DeleteCommand
    // 
    this.DeleteCommand.Location = new System.Drawing.Point(368, 120);
    this.DeleteCommand.Name = "DeleteCommand";
    this.DeleteCommand.Size = new System.Drawing.Size(120, 32);
    this.DeleteCommand.TabIndex = 3;
    this.DeleteCommand.Text = "Delete Command";
    this.DeleteCommand.Click += new System.EventHandler(this.DeleteCommand_Click);
    // 
    // checkBox1
    // 
    this.checkBox1.Location = new System.Drawing.Point(368, 192);
    this.checkBox1.Name = "checkBox1";
    this.checkBox1.Size = new System.Drawing.Size(112, 24);
    this.checkBox1.TabIndex = 4;
    this.checkBox1.Text = "SqlCommand";
    // 
    // DeleteDataLoadDataGrid
    // 
    this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
    this.ClientSize = new System.Drawing.Size(496, 325);
    this.Controls.AddRange(new System.Windows.Forms.Control[] {
                                    this.checkBox1,
                                    this.DeleteCommand,
                                    this.UpdateCommand,
                                    this.InsertCommand,
                                    this.dataGrid1});
    this.Name = "DeleteDataLoadDataGrid";
    this.Text = "DeleteDataLoadDataGrid";
    ((System.ruponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
    this.ResumeLayout(false);
  }
  [STAThread]
  static void Main() 
  {
    Application.Run(new DeleteDataLoadDataGrid());
  }
  private void InsertCommand_Click(object sender, System.EventArgs e)
    {
    }
  private void UpdateCommand_Click(object sender, System.EventArgs e)
    {
    }

  private void DeleteCommand_Click(object sender, System.EventArgs e)
    {
        
    string ConnectionString = 
      "Provider=Microsoft.Jet.OLEDB.4.0;"+
      "Data Source=c:\\Northwind.mdb";
    OleDbConnection conn = 
      new OleDbConnection(ConnectionString);
    DataSet ds = new DataSet();
        
    try
    {
      conn.Open();
      OleDbDataAdapter adapter = new OleDbDataAdapter(
        "SELECT * FROM Customers", conn);
            
      OleDbCommandBuilder cmdBuilder = 
        new OleDbCommandBuilder(adapter);
      adapter.MissingSchemaAction = 
        MissingSchemaAction.AddWithKey;
    
      adapter.Fill(ds, "Customers");
    
      DataRow row1 = ds.Tables["Customers"].Rows.Find("001");
      row1.Delete(); 
      adapter.Update(ds, "Customers");
      dataGrid1.DataSource = ds.DefaultViewManager;
    }
    catch(OleDbException exp)
    {
      MessageBox.Show(exp.Message.ToString());
    }
    if(conn.State == ConnectionState.Open)
      conn.Close();     
    }
}

Insert Data and reload to DataGrid

using System;
using System.Drawing;
using System.Collections;
using System.ruponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;
public class InsertDataLoadDataGrid : System.Windows.Forms.Form
{
  private System.Windows.Forms.DataGrid dataGrid1;
  private System.Windows.Forms.Button InsertCommand;
  private System.Windows.Forms.Button UpdateCommand;
  private System.Windows.Forms.Button DeleteCommand;
  private System.Windows.Forms.CheckBox checkBox1;
  private System.ruponentModel.Container components = null;
  public InsertDataLoadDataGrid()
  {
    InitializeComponent();
  }
  protected override void Dispose( bool disposing )
  {
    if( disposing )
    {
      if (components != null) 
      {
        components.Dispose();
      }
    }
    base.Dispose( disposing );
  }
  private void InitializeComponent()
  {
    this.dataGrid1 = new System.Windows.Forms.DataGrid();
    this.InsertCommand = new System.Windows.Forms.Button();
    this.UpdateCommand = new System.Windows.Forms.Button();
    this.DeleteCommand = new System.Windows.Forms.Button();
    this.checkBox1 = new System.Windows.Forms.CheckBox();
    ((System.ruponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
    this.SuspendLayout();
    // 
    // dataGrid1
    // 
    this.dataGrid1.DataMember = "";
    this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
    this.dataGrid1.Location = new System.Drawing.Point(8, 8);
    this.dataGrid1.Name = "dataGrid1";
    this.dataGrid1.Size = new System.Drawing.Size(336, 304);
    this.dataGrid1.TabIndex = 0;
    // 
    // InsertCommand
    // 
    this.InsertCommand.Location = new System.Drawing.Point(368, 24);
    this.InsertCommand.Name = "InsertCommand";
    this.InsertCommand.Size = new System.Drawing.Size(120, 32);
    this.InsertCommand.TabIndex = 1;
    this.InsertCommand.Text = "Insert Command";
    this.InsertCommand.Click += new System.EventHandler(this.InsertCommand_Click);
    // 
    // UpdateCommand
    // 
    this.UpdateCommand.Location = new System.Drawing.Point(368, 72);
    this.UpdateCommand.Name = "UpdateCommand";
    this.UpdateCommand.Size = new System.Drawing.Size(120, 32);
    this.UpdateCommand.TabIndex = 2;
    this.UpdateCommand.Text = "Update Command";
    this.UpdateCommand.Click += new System.EventHandler(this.UpdateCommand_Click);
    // 
    // DeleteCommand
    // 
    this.DeleteCommand.Location = new System.Drawing.Point(368, 120);
    this.DeleteCommand.Name = "DeleteCommand";
    this.DeleteCommand.Size = new System.Drawing.Size(120, 32);
    this.DeleteCommand.TabIndex = 3;
    this.DeleteCommand.Text = "Delete Command";
    this.DeleteCommand.Click += new System.EventHandler(this.DeleteCommand_Click);
    // 
    // checkBox1
    // 
    this.checkBox1.Location = new System.Drawing.Point(368, 192);
    this.checkBox1.Name = "checkBox1";
    this.checkBox1.Size = new System.Drawing.Size(112, 24);
    this.checkBox1.TabIndex = 4;
    this.checkBox1.Text = "SqlCommand";
    // 
    // InsertDataLoadDataGrid
    // 
    this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
    this.ClientSize = new System.Drawing.Size(496, 325);
    this.Controls.AddRange(new System.Windows.Forms.Control[] {
                                    this.checkBox1,
                                    this.DeleteCommand,
                                    this.UpdateCommand,
                                    this.InsertCommand,
                                    this.dataGrid1});
    this.Name = "InsertDataLoadDataGrid";
    this.Text = "InsertDataLoadDataGrid";
    ((System.ruponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
    this.ResumeLayout(false);
  }
  [STAThread]
  static void Main() 
  {
    Application.Run(new InsertDataLoadDataGrid());
  }
  private void InsertCommand_Click(object sender, System.EventArgs e)
    {
        string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\Northwind.mdb";
        OleDbConnection conn = new OleDbConnection(ConnectionString);
        DataRow row;
        DataSet ds = new DataSet();
        
        try
        {
            conn.Open();
            OleDbDataAdapter adapter = new OleDbDataAdapter(
                "SELECT * FROM Customers", conn);
            
      OleDbCommandBuilder cmdBuilder = 
          new OleDbCommandBuilder(adapter);
        adapter.MissingSchemaAction = 
          MissingSchemaAction.AddWithKey;
        adapter.Fill(ds, "Customers");
        row = ds.Tables["Customers"].NewRow();
        row["CustomerId"] = "001";
        row["ContactName"] = "L";
        row["CompanyName"] = "M";    
        ds.Tables["Customers"].Rows.Add(row);
    
            adapter.Update(ds, "Customers");
            dataGrid1.DataSource = ds.DefaultViewManager;
        }
        catch(OleDbException exp)
        {
            MessageBox.Show(exp.Message.ToString());
        }
        if(conn.State == ConnectionState.Open)
            conn.Close();
    }
  private void UpdateCommand_Click(object sender, System.EventArgs e)
    {
    }
  private void DeleteCommand_Click(object sender, System.EventArgs e)
    {
    }
}

Update data and reload to DataGrid

using System;
using System.Drawing;
using System.Collections;
using System.ruponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;
public class UpdateDataLoadDataGrid : System.Windows.Forms.Form
{
  private System.Windows.Forms.DataGrid dataGrid1;
  private System.Windows.Forms.Button InsertCommand;
  private System.Windows.Forms.Button UpdateCommand;
  private System.Windows.Forms.Button DeleteCommand;
  private System.Windows.Forms.CheckBox checkBox1;
  private System.ruponentModel.Container components = null;
  public UpdateDataLoadDataGrid()
  {
    InitializeComponent();
  }
  protected override void Dispose( bool disposing )
  {
    if( disposing )
    {
      if (components != null) 
      {
        components.Dispose();
      }
    }
    base.Dispose( disposing );
  }
  private void InitializeComponent()
  {
    this.dataGrid1 = new System.Windows.Forms.DataGrid();
    this.InsertCommand = new System.Windows.Forms.Button();
    this.UpdateCommand = new System.Windows.Forms.Button();
    this.DeleteCommand = new System.Windows.Forms.Button();
    this.checkBox1 = new System.Windows.Forms.CheckBox();
    ((System.ruponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
    this.SuspendLayout();
    // 
    // dataGrid1
    // 
    this.dataGrid1.DataMember = "";
    this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
    this.dataGrid1.Location = new System.Drawing.Point(8, 8);
    this.dataGrid1.Name = "dataGrid1";
    this.dataGrid1.Size = new System.Drawing.Size(336, 304);
    this.dataGrid1.TabIndex = 0;
    // 
    // InsertCommand
    // 
    this.InsertCommand.Location = new System.Drawing.Point(368, 24);
    this.InsertCommand.Name = "InsertCommand";
    this.InsertCommand.Size = new System.Drawing.Size(120, 32);
    this.InsertCommand.TabIndex = 1;
    this.InsertCommand.Text = "Insert Command";
    this.InsertCommand.Click += new System.EventHandler(this.InsertCommand_Click);
    // 
    // UpdateCommand
    // 
    this.UpdateCommand.Location = new System.Drawing.Point(368, 72);
    this.UpdateCommand.Name = "UpdateCommand";
    this.UpdateCommand.Size = new System.Drawing.Size(120, 32);
    this.UpdateCommand.TabIndex = 2;
    this.UpdateCommand.Text = "Update Command";
    this.UpdateCommand.Click += new System.EventHandler(this.UpdateCommand_Click);
    // 
    // DeleteCommand
    // 
    this.DeleteCommand.Location = new System.Drawing.Point(368, 120);
    this.DeleteCommand.Name = "DeleteCommand";
    this.DeleteCommand.Size = new System.Drawing.Size(120, 32);
    this.DeleteCommand.TabIndex = 3;
    this.DeleteCommand.Text = "Delete Command";
    this.DeleteCommand.Click += new System.EventHandler(this.DeleteCommand_Click);
    // 
    // checkBox1
    // 
    this.checkBox1.Location = new System.Drawing.Point(368, 192);
    this.checkBox1.Name = "checkBox1";
    this.checkBox1.Size = new System.Drawing.Size(112, 24);
    this.checkBox1.TabIndex = 4;
    this.checkBox1.Text = "SqlCommand";
    // 
    // UpdateDataLoadDataGrid
    // 
    this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
    this.ClientSize = new System.Drawing.Size(496, 325);
    this.Controls.AddRange(new System.Windows.Forms.Control[] {
                                    this.checkBox1,
                                    this.DeleteCommand,
                                    this.UpdateCommand,
                                    this.InsertCommand,
                                    this.dataGrid1});
    this.Name = "UpdateDataLoadDataGrid";
    this.Text = "UpdateDataLoadDataGrid";
    ((System.ruponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
    this.ResumeLayout(false);
  }
  [STAThread]
  static void Main() 
  {
    Application.Run(new UpdateDataLoadDataGrid());
  }
  private void InsertCommand_Click(object sender, System.EventArgs e)
    {
    }
  private void UpdateCommand_Click(object sender, System.EventArgs e)
    {
        string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;"+
            "Data Source=c:\\Northwind.mdb";
        OleDbConnection conn = 
            new OleDbConnection(ConnectionString);
        DataSet ds = new DataSet();
        
        try
        {
            conn.Open();
            OleDbDataAdapter adapter = new OleDbDataAdapter(
                "SELECT * FROM Customers", conn);
            
            OleDbCommandBuilder cmdBuilder = 
                new OleDbCommandBuilder(adapter);
            adapter.MissingSchemaAction = 
                MissingSchemaAction.AddWithKey;
            adapter.Fill(ds, "Customers");
            DataRow row1 = ds.Tables["Customers"].Rows.Find("001");
            row1["ContactName"]="S";
            row1["CompanyName"] = "M";    
            
            adapter.Update(ds, "Customers");
            dataGrid1.DataSource = ds.DefaultViewManager;
        }
        catch(OleDbException exp)
        {
            MessageBox.Show(exp.Message.ToString());
        }
        if(conn.State == ConnectionState.Open)
            conn.Close();                   
    }
  private void DeleteCommand_Click(object sender, System.EventArgs e)
    {
    }
}