C#²Ù×÷accessÊý¾Ý¿â³ö´í

´úÂëÈçÏ£º

private string strConnection;
private string mySelectQuery = @"select * from Grade";
private OleDbConnection objConnection;
strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source=E:\Application\DBtest.mdb";
objConnection = new OleDbConnection(strConnection);
objConnection.Open();
DataSet ds = new DataSet(); // Dataset is the collection of tables
OleDbDataAdapter da = new OleDbDataAdapter(sql, objConnection);
da.Fill(ds);


ÔÚÖ´Ðе½da.Fill(ds)µÄʱºò³ö´í£¬´íÎóÊÇ£ºData type mismatch in criteria expression.ÎÒ²»ÖªµÀΪʲô»áÕâÑù£¬»¹·³¸ßÈËÖ¸µã¡£Ð»Ð»ÏÈ£¡

---

°Ñ+=»¹Ô­³ÉÍêÕûд·¨£¡£¡

---

select * from [Grade]
¼ÓÉÏÖÐÀ¨ºÅ

---

[Quote=ÒýÓà 1 Â¥ nongmintian µÄ»Ø¸´:]
°Ñ+=»¹Ô­³ÉÍêÕûд·¨£¡£¡
[/Quote
Ôõô»¹Ô­£¿

---

ÒýÓÃ

select * from [Grade]
¼ÓÉÏÖÐÀ¨ºÅ

Õâ¸öµØ·½»¹Ã»ÓÐÓõ½Õâ¸ö²éѯÓï¾äÄØ£¬¿Ï¶¨ºÍÕâÀïûÓйØϵ¡£

---

´íÎóÌáʾÊÇ:±ê×¼µÄÊý¾ÝÀàÐͲ»Æ¥ÅäµÄ±í´ï
¿ÉÄÜÊDZíÃû°É select * from [grade] ÊÔÏÂ

---

ÒýÓÃ

´úÂëÈçÏ£º

private string strConnection;
private string mySelectQuery = @"select * from Grade";
private OleDbConnection objConnection;
strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";