C# 连接SQL Server 数据库的 读取数据的基本原理方法

 SQL Server  C# 连接数据库的基本原理

SqlConnection conn = new SqlConnection();
            SqlCommand cmd = new SqlCommand();
           
            //数据库的连接的字符串
            //Data Source=localhost 为本地数据源
            //Initial Catelog 为本地数据的数据库
            //Integrated Security登陆用户的验证 user id  password
            string str = @"Data Source=localhost;Initial Catalog = Test;Integrated Security = true";
            conn.ConnectionString = str;

            conn.Open();
            //连接数据库
            cmd.Connection = conn;
            //判断数据库的连接状态
            if (conn.State == System.Data.ConnectionState.Open)
                Console.WriteLine("connect success");