各位大侠
帮我看下有什么错啊
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);
             =
                "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();


我一运行 就把(**)那句标黄了，由于本人太菜不知道是什么原因导致的，还请各位大侠帮忙

OleDbCommand myOleDbCommand = new OleDbCommand("select * from emp_test", myOleDbConection);
             =
                "SELECT customerID,CompanyName,contactName,Address " +
                "FROM db2 " +
                "WHERE cunstomerID ='ALFKI'";

你给myOleDbCommand 赋了两个不同的SQL命令，这样可不行哦

我把OleDbCommand myOleDbCommand = new OleDbCommand("select * from emp_test", myOleDbConection);
改成了OleDbCommand myOleDbCommand =myOleDbConection.createcommand();
但是程序还是错啊

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();//(**)

版主 还是出错啊

你把错误的说明都帖上来，我好看啊

他说未处理OleDbException。至少一个参数没有被指定值。
不知道是什么意思啊

检查一下你的select语句 字段和数据库字段是否相符！

嗯 谢谢大侠们 呵呵 我改正了下 是我的出错了 我改成
OleDbCommand myOleDbCommand = new OleDbCommand("SELECT db2.customerID, , db2.contactName, db2.Address "+
"FROM db2 "+
"WHERE (((db2.customerID)='ALFKI'));", myOleDbConection);
程序就可以了啊
谢谢啊
但是为什么他显示下就跳走了

什么显示下就跳走了？