ADO.NET中的多数据表操作之读取

this.dataGridCustomers.DataSource = _ds;

this.dataGridCustomers.DataMember = _ds.Customers.TableName;

this.dataGridOrders.DataSource = _ds;

this.dataGridOrders.DataMember = _ds.Customers.TableName+"."+_ds.Customers.ChildRelations[0].RelationName;

this.dataGridOrderDetails.DataSource = _ds;

this.dataGridOrderDetails.DataMember =_ds.Customers.TableName+"."+

_ds.Customers.ChildRelations[0].RelationName+"."+

_ds.Orders.ChildRelations[0].RelationName;

}

对于上面的三个表的动态关联，你也可以使用SetDataBinding方法来完成数据的动态绑定，而不是分别指定DataGride的DataSource和DataMemger属性。

this.dataGridCustomers.SetDataBinding(_ds,_ds.Customers.TableName);

this.dataGridOrders.SetDataBinding(_ds,_ds.Customers.TableName+"."+_ds.Customers.ChildRelations[0].RelationName);

this.dataGridOrderDetails.SetDataBinding(_ds,_ds.Customers.TableName+"."+

_ds.Customers.ChildRelations[0].RelationName+"."+_ds.Orders.ChildRelations[0].RelationName);