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;
}
}
|
