DataSourceDataViewManager.cs
上传用户:lxycoco
上传日期:2022-07-21
资源大小:38457k
文件大小:3k
- using System;
- using System.Windows.Forms;
- using System.Data;
- using System.Data.SqlClient;
- /// <summary>
- /// This class provides an example of creating and using a data grid.
- /// </summary>
- public class DataSourceDataViewManager : System.Windows.Forms.Form
- {
- private System.Windows.Forms.Button retrieveButton ;
- private System.Windows.Forms.DataGrid dataGrid ;
- /// <summary>
- /// Construct the window.
- /// </summary>
- /// <remarks>
- /// This method constructs the window by creating both the data grid and the button.
- /// </remarks>
- public DataSourceDataViewManager ( )
- {
- this.AutoScaleBaseSize = new System.Drawing.Size (5, 13);
- this.ClientSize = new System.Drawing.Size (464, 253);
- this.Text = "06_DataSourceDataViewManager" ;
- this.dataGrid = new System.Windows.Forms.DataGrid ();
- dataGrid.BeginInit ();
- dataGrid.Location = new System.Drawing.Point (8, 8);
- dataGrid.Size = new System.Drawing.Size (448, 208);
- dataGrid.TabIndex = 0;
- dataGrid.Anchor = AnchorStyles.Bottom | AnchorStyles.Top | AnchorStyles.Left | AnchorStyles.Right ;
- this.Controls.Add (this.dataGrid);
- dataGrid.EndInit ();
- this.retrieveButton = new System.Windows.Forms.Button ();
- retrieveButton.Location = new System.Drawing.Point (384, 224);
- retrieveButton.Size = new System.Drawing.Size (75, 23);
- retrieveButton.TabIndex = 1;
- retrieveButton.Anchor = AnchorStyles.Bottom | AnchorStyles.Right ;
- retrieveButton.Text = "Retrieve";
- retrieveButton.Click += new System.EventHandler (this.retrieveButton_Click);
- this.Controls.Add (this.retrieveButton);
- }
- /// <summary>
- /// Retrieve the data
- /// </summary>
- /// <param name="sender"> </param>
- /// <param name="e"> </param>
- protected void retrieveButton_Click (object sender, System.EventArgs e)
- {
- retrieveButton.Enabled = false ;
- string orders = "SELECT * FROM Orders";
- string customers = "SELECT * FROM Customers";
- SqlConnection con = new SqlConnection ( Login.Connection ) ;
- SqlDataAdapter da = new SqlDataAdapter ( orders , con ) ;
- DataSet ds = new DataSet ( ) ;
- da.Fill ( ds , "Orders" ) ;
- da = new SqlDataAdapter ( customers , con ) ;
- da.Fill ( ds , "Customers" ) ;
- ds.Relations.Add("CustomerOrders",
- ds.Tables["Customers"].Columns["CustomerID"],
- ds.Tables["Orders"].Columns["CustomerID"]);
- DataViewManager dvm = new DataViewManager ( ds ) ;
-
- dvm.DataViewSettings["Customers"].RowFilter = "Country='UK'" ;
- dataGrid.SetDataBinding ( dvm , "Customers" ) ;
- }
- /// <summary>
- /// Display the application window
- /// </summary>
- static void Main()
- {
- Application.Run(new DataSourceDataViewManager());
- }
- }