学习笔记》ADO.NET》在ADO.NET中使用DataSet

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”]);

}

}

}