C#连接SQLServer数据库关键代码:
使用命名空间:
using System.Data.SqlClient
//连接数据库
string conn, sql;
conn = "Server=.;Database=rj2013;Trusted_Connection=SSPI";//windows验证
//conn = "Server=(local);Database=13rj;uid=sa;pwd=sa";//SQLServer验证
sql = "select * from rj13_basic";
SqlConnection myconn = new SqlConnection(conn);
myconn.Open();
SqlDataAdapter myda = new SqlDataAdapter(sql, conn);
DataSet myds = new DataSet();
myda.Fill(myds, "rj13_basic");
dataGridView1.DataSource = myds.Tables["rj13_basic"];
myconn.Close();