class1.cs

C#2005 实例源代码

using System;
using System.Data;
using System.Data.SqlClient;

namespace DataReader_Create
{
	/// <summary>
	/// 使用SqlCommand获取DataReader
	/// </summary>
	class T
	{
		/// <summary>
		/// 使用SqlCommand获取DataReader
		/// </summary>
		private void CreateDataReader()
		{
			//连接数据库
			SqlConnection myCon = new SqlConnection("Persist Security Info=False;User id=sa;pwd=sa;database=northwind;server=(local)");
			myCon.Open();

			//使用SqlCommand
			SqlCommand selectCMD = new SqlCommand("SELECT top 10 CustomerID, CompanyName FROM Customers",myCon);

			//创建 SqlDataReader
			SqlDataReader custDR=selectCMD.ExecuteReader();


			//输出查询的数据
			while(custDR.Read())
			{
				Console.Write("{0}	",custDR.GetString(custDR.GetOrdinal("CustomerID")));
				Console.Write("{0}	",custDR.GetString(custDR.GetOrdinal("CompanyName")));
				Console.WriteLine();
			}
			//断开连接
			myCon.Close();		
		}
 
		/// <summary>
		/// 应用程序的主入口点。
		/// </summary>
		[STAThread]
		static void Main(string[] args)
		{
			T t=new T();
			t.CreateDataReader();
		}
	}
}