C#连接SQL Server 数据库

引用

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

代码部分

SqlConnection conn;
try
{
conn = new SqlConnection("Server=地址;DataBase=数据库名;Uid=用户名;pwd=用户密码;");//连接配置
SqlCommand cmd = new SqlCommand("select * from users", conn);//SQL语句
SqlDataReader reader = null;//结果存储
try
{
conn.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
Console.WriteLine("username=" + reader[1].ToString() + " ,password=" + reader[2].ToString() );//结果输出
}
}
catch (Exception ex) { }
finally
{
reader.Close();
conn.Close();
}
}
catch (Exception oExcept)
{
Console.WriteLine("错误");
}