一个简单连接数据库问题

[gaopeng95809]

怎么样连接数据库，然后从数据库里取出数据放在DataTable里，请给详细点的代码，谢谢

[wzuomin]

http://blog.csdn.net/whfill/archive/2007/06/20/1659376.aspx

[Zhanlixin]

string strConn = @"server=ZHAN\SQLEXPRESS;database=Fjmsq;trusted_connection=true";
SqlConnection conn = new SqlConnection(strConn);
conn.Open();
SqlDataAdapter sda = new SqlDataAdapter("select * from allcode", conn);
DataSet ds = new DataSet();
sda.Fill(ds, "newcenter");
DataTable dt=ds.Tables[0];

[yuanhuiqiao]

楼上正确

[lchh0917]

好像有点问题呢，"newcenter"是哪来的？应该换成conn吧
string strConn = @"server=ZHAN\SQLEXPRESS;database=Fjmsq;trusted_connection=true";
SqlConnection conn = new SqlConnection(strConn);
conn.Open();
SqlDataAdapter sda = new SqlDataAdapter("select * from allcode", conn);
DataSet ds = new DataSet();
sda.Fill(ds, conn);
DataTable dt=ds.Tables[0];

====================================================================================
也可以这样
SqlDataAdapter sqlad;
DataTable mytable=new DataTable();
SqlCommandBuilder myBuilder;

string ConnectionString = "server=localhost;database=MYdb;User=sa;Pwd=sa";
SqlConnection myconn = new SqlConnection(ConnectionString);
string mycmdtext = "SELECT id,学号, 姓名, 课程名称, 成绩 FROM MYTable2";
myconn.Open();
sqlad = new SqlDataAdapter(mycmdtext, myconn);
myBuilder = new SqlCommandBuilder(sqlad);
sqlad.Fill(mytable);
myconn.Close();
//this.ShowCurrentRecord();

[wangchao813]

回帖是一种美德！传说每天回帖即可获得 10 分可用分！

[扬帆一号]

"newcenter"这个给dataset中的表起的表名

[别样苍茫]

[Quote=引用 2 楼 Zhanlixin 的回复:]
string strConn = @"server=ZHAN\SQLEXPRESS;database=Fjmsq;trusted_connection=true";
SqlConnection conn = new SqlConnection(strConn);
conn.Open();
SqlDataAdapter sda = new SqlDataAdapter("select * from allcode", conn);
DataSet ds = new DataSet();
sda.Fill(ds, "newcenter");
DataTable dt=ds.Tables[0];
[/Quote]
Connection 这里不需要Open()；