public GetChildRows ( |
||
relation | ||
return | System.Data.DataRow[] |
// create a DataTable for 'Employees' and 'Orders' DataTable dtEmployees = new DataTable("Employees"); DataTable dtOrders = new DataTable("Orders"); // add columns to 'Employees' table dtEmployees.Columns.Add("EmployeeID", typeof(int)); dtEmployees.Columns.Add("EmployeeName", typeof(string)); // add columns to 'Orders' table dtOrders.Columns.Add("OrderID", typeof(int)); dtOrders.Columns.Add("OrderDate", typeof(DateTime)); dtOrders.Columns.Add("EmployeeID", typeof(int)); // add some data to 'Employees' table dtEmployees.Rows.Add(1, "John"); dtEmployees.Rows.Add(2, "Mary"); // add some data to 'Orders' table dtOrders.Rows.Add(1, DateTime.Now, 1); dtOrders.Rows.Add(2, DateTime.Now, 1); dtOrders.Rows.Add(3, DateTime.Now, 2); // get all orders for employee with ID 1 DataRow[] childRows = dtEmployees.Rows[0].GetChildRows("Employee_Orders"); foreach(DataRow row in childRows) { Console.WriteLine("Order ID: " + row["OrderID"]); Console.WriteLine("Order Date: " + row["OrderDate"]); }
// create a DataTable for 'Products' and 'OrderItems' DataTable dtProducts= new DataTable("Products"); DataTable dtOrderItems = new DataTable("OrderItems"); // add columns to 'Products' table dtProducts.Columns.Add("ProductID", typeof(int)); dtProducts.Columns.Add("ProductName", typeof(string)); // add columns to 'OrderItems' table dtOrderItems.Columns.Add("OrderItemID", typeof(int)); dtOrderItems.Columns.Add("OrderItemAmount", typeof(decimal)); dtOrderItems.Columns.Add("ProductID", typeof(int)); // add some data to 'Products' table dtProducts.Rows.Add(1, "Product A"); dtProducts.Rows.Add(2, "Product B"); // add some data to 'OrderItems' table dtOrderItems.Rows.Add(1, 10.5, 1); dtOrderItems.Rows.Add(2, 15.2, 1); dtOrderItems.Rows.Add(3, 8.9, 2); // get all order items for product with ID 1 DataRow[] childRows = dtProducts.Rows[0].GetChildRows("Product_OrderItems"); foreach(DataRow row in childRows) { Console.WriteLine("Order Item ID: " + row["OrderItemID"]); Console.WriteLine("Order Item Amount: " + row["OrderItemAmount"]); }The DataRow.GetChildRows method is part of the System.Data.dll package library.
public GetChildRows ( |
||
relation | ||
return | System.Data.DataRow[] |