一个简单连接数据库问题 怎么样连接数据库,然后从数据库里取出数据放在DataTable里,请给详细点的代码,谢谢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 http://blog.csdn.net/whfill/archive/2007/06/20/1659376.aspx 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]; 好像有点问题呢,"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(); "newcenter"这个给dataset中的表起的表名 Connection 这里不需要Open(); 关于将c编写的exe文件放入资源文件中动态调用 截取字符串 socket 传文件夹的问题网络延迟的问题 winform datagridview 如何实现多层表头 为什么我打印出来的的条码不能扫 Csharp中 CreateCursor()怎么用 文件使用 通过菜单引用了system.windows.forms.dll后,具体体现在源代码的哪个地方呢? C#中是否有C++中的映射? C#中picturebox问题 C# 捕获磁盘空间不足异常 【求助】~~~消息队列接收不到消息~
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];
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();