C#中对数据库查询

来源：百度知道 编辑：UC知道 时间：2024/06/20 00:40:27
string dbsea = string.Format("SELECT b FROM a WHERE a.b Like '*123*';");
OleDbConnection thisConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\x.mdb");
OleDbDataAdapter thisAdapter = new OleDbDataAdapter(dbsea, thisConnection);
DataSet thisDataSet = new DataSet();
thisAdapter.Fill(thisDataSet,"b");
foreach (DataRow theRow in thisDataSet.Tables["b"].Rows)
{
this.listBox2.Items.Add(theRow);
}
我想从表a中的b列里搜索带123的行,然后输出到listBox2中,求助如何修改...

this.listBox2.Items.Add(theRow);
这句应该是
this.listBox2.Items.Add(theRow["b"].Tostring());

string dbsea = string.Format("SELECT b FROM a WHERE a.b Like '*123*';");
OleDbConnection thisConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\x.mdb");
OleDbDataAdapter thisAdapter = new OleDbDataAdapter(dbsea, thisConnection);
DataSet thisDataSet = new DataSet();
thisAdapter.Fill(thisDataSet,"b");
this.listBox2.DataSource = thisDataSet.Tables[0];
this.listBox2.DisplayMember = "##"; //显示，需要修改
this.listBox2.ValueMember = "@@@"; //值，需要修改
this.listBox2.DataBind();

把你的修改如下：
string dbsea = "select * from a where b like '%123%'" ;
OleDbConnection thisConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\x.mdb");
t