Set Data Binding with DataViewManager
using System; using System.Configuration; using System.Data; using System.Data.Common; using System.Data.SqlClient; using System.Windows.Forms; class Form1 : Form { public Form1() { InitializeComponent(); } private void getData_Click(object sender, EventArgs e) { string orders = "SELECT * FROM Orders"; string customers = "SELECT * FROM Customers"; using (SqlConnection con = new SqlConnection(ConfigurationSettings.ConnectionStrings["northwind"].ConnectionString)) { 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"); } } private void InitializeComponent() { this.getData = new System.Windows.Forms.Button(); this.dataGrid = new System.Windows.Forms.DataGrid(); this.SuspendLayout(); // // getData // this.getData.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); this.getData.Location = new System.Drawing.Point(684, 558); this.getData.Name = "getData"; this.getData.TabIndex = 0; this.getData.Text = "Get Data"; this.getData.Click += new System.EventHandler(this.getData_Click); // // dataGrid // this.dataGrid.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.dataGrid.Location = new System.Drawing.Point(13, 13); this.dataGrid.Name = "dataGrid"; this.dataGrid.Size = new System.Drawing.Size(745, 534); this.dataGrid.TabIndex = 1; // // Form1 // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(771, 593); this.Controls.Add(this.dataGrid); this.Controls.Add(this.getData); this.Name = "Form1"; this.Text = "Form1"; this.ResumeLayout(false); } private System.Windows.Forms.Button getData; private System.Windows.Forms.DataGrid dataGrid; [STAThread] static void Main() { Application.EnableVisualStyles(); Application.Run(new Form1()); } }
1. | Fill a DataGrid | ||
2. | Set SelectCommand | ||
3. | Bind related tables | ||
4. | Set up relation between two tables | ||
5. | Set DataSource from DataSet |