ADO.NET组件与数据库连接

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

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

namespace ADO.NETDemo
{
    class Program
    {
        static void Main(string[] args)
        {
            //定义连接字符串
            string connstring = "Server=F-PC\\SQLEXPRESS;DataBase=StudentManageDB;Uid=sa;Pwd=123456";
            //创建对象
            SqlConnection conn = new SqlConnection(connstring);
            //打开连接
            conn.Open();
            //判断连接是否打开
            if(ConnectionState.Open==conn.State)
                Console.WriteLine("Connection is opened!");
            if(ConnectionState.Open==conn.State)
                Console.WriteLine("Connection is closed!");
            Console.ReadLine();
        }
    }
}