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");