大概说明:myDataSet里面有两个Table,dept得主键deptid是users的外键,我想使两个标关联起来显示到dataGridView1中,可是就是实现不了,清高手帮我看看怎么做好://本人的代码,有问题。
DataColumn parentColumn = myDataSet.Tables["dept"].Columns["deptid"];
DataColumn childColumn = myDataSet.Tables["users"].Columns["deptid"];
DataRelation deptusers = new DataRelation("deus",parentColumn, childColumn);
myDataSet.Relations.Add(deptusers); BindingSource bindingSource = new BindingSource();
bindingSource.DataSource = myDataSet.Tables["dept"];
dataGridView1.DataSource = bindingSource;
DataColumn parentColumn = myDataSet.Tables["dept"].Columns["deptid"];
DataColumn childColumn = myDataSet.Tables["users"].Columns["deptid"];
DataRelation deptusers = new DataRelation("deus",parentColumn, childColumn);
myDataSet.Relations.Add(deptusers); BindingSource bindingSource = new BindingSource();
bindingSource.DataSource = myDataSet.Tables["dept"];
dataGridView1.DataSource = bindingSource;
改成
bindingSource.DataSource = myDataSet.Tables["deus"]; 试试看
改成
bindingSource.DataSource = myDataSet.Tables["deus"]; 试试看
{DataSet1.Tables["Customers"].Columns["CustID"],
DataSet1.Tables["Customers"].Columns["OrdID"]};
DataColumn[] childCols= new DataColumn[]
{DataSet1.Tables["Orders"].Columns["CustID"],
DataSet1.Tables["Orders"].Columns["OrdID"]}; DataRelation CustOrderRel = new DataRelation("CustomersOrders", parentCols, childCols); DataSet1.Relations.Add(CustOrderRel);