class1.cs

C#2005 实例源代码

using System;
using System.Data.SqlClient;

namespace ADO_SqlConnection
{
	/// <summary>
	/// 连接SQLServer数据库示例
	/// </summary>
	class T
	{
		/// <summary>
		/// 连接SQLServer数据库示例
		/// </summary>
		public void CreateSqlConnection() 
		{
			//得到一个SqlConnection
			SqlConnection myCon = new SqlConnection();
			//构造连接字符串
			myCon.ConnectionString = "Persist Security Info=False;User id=sa;pwd=sa;database=northwind;server=(local)";
			//建立连接
			myCon.Open();
			//输出连接状态
			Console.WriteLine("{0}",myCon.State);	//输出：Open

			//断开连接
			myCon.Close();
			//输出连接状态
			Console.WriteLine("{0}",myCon.State);	//输出：Closed
		}


		/// <summary>
		/// 应用程序的主入口点。
		/// </summary>
		[STAThread]
		static void Main(string[] args)
		{
			T t=new T();
			t.CreateSqlConnection();
		}
	}
}