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

最新推荐文章于 2025-03-04 19:23:19 发布

原创最新推荐文章于 2025-03-04 19:23:19 发布 · 645 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#dataset #string #datagrid #table #date

本文介绍如何使用DataSet进行数据操作，包括创建DataSet、向DataSet添加DataTable、创建表间关系及浏览表间关系等步骤。通过示例代码展示具体实现过程。

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

}