MultiTableApp

转载于 2006-09-30 17:40:00 发布 · 657 阅读

文章标签：

#dataset #class #system #string

C# 专栏收录该内容

30 篇文章

订阅专栏

本文演示了如何使用 C# 和 OleDb 在两个表（Customers 和 Orders）之间建立数据关系，并遍历显示客户及其订单信息。

using System;
using System.Data;
using System.Data.OleDb;

namespace MultiTableApp
{
/// <summary>
/// Class1 腔晡猁佽隴﹝
/// </summary>
class MultiTable
{
  static void Main(string[] args)
  {
   OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:/C#Program/C#100/Chapter3/NWIND.mdb");

connection.Open();

   DataSet dataset = new DataSet();

   OleDbDataAdapter custAdapter = new OleDbDataAdapter("SELECT * FROM Customers",connection);
   OleDbDataAdapter orderAdapter = new OleDbDataAdapter("SELECT * FROM Orders",connection);

   custAdapter.Fill(dataset,"Customers");
   orderAdapter.Fill(dataset,"Orders");

   DataRelation custOrderRel = dataset.Relations.Add("CustOrders",
    dataset.Tables["Customers"].Columns["CustomerID"],
    dataset.Tables["Orders"].Columns["CustomerID"]);

   foreach(DataRow custRow in dataset.Tables["Customers"].Rows)
   {
    Console.WriteLine("CumtomerID:" + custRow["CustomerID"] + " Name: " + custRow["CompanyName"]);

    foreach(DataRow orderRow in custRow.GetChildRows(custOrderRel))
    {
     Console.WriteLine("   OrderID:" + orderRow["OrderID"]);
    }
   }
   connection.Close();
  }
}
}