我在窗体的InitializeComponent();下面将listbox1与数据绑定!
string source = "pcdb.mdb";
string conn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + source;
string sql = "SELECT [money],[price]FROM [sqxm] where type='sq'"; OleDbConnection olecon = new OleDbConnection(conn);
olecon.Open();
OleDbDataAdapter sda = new OleDbDataAdapter(sql, olecon); DataSet ds = new DataSet();
sda.Fill(ds, "sqxm");
listBox1.DataSource = ds.Tables["sqxm"];
listBox1.DisplayMember = "money";
listBox1.ValueMember = "price";
textBox1.Text = "";
textBox2.Text = "";
olecon.Close();
此时绑定成功!然后我再绑定的时候就提示失败了!具体代码如下
string sql1 = "SELECT [money],[price]FROM [shxm] ";
OleDbConnection olecon1 = new OleDbConnection(conn);
olecon1.Open();
OleDbDataAdapter sda1 = new OleDbDataAdapter(sql1, olecon1);
DataSet ds1 = new DataSet();
sda.Fill(ds1, "shxm");
listBox2.DataSource = ds1.Tables["shxm"];
listBox2.DisplayMember = "money";
listBox2.ValueMember = "price";
textBox3.Text = "";
textBox4.Text = "";
olecon1.Close();请问各位是什么原因呢
string source = "pcdb.mdb";
string conn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + source;
string sql = "SELECT [money],[price]FROM [sqxm] where type='sq'"; OleDbConnection olecon = new OleDbConnection(conn);
olecon.Open();
OleDbDataAdapter sda = new OleDbDataAdapter(sql, olecon); DataSet ds = new DataSet();
sda.Fill(ds, "sqxm");
listBox1.DataSource = ds.Tables["sqxm"];
listBox1.DisplayMember = "money";
listBox1.ValueMember = "price";
textBox1.Text = "";
textBox2.Text = "";
olecon.Close();
此时绑定成功!然后我再绑定的时候就提示失败了!具体代码如下
string sql1 = "SELECT [money],[price]FROM [shxm] ";
OleDbConnection olecon1 = new OleDbConnection(conn);
olecon1.Open();
OleDbDataAdapter sda1 = new OleDbDataAdapter(sql1, olecon1);
DataSet ds1 = new DataSet();
sda.Fill(ds1, "shxm");
listBox2.DataSource = ds1.Tables["shxm"];
listBox2.DisplayMember = "money";
listBox2.ValueMember = "price";
textBox3.Text = "";
textBox4.Text = "";
olecon1.Close();请问各位是什么原因呢
解决方案 »
- .net 导出EXCEL表的一个问题,先谢谢啦!
- vs2005新建类时自动添加作者版权信息应该怎么弄?
- 请教下网站文件file与图片pic分离的方法..
- 如何通过一个两个字符串创建实例?急
- 终于突破1000分了,升了个裤衩.散分
- MSXML2.XMLHTTPClass为何在windows service 编程里面无法用??
- 求.net socket(C#)多线程异步国内外开源框架及相关博客文章
- 关开奖一个DataSet中指定列中的数据复制到另一个 DataSet中指定列中,请指教。。。
- 如何在编译的时候自动对代码混淆????????
- 请高手指教!C#连接数据库都有哪些方式?
- datagrid 创建动态编辑列,并且能够实现修改和,删除等功能,这样的例子谁有,我没有搜到?
- hashtable
还有"SELECT [money],[price]FROM [shxm] "; from前面的空格
string conn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + source;
string sql = "SELECT [money],[price]FROM [sqxm] where type='sq'"; OleDbConnection olecon = new OleDbConnection(conn);
olecon.Open();
OleDbDataAdapter sda = new OleDbDataAdapter(sql, olecon); DataSet ds = new DataSet();
sda.Fill(ds, "sqxm");
listBox1.DataSource = ds.Tables["sqxm"];
listBox1.DisplayMember = "money";
listBox1.ValueMember = "price";
textBox1.Text = "";
textBox2.Text = "";
olecon.Close(); 放在
Form_main_Load函数中
sda.Fill(ds1, "shxm");
改成
sda1 .Fill(ds1, "shxm");
string conn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + source;
string sql = "SELECT [money],[price]FROM [sqxm] where type='sq'"; OleDbConnection olecon = new OleDbConnection(conn);
olecon.Open();
OleDbDataAdapter sda = new OleDbDataAdapter(sql, olecon); DataSet ds = new DataSet();
sda.Fill(ds, "sqxm");
listBox1.DataSource = ds.Tables["sqxm"];
listBox1.DisplayMember = "money";
listBox1.ValueMember = "price";
textBox1.Text = "";
textBox2.Text = "";
olecon.Close();
此时绑定成功!然后我再绑定的时候就提示失败了!具体代码如下
string sql1 = "SELECT [money],[price]FROM [shxm] ";
OleDbConnection olecon1 = new OleDbConnection(conn);
olecon1.Open();
OleDbDataAdapter sda1 = new OleDbDataAdapter(sql1, olecon1);
DataSet ds1 = new DataSet();
sda1.Fill(ds1, "shxm"); listBox2.DataSource = ds1.Tables["shxm"];
listBox2.DisplayMember = "money";
listBox2.ValueMember = "price";
textBox3.Text = "";
textBox4.Text = "";
olecon1.Close();