Load data in DataTable to DataGrid : DataGrid « ADO.Net « C# / CSharp Tutorial





Load data in DataTable to DataGrid
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;
  }
}










32.52.DataGrid
32.52.1.Load data in DataTable to DataGridLoad data in DataTable to DataGrid
32.52.2.Link two DataTable in a DataGridLink two DataTable in a DataGrid
32.52.3.Load Data to DataGridLoad Data to DataGrid
32.52.4.DataGrid View: on data error
32.52.5.Data binding for Multiple Controls
32.52.6.Binding DataSet to DataGrid
32.52.7.Programmatic Data Display