Mega Code Archive

 

Categories / C# / ADO Database

 

Set up DataRelation

using System; using System.Data; using System.Data.SqlClient; using System.Collections.Generic; using System.Text; class Program {     static void Main(string[] args) {         SqlConnection thisConnection = new SqlConnection(              @"Server=(local)\sqlexpress;Integrated Security=True;" +              "Database=northwind");         SqlDataAdapter thisAdapter = new SqlDataAdapter(              "SELECT CustomerID, CompanyName FROM Customers", thisConnection);         SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter);         DataSet thisDataSet = new DataSet();         SqlDataAdapter custAdapter = new SqlDataAdapter(              "SELECT * FROM Customers", thisConnection);         SqlDataAdapter orderAdapter = new SqlDataAdapter(              "SELECT * FROM Orders", thisConnection);         custAdapter.Fill(thisDataSet, "Customers");         orderAdapter.Fill(thisDataSet, "Orders");         DataRelation custOrderRel = thisDataSet.Relations.Add("CustOrders",              thisDataSet.Tables["Customers"].Columns["CustomerID"],              thisDataSet.Tables["Orders"].Columns["CustomerID"]);         foreach (DataRow custRow in thisDataSet.Tables["Customers"].Rows) {             Console.WriteLine("Customer ID: " + custRow["CustomerID"] +                               " Name: " + custRow["CompanyName"]);             foreach (DataRow orderRow in custRow.GetChildRows(custOrderRel)) {                 Console.WriteLine("  Order ID: " + orderRow["OrderID"]);             }         }         thisConnection.Close();     } }