Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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;";


Ïà¹ØÎÊ´ð£º

Access²éÕÒÖØ¸´ÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......

¹ØÓÚaccessÊý¾Ý¿âÁ¬½Ó¾ø¶Ô·¾¶µÄÎÊÌâÇó½â

Êý¾Ý¿âÁ¬½ÓÌáʾÈçϱ¨´í£¬¿´µÄ³öÀ´ÊÇÒ³ÃæÓëÊý¾Ý¿âÁ¬½ÓµÄÎÊÌ⣬ÏÖÔÚÎÒµÄÊÇÏà¶ÔÁ¬½Ó¡£
ÒªÔõô½«Æä¸Ã³É¾ø¶ÔÁ¬½ÓÄØ£¿ÎÒµÄÊý¾Ý¿âÎļþ·¾¶ÔÚ£º
D:\web\db
»¹ÊÇÒªÏÈлл´óÈËÃǰïÖúС°×²ËÎÒ


Microsoft O ......

ÎÒÕâACCESS±íµÄÏÔʾÈçºÎÇл»³ÉÏÂÃæÕâÕÅͼÀ´

ÎÒĿǰ±íµÄÅÅÁÐÊÇÉÏÃæÕâÕÅͼÕâÇé¿ö£º

ÎÒÏ£Íûµ÷Õû³É£º

ÈçºÎ×öÄØ£¿
¸Õ²ÅÊÔÁËÏ£¬µã¡°¿ªÊ¼¡±--¡°ÊÓͼ¡±--¡°Éè¼ÆÊÓͼ¡±²»ÐÐ

PS£ºÎÒÓõÄÊÇaccess 2007£¬ÉÏÃæÕâ¸ö±íÊÇmdb¸ñʽµÄ

Ö÷²Ëµ¥£¬ ÊÓͼ ......

¼±ÇóASP¡£NETC#¹ºÎï³µ´úÂë

×î½üÔÚ×ö¸öÍøÉÏÉ̳ǣ¬¹ºÎﳵģ¿é£¬Ã»ÓÐ×ö¹ý£¬Âé·³¸÷λ°ïæ˵Ï´óÖÂ˵ÏÂ˼·£¬ÄÜ·¢Ò»·ÝÔ´Âë¸üºÃ¡£Ð¡µÜÏÈл¹ý¸÷λÁË£»
QQ£º413763818£»
eamil:swebook@126.com
ÍøÉÏÒ»´ó¶Ñ£¡

www.51aspx.com

ȥϠ......

MFCÁ¬½ÓACCESS ³ö´í

Âé·³¸÷λ°ïæ¿´¿´°¡
´úÂëÈçÏ£º
CoInitialize(NULL);
  _ConnectionPtr pConn(__uuidof(Connection)); 
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->ConnectionString="Provider ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ