1. 创建DataSet
DataSet ds = new DataSet();
2. 向DataSet中添加Data Table
DataSet ds = (DataSet)DataGrid1.DataSource;
DataTable table = ds.Tables.add(string);
DataTableCollections.Add();
DataTableCollections.Add(Data table);
DataTableCollections.Add(string)
DataTableCollections.Add(string,string)
3. 创建表间关系
DataSet ds = new DataSet();
DataRelations dr = ds.Relations.Add(string,ds.Tables.[datatable1].Columns[relatedColumn],ds.Tables.[datatable2].Columns[relatedColumn])
4. 浏览表间关系
DataRelations customerOrdersRelation = customerOrders.Relations.Add("custOrder",customerOrders.Tables["Customers"].Columns["CustomerID"],customerOrders.Tables["Orders"].Columns["CustomerID"]);
DataRelations orderDetailRelation = customerOrders.Relations.Add("orderDetail",customerOrders.Tables["Orders"].Columns["OrderID"],customerOrders.Tables["OrderDetails"].Columns["OrderID"]);
DataRelations orderProductRelation = customerOrders.Relations.Add(“orderProduct”,customerOrders.Tables[“Orderdetail”].Columns[“ProductID”],customerORders.Tables[“Product”].Column[“ProductID”]);
foreach(DataRow rwCustomer in customerOrders.Tables[“Customers”].Rows)
{
Console.WriteLine(“CustomerID” + rwCustomer[CustomerID]);
foreache(DataRow rwOrder in rwCustomer.GetChildRows(customerOrderRelation))
{
Console.WriteLine(“OrderID:” + rwOrder[“OrderID”]);
Console.WriteLine(“/tDate:” + rwOrder[“Date”]);
Foreach(DataRow rwOrderDetail in rwOrder.GetChildRows(orderDetailRelation))
{
Console.WriteLine(“ProductName:” + rwOrderDetail.GetParentRows[“ProductName”]);
Console>writeLine(“Quantity:” + rwOrderDetail[“Quantity”]);
}
}
}