datagridview显示父子表

Question

 
ds.Relations.Add(new DataRelation("CustOrders",ds.Tables["Customers"].Columns["CustomerID"], ds.Tables["Orders"].Columns["CustomerID"]));                
dgvInfo.DataSource = ds;
dgvInfo.DataMember = ds.Tables["Customers"].ToString();
dgvDetail.DataSource = ds;
dgvDetail.DataMember = "Customers.CustOrders";

Answer 1

只用一DataGridView 中显示父子表关系呢 

Answer 2

DataSet myds = new DataSet();
SqlDataAdapter CustomerDa;

string connectionstr = "server=localhost;database=northwind;uid=sa;pwd=";
SqlConnection myconn = new SqlConnection(connectionstr);
myconn.Open();
string OrdersSql = "select CustomerID,ShipName from Orders";
string CustomersSql = "select CustomerID,CompanyName,Country from Customers";
SqlDataAdapter OrderDa = new SqlDataAdapter(OrdersSql,myconn);
CustomerDa = new SqlDataAdapter(CustomersSql,myconn);
OrderDa.Fill(myds,"Orders");
CustomerDa.Fill(myds,"Customers");
myds.Relations.Add("OrderCustomers",
myds.Tables["Customers"].Columns["CustomerID"],
myds.Tables["Orders"].Columns["CustomerID"]);
DataGrid1.SetDataBinding(myds,"Customers");

Answer 3

DataGridView 显示不了父子表。
可以使用DataGrid控件。