C#连接数据库问题 我想从SQL数据库的一个表中 读取一列值到 listbox控件 ,应该怎么写呢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 连接sqlserverhttp://blog.sina.com.cn/s/blog_52209ba70100cnpx.html下面是绑定listbox listBox1.DataSource = ds.Tables["表名"]; listBox1.DisplayMember = "字段名"; 先读取这个表的信息存到ds里面listbox.datasource=ds;listbox.datavaluetext="字段名";listbox.datatextvalue=“字段编号”; 我改了之后 怎么说缺少USING指令和程序集引用system data System.Data.SqlClientSystem.Configuration;都有的啊 怎么回事呢 private void button1_Click_1(object sender, EventArgs e) { string strConn = ConfigurationManager.ConnectionStrings["字符串名"].ConnectionString; SqlConnection myConn = new SqlConnection(strConn); string strSQL = "select address from shuju "; SqlCommand myCommand = new SqlCommand(strSQL, myConn); DataSet ds = new DataSet("NewDataSet"); SqlDataReader reader = myCommand.ExecuteReader(); myConn.Open(); listBox1.DataSource = ds.Tables("shuju"); listBox1.DisplayMember = "address"; myConn.Close(); }大家帮我看看 该怎么改?我刚刚学啊 不会 private void button1_Click_1(object sender, EventArgs e) { string strConn = ConfigurationManager.ConnectionStrings["字符串名"].ConnectionString; SqlConnection myConn = new SqlConnection(strConn); string strSQL = "select address from shuju "; myConn.Open();//此处需要先打开数据库连接 SqlCommand myCommand = new SqlCommand(strSQL, myConn); SqlDataAdapter adapter = new SqlDataAdapter(myCommand); DataSet ds = new DataSet(); adapter.Fill(ds,"NewDataSet"); //DataSet ds = new DataSet("NewDataSet"); //SqlDataReader reader = myCommand.ExecuteReader(); //myConn.Open(); listBox1.DataSource = ds.Tables("shuju"); listBox1.DisplayMember = "address"; myConn.Close(); } 还是报错呢 Non-invocable member 'System.Data.DataSet.Tables' cannot be used like a method. listBox1.DataSource = ds.Tables("shuju");=>listBox1.DataSource = ds.Tables[0]; 额,你自己看那错了你的:listBox1.DataSource = ds.Tables("shuju"); listBox1.DataSource = ds.Tables["shuju"]; C# 拷贝文件的问题 如何是按钮保持“突出” 一个编程题 用C#递归求第19位数 谁可以给出一些C Sharp读XML数据的方法... 菜鸟请教:如何取得2006-01-01 13:10:10时间格式??? 各种时间格式,怎么解析成DateTime结构? 请教:水晶报表中如何判断某条记录是否是当前页码的最后一条记录 C#中应用哪些控件实现这样的列表显示?? C#开发过程中如何设置程序的启动位置? 连接2个数据库 动态生成dll文件版本号
下面是绑定listbox listBox1.DataSource = ds.Tables["表名"];
listBox1.DisplayMember = "字段名";
listbox.datasource=ds;listbox.datavaluetext="字段名";
listbox.datatextvalue=“字段编号”;
system data
System.Data.SqlClient
System.Configuration;
都有的啊 怎么回事呢
{
string strConn = ConfigurationManager.ConnectionStrings["字符串名"].ConnectionString;
SqlConnection myConn = new SqlConnection(strConn);
string strSQL = "select address from shuju ";
SqlCommand myCommand = new SqlCommand(strSQL, myConn);
DataSet ds = new DataSet("NewDataSet");
SqlDataReader reader = myCommand.ExecuteReader();
myConn.Open();
listBox1.DataSource = ds.Tables("shuju");
listBox1.DisplayMember = "address";
myConn.Close();
}
大家帮我看看 该怎么改?我刚刚学啊 不会
{
string strConn = ConfigurationManager.ConnectionStrings["字符串名"].ConnectionString;
SqlConnection myConn = new SqlConnection(strConn);
string strSQL = "select address from shuju ";
myConn.Open();//此处需要先打开数据库连接
SqlCommand myCommand = new SqlCommand(strSQL, myConn);
SqlDataAdapter adapter = new SqlDataAdapter(myCommand);
DataSet ds = new DataSet();
adapter.Fill(ds,"NewDataSet");
//DataSet ds = new DataSet("NewDataSet");
//SqlDataReader reader = myCommand.ExecuteReader();
//myConn.Open();
listBox1.DataSource = ds.Tables("shuju");
listBox1.DisplayMember = "address";
myConn.Close();
}
Non-invocable member 'System.Data.DataSet.Tables' cannot be used like a method.
=>listBox1.DataSource = ds.Tables[0];