我用下面的语法想得到数据库中id值为index的记录,为什么编译时老显示数据库出错。
OleDbConnection oledb = new OleDbConnection(BallPath);
OleDbCommand oleCom = new OleDbCommand("select * From " +tabName+ " where ID ="+index.ToString(), oledb);
oledb.Open();
OleDbDataReader aReader = oleCom.ExecuteReader();
str=aReader.GetString(aReader.GetOrdinal("中奖号码"));
aReader.Close();
oledb.Close();
OleDbConnection oledb = new OleDbConnection(BallPath);
OleDbCommand oleCom = new OleDbCommand("select * From " +tabName+ " where ID ="+index.ToString(), oledb);
oledb.Open();
OleDbDataReader aReader = oleCom.ExecuteReader();
str=aReader.GetString(aReader.GetOrdinal("中奖号码"));
aReader.Close();
oledb.Close();
"select * From " +tabName+ " where ID ="+"'"+index.ToString()+"'"这样试试吧
OleDbCommand oleCom = new OleDbCommand("select * From " +tabName+ " where ID ="+index.ToString(), oledb);
这样试一下..
另外你的数据库连接是否正确呀?能正常连上数据库吗?
2.建议对id上面加中括号写成[id]进行查询