C# .NET 连接 SQL Server 2005, 2008 数据库

C# .NET 连接 SQL Server 2005, 2008 数据库
 
// using System.Data.SqlClient
string connStr = "server=localhost; uid=sa; pwd=123456; database=dbname";
using (SqlConnection conn = new SqlConnection(connStr))
{
 conn.Open();
 DataTable dt = new DataTable();
 SqlDataAdapter da = new SqlDataAdapter("select * from tbname", conn);
 da.Fill(dt);
 dataGridView.DataSource = dt;
}