´úÂëÈçÏ£º
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
Ôõô»¹Ô£¿
Õâ¸öµØ·½»¹Ã»ÓÐÓõ½Õâ¸ö²éѯÓï¾äÄØ£¬¿Ï¶¨ºÍÕâÀïûÓйØÏµ¡£
´íÎóÌáʾÊÇ:±ê×¼µÄÊý¾ÝÀàÐͲ»Æ¥ÅäµÄ±í´ï
¿ÉÄÜÊDZíÃû°É select * from [grade] ÊÔÏÂ
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
Êý¾Ý¿âÁ¬½ÓÌáʾÈçϱ¨´í£¬¿´µÄ³öÀ´ÊÇÒ³ÃæÓëÊý¾Ý¿âÁ¬½ÓµÄÎÊÌ⣬ÏÖÔÚÎÒµÄÊÇÏà¶ÔÁ¬½Ó¡£
ÒªÔõô½«Æä¸Ã³É¾ø¶ÔÁ¬½ÓÄØ£¿ÎÒµÄÊý¾Ý¿âÎļþ·¾¶ÔÚ£º
D:\web\db
»¹ÊÇÒªÏÈлл´óÈËÃǰïÖúС°×²ËÎÒ
Microsoft O ......
×î½üÔÚ×ö¸öÍøÉÏÉ̳ǣ¬¹ºÎﳵģ¿é£¬Ã»ÓÐ×ö¹ý£¬Âé·³¸÷λ°ïæ˵Ï´óÖÂ˵ÏÂ˼·£¬ÄÜ·¢Ò»·ÝÔ´Âë¸üºÃ¡£Ð¡µÜÏÈл¹ý¸÷λÁË£»
QQ£º413763818£»
eamil:swebook@126.com
ÍøÉÏÒ»´ó¶Ñ£¡
www.51aspx.com
ȥϠ......