dataview.cs

Csharp实例编程百例.rar

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

namespace DataViewApp
{
	class DataViewExample
	{
		static void Main()
		{
			string conStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\C#Program\C#100\Chapter3\NWIND.mdb";
			OleDbConnection Conn = new OleDbConnection(conStr);

			try
			{
				string SQL = "SELECT ContactName, Country FROM Customers";
				OleDbDataAdapter adapter = new OleDbDataAdapter();
				adapter.SelectCommand = new OleDbCommand(SQL,Conn);
      
				DataSet ds = new DataSet();      
				adapter.Fill(ds, "Customers");

				DataTable datatable = ds.Tables["Customers"];

				DataView myView = new DataView(datatable,
					"Country = 'Germany'", 
					"Country", 
					DataViewRowState.CurrentRows);

				foreach (DataRowView myDrv in myView)
				{
					for (int i = 0; i < myView.Table.Columns.Count; i++)
						Console.Write(myDrv[i] + "\t");
					Console.WriteLine();
				}
			}
			catch(Exception ex)
			{
				Console.WriteLine("Error Orccured: " + ex.Message);
				Conn.Close();
			}
			finally
			{
				Conn.Close();
				Console.ReadLine();
			}
		}   
	}
}