//Handle the Load Button Click
//Load the Customers, Orders and OrderDetails Tables and display in the Grid
private void buttonLoad_Click(object sender, System.EventArgs e) {
Cursor currentCursor = Cursor.Current;
SqlConnection con = new SqlConnection("server=(local);Integrated Security=SSPI;database=northwind");
try {
Cursor.Current = Cursors.WaitCursor;
//Fill the DataSet
SqlDataAdapter cmdCustomers = new SqlDataAdapter("Select * from Customers", con);
SqlDataAdapter cmdOrders = new SqlDataAdapter("Select * from Orders", con);
SqlDataAdapter cmdOrderDetails = new SqlDataAdapter("Select * from [Order Details]", con);
customersDataSet1.Clear();
statusBar1.Text ="Loading Customers...";
cmdCustomers.Fill(customersDataSet1, "Customers");
statusBar1.Text ="Loading Orders...";
cmdOrders.Fill(customersDataSet1, "Orders");
statusBar1.Text ="Loading Order Details...";
cmdOrderDetails.Fill(customersDataSet1, "Order_Details");
statusBar1.Text ="Updating Grid...";
} finally {
statusBar1.Text ="Done";
Cursor.Current = currentCursor;
con.Close();
}
}
protected override void Dispose(bool disposing)
{
if (disposing) {
if (components != null) {
components.Dispose();
}
}
base.Dispose(disposing);
}
private void InitializeComponent() {
this.components = new System.ComponentModel.Container();
this.dataGrid1 = new System.Windows.Forms.DataGrid();
this.statusBar1 = new System.Windows.Forms.StatusBar();
this.customersDataSet1 = new Microsoft.Samples.WinForms.Cs.Grid.Data.CustomersDataSet();
this.buttonLoad = new System.Windows.Forms.Button();
Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter
MyConnection = New SqlConnection("server=(local)\NetSDK;database=pubs;Trusted_Connection=yes")
MyCommand = New SqlDataAdapter("select * from Authors", MyConnection)
DS = new DataSet()
MyCommand.Fill(ds, "作者")
MyDataGrid.DataSource=ds.Tables("作者").DefaultView
MyDataGrid.DataBind()
End Sub