string source = "pcdb.mdb";
string conn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + source;
string sql = "SELECT [money] [price] FROM [sqxm] "; OleDbConnection olecon = new OleDbConnection(conn);
olecon.Open();
OleDbDataAdapter sda = new OleDbDataAdapter(sql, olecon); DataSet ds = new DataSet();
sda.Fill(ds, "sqxm");
最后一行显示操作符丢失,请问一般是什么错误?
string conn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + source;
string sql = "SELECT [money] [price] FROM [sqxm] "; OleDbConnection olecon = new OleDbConnection(conn);
olecon.Open();
OleDbDataAdapter sda = new OleDbDataAdapter(sql, olecon); DataSet ds = new DataSet();
sda.Fill(ds, "sqxm");
最后一行显示操作符丢失,请问一般是什么错误?
string source = "pcdb.mdb";
string conn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + source;
string sql = "SELECT [money],[price]FROM [sqxm] "; OleDbConnection olecon = new OleDbConnection(conn);
olecon.Open();
OleDbDataAdapter sda = new OleDbDataAdapter(sql, olecon); DataSet ds = new DataSet();
sda.Fill(ds, "sqxm");
listBox1.DataSource = ds;
listBox1.DisplayMember = "money";
listBox1.ValueMember = "price";///////这里是黄子部分,显示错误
错误提示为:
无法绑定到新的显示成员。
参数名: newDisplayMember
绑定的应该是datatable,
楼主上一帖还没结贴!
漏了逗号
SELECT [money] , [price] FROM [sqxm]