Using OracleCommandBuilder : Oracle « ADO.Net « C# / CSharp Tutorial

1. C# / CSharp Tutorial
2. ADO.Net
3. Oracle

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.OracleClient;

  public class Form1 : System.Windows.Forms.Form
  {
    public Form1()
    {
      this.btnConnect = new System.Windows.Forms.Button();
      this.btnClear = new System.Windows.Forms.Button();
      this.btnLoad = new System.Windows.Forms.Button();
      this.dgPlayerTable = new System.Windows.Forms.DataGrid();
      this.btnUpdate = new System.Windows.Forms.Button();
      this.btnBind = new System.Windows.Forms.Button();
      ((System.ComponentModel.ISupportInitialize)(this.dgPlayerTable)).BeginInit();
      this.SuspendLayout();
      this.btnConnect.Location = new System.Drawing.Point(16, 12);
      this.btnConnect.Text = "C&onnect";
      this.btnConnect.Click += new System.EventHandler(this.btnConnect_Click);
      this.btnClear.Location = new System.Drawing.Point(16, 84);
      this.btnClear.Text = "&Clear Grid";
      this.btnClear.Click += new System.EventHandler(this.btnClear_Click);
      this.btnLoad.Location = new System.Drawing.Point(16, 120);
      this.btnLoad.Text = "&Load Grid";
      this.btnLoad.Click += new System.EventHandler(this.btnLoad_Click);
      this.dgPlayerTable.DataMember = "";
      this.dgPlayerTable.HeaderForeColor = System.Drawing.SystemColors.ControlText;
      this.dgPlayerTable.Location = new System.Drawing.Point(108, 12);
      this.dgPlayerTable.Size = new System.Drawing.Size(476, 244);
      this.btnUpdate.Location = new System.Drawing.Point(16, 156);
      this.btnUpdate.Text = "U&pdate";
      this.btnUpdate.Click += new System.EventHandler(this.btnUpdate_Click);
      this.btnBind.Location = new System.Drawing.Point(16, 48);
      this.btnBind.Text = "&Bind";
      this.btnBind.Click += new System.EventHandler(this.btnBind_Click);
      this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
      this.ClientSize = new System.Drawing.Size(594, 266);
      this.Controls.Add(this.btnBind);
      this.Controls.Add(this.btnUpdate);
      this.Controls.Add(this.dgPlayerTable);
      this.Controls.Add(this.btnLoad);
      this.Controls.Add(this.btnClear);
      this.Controls.Add(this.btnConnect);
      this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.Fixed3D;
      this.Name = "Form1";
      this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
      this.Text = "OracleDataAdapter Sample";
      this.Load += new System.EventHandler(this.Form1_Load);
      ((System.ComponentModel.ISupportInitialize)(this.dgPlayerTable)).EndInit();
      this.ResumeLayout(false);

    }
    static void Main() 
    {
      Application.Run(new Form1());
    }

    private System.Windows.Forms.Button btnConnect;
    private System.Windows.Forms.Button btnClear;
    private System.Windows.Forms.Button btnLoad;
    private System.Windows.Forms.DataGrid dgPlayerTable;
    private System.Windows.Forms.Button btnUpdate;
    private System.Windows.Forms.Button btnBind;

    public OracleConnection oraConn;
    public OracleDataAdapter oraAdapter;
    public OracleCommandBuilder oraBuilder;
    public DataSet dsPlayerTable;

    private void btnConnect_Click(object sender, System.EventArgs e)
    {
      string connString = "User Id=oranetuser; Password=demo; Data Source=oranet";
      if (oraConn.State != ConnectionState.Open)
      {
        try
        {
          oraConn.ConnectionString = connString;

          oraConn.Open();

          MessageBox.Show(oraConn.ConnectionString, "Successful Connection");
        }
        catch (Exception ex)
        {
          MessageBox.Show(ex.Message,"Exception Caught");
        }
      }    
    }

    private void Form1_Load(object sender, System.EventArgs e)
    {
      oraConn = new OracleConnection();
    }

    private void btnBind_Click(object sender, System.EventArgs e)
    {
      if (oraConn.State == ConnectionState.Open)
      {
        string strSelect = "select player_num, last_name, first_name, from PlayerTable order by player_num";
        oraAdapter = new OracleDataAdapter(strSelect, oraConn);
        oraBuilder = new OracleCommandBuilder(oraAdapter);
        dsPlayerTable = new DataSet("dsPlayerTable");
        oraAdapter.Fill(dsPlayerTable,"PlayerTable");
        dgPlayerTable.SetDataBinding(dsPlayerTable,"PlayerTable");

        btnBind.Enabled = false;
      }
    }

    private void btnClear_Click(object sender, System.EventArgs e)
    {
      dsPlayerTable.Clear();
      dgPlayerTable.SetDataBinding(null,null);
    }

    private void btnLoad_Click(object sender, System.EventArgs e)
    {
      btnClear_Click(sender, e);

      oraAdapter.Fill(dsPlayerTable,"PlayerTable");

      dgPlayerTable.SetDataBinding(dsPlayerTable,"PlayerTable");      
    }

    private void btnUpdate_Click(object sender, System.EventArgs e)
    {
      oraAdapter.Update(dsPlayerTable,"PlayerTable");
    }
  }