110,538
社区成员
发帖
与我相关
我的任务
分享
string orders = "SELECT * FROM Orders";
string customers = "SELECT * FROM Customers";
SqlConnection conn = new SqlConnection(source);
SqlDataAdapter da = new SqlDataAdapter(orders,conn);
DataSet ds = new DataSet();
da.Fill(ds,"Orders");
da = new SqlDataAdapter(customers,conn);
da.Fill(ds,"Customers");
ds.Relations.Add("CustomerOrders",ds.Tables["Customers"].Columns["CustomerID"], ds.Tables["Orders"].Columns["CustomerID"]);
dataGrid1.SetDataBinding(ds,"Customers");