Data Binding DataGrid : DataBinding DataGrid « GUI Windows Forms « C# / CSharp Tutorial

1. C# / CSharp Tutorial
2. GUI Windows Forms
3. DataBinding DataGrid

using System;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;
   class DataBindingForm : Form {
  private DataGrid ordersGrid;
  private TextBox customerIDTextBox;
  private Button goButton;
  public DataBindingForm()
  {
    ordersGrid = new DataGrid();
    customerIDTextBox = new TextBox();
    goButton = new Button();
    goButton.Text = "Get Orders";
    customerIDTextBox.Text = "VINET";
    goButton.Click += new EventHandler(this.GoButton_Click);
    Controls.Add(customerIDTextBox);
    Controls.Add(goButton);
    Controls.Add(ordersGrid);
    customerIDTextBox.Dock = DockStyle.Top;
    goButton.Dock = DockStyle.Bottom;
    ordersGrid.Dock = DockStyle.Fill;
  }
  public static void Main() 
  {
    DataBindingForm dbf = new DataBindingForm();
    Application.Run(dbf);
  }  
  protected void GoButton_Click(Object sender, EventArgs e)
  {
    DataSet ordersDataSet = OrdersObject.getOrders(customerIDTextBox.Text);
    ordersGrid.DataSource = ordersDataSet;
    ordersGrid.DataMember = "Orders";
  }
   }
   class OrdersObject 
   {
  public static DataSet getOrders(String customerID) 
  {
    SqlConnection conn = new SqlConnection("Server=localhost;Database=northwind;Trusted_Connection=yes;");
    DataSet ordersDataSet = new DataSet();
                SqlDataAdapter cmdSelectOrders = new SqlDataAdapter("Select * from Orders"+
                   " where CustomerID like '"+customerID+"'", conn);
                cmdSelectOrders.Fill(ordersDataSet, "Orders");
    return ordersDataSet;
  }
   }

23.78.DataBinding DataGrid
	23.78.1.	Data binding to a programatically created dataset to a DataGrid
	23.78.2.	Table Create/Row Delete
	23.78.3.	Binding to DataGrid
	23.78.4.	DataReader Binding
	23.78.5.	Using a BindingSource to bind a list to a DataGridView control.
	23.78.6.	Data Binding DataGrid