Question

c#从ACCESS数据库中查询错误

string strSqlsel = string.Format("select * from SHI where ITEM ='" + sitem + "'and Qty ='" + sqty + "'");
OleDbConnection dbconn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;" + "Data
Source=e:\\pf.mdb;");
dbconn.Open();
OleDbDataAdapter da = new OleDbDataAdapter(strSqlsel, dbconn);
DataSet ds = new DataSet();
DataTable dt = new DataTable();
ds.Tables.Add(dt);
da.Fill(ds);
foreach (DataRow dr in dt.Rows)
{
Console.WriteLine(dr[0]);
}
执行到foreach时就直接跳过了，没有执行Console.WriteLine，请问这个是哪里的问题

Answer 1

用datatable保存你取得的记录，comboBox1datatable dt = Query();for(int i=0;i<dt.rows.count;i++){ comboB1.items.add(dt.rows[i]["col"]);}查询语句参照代码：public DataTable Query(){ string param1 =combox1.selected.value.tostring(); string param2 =combox2.selected.value.tostring() strCommand = "SELECT" + param2 +" FROM "+@TABLENAME+" WHERE 1=1"; cmd.CommandText = strCommand; // cmd是sqlCommand对象 SqlDataAdapter da = new SqlDataAdapter(strCommand, conn); da.SelectCommand = cmd; DataSet ds = new DataSet(); da.Fill(ds); dt = ds.Tables[0]; return dt;}有问题再追问吧，望采纳。