C#(二十二) —— ADO.NET初步使用暨连接数据库

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

namespace ADONETDemo
{
    internal class Program
    {
        private static void Main(string[] args)
        {
            //server 数据库 账号  密码
            //string connString = "Server=IP号;DataBase=MyPhoneList;Uid=123;Pwd=123";//有效
            //string connString = "Server=.;DataBase=MyPhoneList;Uid=123;Pwd=123";//有效
            string connString = "Server=localhost;DataBase=MyPhoneList;Uid=123;Pwd=123;//有效

            SqlConnection sqlConnection = new SqlConnection(connString);
            sqlConnection.Open();
            //ConnectionState可用来查看连接情况
            if (ConnectionState.Open == sqlConnection.State)
            {
                Console.WriteLine("连接成功");
            }
            sqlConnection.Close();
            if (ConnectionState.Closed == sqlConnection.State)
            {
                Console.WriteLine("关闭成功");
            }
            Console.ReadLine();
        }
    }
}