using (SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS; database= NORTHWND; Persist Security Info=false; Integrated Security=true;")) { SqlCommand cmd1 = new SqlCommand(); SqlCommand cmd2 = new SqlCommand(); cmd1 = con.CreateCommand(); cmd2 = con.CreateCommand(); cmd1.CommandText = "Select * from Customers"; cmd2.CommandText = "Select * from Orders"; cmd1.Connection = con; cmd2.Connection = con; con.Open(); SqlDataAdapter adp1 = new SqlDataAdapter(cmd1); DataSet ds = new DataSet(); adp1.Fill(ds, "Customers"); SqlDataAdapter adp2 = new SqlDataAdapter(cmd2); adp2.Fill(ds, "Orders"); DataRelation relation = new DataRelation("CustomersOrders", ds.Tables["Customers"].Columns["CustomerID"], ds.Tables["Orders"].Columns["CustomerID"]); ds.Relations.Add(relation); // add relation dataGridView1.DataSource = ds; dataGridView1.DataMember = "Customers"; dataGridView2.DataSource = ds; dataGridView2.DataMember = "CustomersOrders"; // this line shows error }
DataMember
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)