Load data in DataTable to DataGrid : DataGrid : ADO.Net C# Examples

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

public  class  DataTableCreateInCode  :  System.Windows.Forms.Form
{
    private  System.Windows.Forms.DataGrid  dataGrid1;
    private  System.ComponentModel.Container  components  =  null;

    public  DataTableCreateInCode()
    {
        InitializeComponent();
    
        //  dcConstructorsTest();
        CreateCustTable();        
        }

    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();
        ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
        this.SuspendLayout();
        //  
        //  dataGrid1
        //  
        this.dataGrid1.DataMember  =  "";
        this.dataGrid1.Location  =  new  System.Drawing.Point(8,  8);
        this.dataGrid1.Name  =  "dataGrid1";
        this.dataGrid1.Size  =  new  System.Drawing.Size(400,  264);
        this.dataGrid1.TabIndex  =  0;
        //  
        //  DataTableCreateInCode
        //  
        this.AutoScaleBaseSize  =  new  System.Drawing.Size(5,  13);
        this.ClientSize  =  new  System.Drawing.Size(416,  285);
        this.Controls.AddRange(new  System.Windows.Forms.Control[]  {
                                                                        this.dataGrid1});
        this.Name  =  "DataTableCreateInCode";
        this.Text  =  "DataTableCreateInCode";
        ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
        this.ResumeLayout(false);

    }

    [STAThread]
    static  void  Main()  
    {
        Application.Run(new  DataTableCreateInCode());
    }


    private  void  dcConstructorsTest()
    {
        //  Create  Customers  table
        DataTable  custTable  =  new  DataTable("Customers");
        DataSet  dtSet  =  new  DataSet();

        //  Create  Price  Column                    
        System.Type  myDataType;
        myDataType  =  System.Type.GetType("System.Int32");
        DataColumn  priceCol  =  new  DataColumn("Price",  myDataType  );
        priceCol.Caption  =  "Price";
        custTable.Columns.Add(priceCol);

        //  Create  Quantity  Column
        DataColumn  qtCol  =  new  DataColumn("Quantity");
        qtCol.DataType  =  System.Type.GetType("System.Int32");
        qtCol.Caption  =  "Quantity";
        custTable.Columns.Add(qtCol);
                
        //  Creating  an  expression
        string  strExpr  =  "Price  *  Quantity";

        //  Create  Total  Column,  which  is  result  of  Price*Quantity
        DataColumn  totCol  =  new  DataColumn("Total",  myDataType,  strExpr,  MappingType.Attribute);
        totCol.Caption  =  "Total";
        //  Add  Name  column  to  the  table.
        custTable.Columns.Add(totCol);

        //  Add  custTable  to  DataSet
        dtSet.Tables.Add(custTable);

        //  Bind  dataset  to  the  data  grid
        dataGrid1.SetDataBinding(dtSet,"Customers");

    }


    //  Create  a  DataTable
    private  void  CreateCustTable()
    {
        //  Create  a  new  DataTable
        DataTable  custTable  =  new  DataTable("Customers");

        //  Create  ID  Column
        DataColumn  IdCol  =  new  DataColumn();
        IdCol.ColumnName=  "ID";
        IdCol.DataType  =  Type.GetType("System.Int32");
        IdCol.ReadOnly  =  true;
        IdCol.AllowDBNull  =  false;
        IdCol.Unique  =  true;
        IdCol.AutoIncrement  =  true;
        IdCol.AutoIncrementSeed  =  1;
        IdCol.AutoIncrementStep  =  1;
        custTable.Columns.Add(IdCol);

        //  Create  Name  Column
        DataColumn  nameCol  =  new  DataColumn();
        nameCol.ColumnName=  "Name";
        nameCol.DataType  =  Type.GetType("System.String");
        custTable.Columns.Add(nameCol);

        //  Create  Address  Column
        DataColumn  addCol  =  new  DataColumn();
        addCol.ColumnName=  "Address";
        addCol.DataType  =  Type.GetType("System.String");
        custTable.Columns.Add(addCol);

        //  Create  DOB  Column
        DataColumn  dobCol  =  new  DataColumn();
        dobCol.ColumnName=  "DOB";
        dobCol.DataType  =  Type.GetType("System.DateTime");
        custTable.Columns.Add(dobCol);

        //  VAR  Column
        DataColumn  fullTimeCol  =  new  DataColumn();
        fullTimeCol.ColumnName=  "VAR";
        fullTimeCol.DataType  =  Type.GetType("System.Boolean");
        custTable.Columns.Add(fullTimeCol);

        //  Make  the  ID  column  the  primary  key  column.
        DataColumn[]  PrimaryKeyColumns  =  new  DataColumn[1];
        PrimaryKeyColumns[0]  =  custTable.Columns["ID"];
        custTable.PrimaryKey  =  PrimaryKeyColumns;
        
        //  Create  a  dataset
        DataSet  ds  =  new  DataSet("Customers");
        //  Add  Customers  table  to  the  dataset
        ds.Tables.Add(custTable);  
        //  Attach  the  data  set  to  a  DataGrid
        dataGrid1.DataSource  =  ds.DefaultViewManager;
    }
}