eric_wjh 发布留言 2008-7-29 17:09
如何读取Access中的数据啊
各位大侠
帮我看下有什么错啊
string connectionString =
"provider=Microsoft.Jet.OLEDB.4.0;" +
"data source=C:\\Documents and Settings\\Administrator.310C7DBA925B462\\桌面\\db2.mdb";
OleDbConnection myOleDbConection = new OleDbConnection(connectionString);
OleDbCommand myOleDbCommand = new OleDbCommand("select * from emp_test", myOleDbConection);
myOleDbCommand.CommandText =
"SELECT customerID,CompanyName,contactName,Address " +
"FROM db2 " +
"WHERE cunstomerID ='ALFKI'";
myOleDbConection.Open();
OleDbDataReader myOleDbDataReader = myOleDbCommand.ExecuteReader();//(**)
myOleDbDataReader.Read();
Console.WriteLine(myOleDbDataReader["customerID"]);
Console.WriteLine(myOleDbDataReader["CompanyName"]);
Console.WriteLine(myOleDbDataReader["contactName"]);
Console.WriteLine(myOleDbDataReader["Address"]);
myOleDbDataReader.Close();
myOleDbConection.Close();
我一运行 就把(**)那句标黄了，由于本人太菜不知道是什么原因导致的，还请各位大侠帮忙
师妃暄 发布留言 2008-7-29 17:22
OleDbCommand myOleDbCommand = new OleDbCommand("select * from emp_test", myOleDbConection);
myOleDbCommand.CommandText =
"SELECT customerID,CompanyName,contactName,Address " +
"FROM db2 " +
"WHERE cunstomerID ='ALFKI'";
你给myOleDbCommand 赋了两个不同的SQL命令，这样可不行哦
eric_wjh 发布留言 2008-7-29 17:35
我把OleDbCommand myOleDbCommand = new OleDbCommand("select * from emp_test", myOleDbConection);
改成了OleDbCommand myOleDbCommand =myOleDbConection.createcommand();
但是程序还是错啊
师妃暄 发布留言 2008-7-29 17:41
string connectionString =
"provider=Microsoft.Jet.OLEDB.4.0;" +
"data source=C:\\Documents and Settings\\Administrator.310C7DBA925B462\\桌面\\db2.mdb";
OleDbConnection myOleDbConection = new OleDbConnection(connectionString);
OleDbCommand myOleDbCommand = new OleDbCommand("SELECT customerID,CompanyName,contactName,Address FROM db2 WHERE cunstomerID ='ALFKI'", myOleDbConection);
myOleDbConection.Open();
OleDbDataReader myOleDbDataReader = myOleDbCommand.ExecuteReader();//(**)
eric_wjh 发布留言 2008-7-29 17:49
版主 还是出错啊[tk09]
师妃暄 发布留言 2008-7-29 17:55
你把错误的说明都帖上来，我好看啊
页: [1]
