Data Binding : DataBinding DataGrid : ADO.Net C# Examples

    
using  System;
using  System.Drawing;
using  System.Collections;
using  System.ComponentModel;
using  System.Windows.Forms;
using  System.Data;
using  System.Data.OleDb;
using  System.Data.SqlClient;

public  class  DataGridDataBiningDatabase  :  System.Windows.Forms.Form
{
    private  System.Windows.Forms.DataGrid  dataGrid1;
    private  System.Windows.Forms.ListBox  listBox1;

    private  System.ComponentModel.Container  components  =  null;

    public  DataGridDataBiningDatabase()
    {
        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.listBox1  =  new  System.Windows.Forms.ListBox();
        ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
        this.SuspendLayout();
        //  
        //  dataGrid1
        //  
        this.dataGrid1.DataMember  =  "";
        this.dataGrid1.Location  =  new  System.Drawing.Point(8,  24);
        this.dataGrid1.Name  =  "dataGrid1";
        this.dataGrid1.Size  =  new  System.Drawing.Size(192,  232);
        this.dataGrid1.TabIndex  =  0;
        //  
        //  listBox1
        //  
        this.listBox1.Location  =  new  System.Drawing.Point(216,  32);
        this.listBox1.Name  =  "listBox1";
        this.listBox1.Size  =  new  System.Drawing.Size(104,  212);
        this.listBox1.TabIndex  =  1;
        //  
        //  DataGridDataBiningDatabase
        //  
        this.AutoScaleBaseSize  =  new  System.Drawing.Size(5,  13);
        this.ClientSize  =  new  System.Drawing.Size(480,  277);
        this.Controls.AddRange(new  System.Windows.Forms.Control[]  {this.listBox1,  this.dataGrid1});
        this.Name  =  "DataGridDataBiningDatabase";
        this.Text  =  "DataGridDataBiningDatabase";
        this.Load  +=  new  System.EventHandler(this.DataGridDataBiningDatabase_Load);
        ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
        this.ResumeLayout(false);
    }
    [STAThread]
    static  void  Main()  
    {
        Application.Run(new  DataGridDataBiningDatabase());
    }

    private  void  FillDataGrid()
    {
        string  ConnectionString  =  @"Provider=Microsoft.Jet.OLEDB.4.0;  Data  Source=c:\Northwind.mdb";
        OleDbConnection  conn  =  new  OleDbConnection(ConnectionString);
        string  SQL  =  "SELECT  *  FROM  Customers";

        conn.Open();

        OleDbDataAdapter  adapter  =  new  OleDbDataAdapter(SQL,  conn);

        DataSet  ds  =  new  DataSet("Customers");
        adapter.Fill(ds,  "Customers");

        dataGrid1.DataSource  =  ds.DefaultViewManager;

        conn.Close();        
    }

    private  void  FillListBox()
    {
        string  ConnectionString  =  @"Provider=Microsoft.Jet.OLEDB.4.0;  Data  Source=c:\Northwind.mdb";
        OleDbConnection  conn  =  new  OleDbConnection(ConnectionString);
        string  SQL  =  "SELECT  *  FROM  Customers";

        conn.Open();

        OleDbDataAdapter  adapter  =  new  OleDbDataAdapter(SQL,  conn);

        DataSet  ds  =  new  DataSet("Customers");
        adapter.Fill(ds,  "Customers");

        listBox1.DataSource  =  ds.DefaultViewManager;
        listBox1.DisplayMember  =  "CustomerID";

        conn.Close();        
    }

    private  void  DataGridDataBiningDatabase_Load(object  sender,  System.EventArgs  e)
    {
        FillListBox();
        FillDataGrid();
    }
}