ADO.net 建立连接

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

namespace ADO.NETDEMO
{
    class Program
    {
        static void Main(string[] args)
        {
            定义连接字符串1-最标准的
            string connString = "Server=.;DataBase = SchoolDB22New;Uid = sa;Pwd=pa55worD";

            //定义连接字符串2-只用于本地连接测试
            //string connString = "Data source=WXCNL-5198\\SQLEXPRESS;initial catalog=SchoolDB22New;integrated security=True";
           
            //创建连接对象
            SqlConnection conn = new SqlConnection(connString);

            //打开连接
            conn.Open();
            //判断连接是否打开
            if(ConnectionState.Open == conn.State)
            {
                Console.WriteLine("connection is opened!");

            }
            //关闭连接
            conn.Close();
            if (ConnectionState.Closed == conn.State)
            {
                Console.WriteLine("connection is Closed!");
            }
            Console.ReadLine();
        }
    }
}