使用c#连接sqlserver

static void Main(string[] args)
        {

            //1.连接字符串
            string str = "Data Source=ZHOULENOVO\\SQLEXPRESS;Initial Catalog=myDB17;Integrated Security=True";

            //2.打开数据库连接
            using (SqlConnection conn = new SqlConnection(str))
            {
                //3.sql语句
                string sql = "SELECT * FROM Person";
                conn.Open();
                //4.设置sql对象

                using (SqlCommand cmd = new SqlCommand(sql, conn))
                {
                    //5.执行操作
                    var i = cmd.ExecuteReader();
                    while (i.Read())
                    {
                        Console.WriteLine(string.Format("{0},{1}",i[0],i[1],i[2],i[3]));
                    }
                }


            }


            Console.ReadKey();


        }