datareader2.cs

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

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

namespace DataReader2App
{
	/// <summary>
	/// Class1 的摘要说明。
	/// </summary>
	class DataReader2
	{
		/// <summary>
		/// 应用程序的主入口点。
		/// </summary>
		[STAThread]
		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();

			OleDbCommand command = connection.CreateCommand();

			command.CommandText = "SELECT EmployeeID, FirstName,LastName from Employees";

			OleDbDataReader reader = command.ExecuteReader();

			while(reader.Read())
			{
				Console.WriteLine("\t{0}\t{1}\t{2}",reader["EmployeeID"],reader["FirstName"],reader["LastName"]);

			}

			reader.Close();
			connection.Close();
		}
	}
}