dataxmlapp.cs

来自「Csharp实例编程百例.rar」· CS 代码 · 共 47 行

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

namespace DataXmlApp
{
	class DataXml
	{
		public static void Main() 
		{
			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);
			custAdapter.Fill(dataset, "Customers");

			OleDbDataAdapter orderAdapter = new OleDbDataAdapter(
				"SELECT * FROM Orders", connection);
			orderAdapter.Fill(dataset, "Orders");

			OleDbDataAdapter detailAdapter = new OleDbDataAdapter(
				"SELECT * FROM [Order Details]", connection);  
			detailAdapter.Fill(dataset, "Order Details");

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

			DataRelation orderDetailRel = dataset.Relations.Add("OrderDetail",
				dataset.Tables["Orders"].Columns["OrderID"],
				dataset.Tables["Order Details"].Columns["OrderID"]);
			orderDetailRel.Nested = true;

			dataset.WriteXml(@"c:\nwinddata.xml");

			Console.WriteLine(@"Successfully wrote XML output to file c:\nwinddata.xml");

			connection.Close();
		}
	}
}