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

Home
C# / CSharp Tutorial
1.Language Basics
2.Data Type
3.Operator
4.Statement
5.String
6.struct
7.Class
8.Operator Overload
9.delegate
10.Attribute
11.Data Structure
12.Assembly
13.Date Time
14.Development
15.File Directory Stream
16.Preprocessing Directives
17.Regular Expression
18.Generic
19.Reflection
20.Thread
21.I18N Internationalization
22.LINQ
23.GUI Windows Forms
24.Windows Presentation Foundation
25.Windows Communication Foundation
26.Workflow
27.2D
28.Design Patterns
29.Windows
30.XML
31.XML LINQ
32.ADO.Net
33.Network
34.Directory Services
35.Security
36.unsafe
C# / CSharp Tutorial » ADO.Net » DataGrid 
32.52.1.Load data in DataTable to DataGrid
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 Disposebool disposing )
  {
    ifdisposing )
    {
      if (components != null
      {
        components.Dispose();
      }
    }
    base.Disposedisposing );
  }

  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(88);
    this.dataGrid1.Name = "dataGrid1";
    this.dataGrid1.Size = new System.Drawing.Size(400264);
    this.dataGrid1.TabIndex = 0;
    // 
    // DataTableCreateInCode
    // 
    this.AutoScaleBaseSize = new System.Drawing.Size(513);
    this.ClientSize = new System.Drawing.Size(416285);
    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
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.