c#ADO.NET连接SQL Server（framework）

连接SQL Server（framework）

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

namespace ADONET01
{
    class Program
    {
        static void Main(string[] args)
        {
            //编辑数据库连接
            string connStr = "Data Source=.;Initial Catalog=数据库名称;User ID=sa;Password=密码";

            //创建SqlConnection的实例
            SqlConnection conn = null;

            //定义SqlDataReader类的对象
            SqlDataReader dr = null;

            try
            {
                conn = new SqlConnection(connStr);
                //打开数据库连接
                conn.Open();
                string sql = "select * from MyQuestion";
                //填充SQL语句
                //创建SQLcommand对象
                SqlCommand cmd = new SqlCommand(sql, conn);
                //执行SQL语句
                dr = cmd.ExecuteReader();
                while (dr.Read()){
                    Console.WriteLine("id=" + dr[0] + "| cn=" + dr[1]);
                }
            }
            catch(Exception ex)
            {
                Console.WriteLine(ex.Message);
            }

            Console.WriteLine("222");
            Console.ReadLine();
        }
    }
}