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

access Êý¾Ý¿â±ØÐëÌî¾ø¶Ô·¾¶Âð

Óà ADOConnection Á¬½ÓÒ»¸ö Access .mdb Êý¾Ý¿âʱ

ÔÚÊäÈëÊý¾Ý¿âÃû³ÆÊ±±ØÐëÊǾø¶Ô·¾¶Âð£¿

ÔÚBCB 6 ʱ£¬ ÎÒÖ»ÊäÈëÎļþÃû¾Í¿ÉÒÔÁË¡£ ÒòΪÎÒµÄ Êý¾Ý¿âÓëÓ¦ÓÃÔÚͬһ¸öĿ¼¡£

ÔÚ 2010 Èç¹ûÖ»ÌîÎļþÃû³Æ£¬ ÔÚÏ´ÎÖØÆôRS2010´ò¿ªÏîĿʱ£¬ÌáʾÕÒ²»µ½Îļþ ÈçÏÂ

ÕÒ²»µ½Îļþ ¡®C:\Documents and Settings\neeme\×ÀÃæ\clearsky.mdb.

ÎÒµÄÎļþ²»ÔÚÕâ¸öĿ¼£¬µ«ÎªÊ²Ã´»á¼ÓÉÏÕâ¸öÄ¿Â¼ÄØ£¿
µ÷ÊÔʱÄ㽫Êý¾Ý¿â·ÅÔÚDebug»òReleaseÎļþ¼ÐÀï

ÓëÄãÉú³ÉµÄexeÎļþÔÚÒ»¸öĿ¼.´Ó2006¿ªÊ±,Éú³ÉµÄÎļþ»á·ÅÔÚµ¥¶ÀµÄÒ»¸öÎļþ¼ÐÀï

ÔËÐÐʱûÓÐÎÊÌâµÄ¡£ ÎÒÒ²°ÑÊý¾Ý¿âÎļþÔÚµ½¶ÔӦĿ¼Àï

Ö»ÊÇÔÚÐÞ¸ÄÏîĿʱ£¬ RS2010 ³öÏÖÕâ¸öÌáʾ£¡

ÎÒ·¢¾õ ÔÚ welcom page ´ò¿ªÏîĿ¼ »áÓÐÕâ¸öÎÊÌâ

ÔÚ File -> open project ´ò¿ªÏîĿ¼£¬ ûÓÐÕâ¸öÎÊÌâ

Èç¹û²»ÐÐÄã¿ÉÒÔÔÚÉè¼ÆÊ±Ê¹ÓÃÕâЩ
String DBFile = ExtractFilePath(Application->ExeName)+"\\clearsky.mdb";
String Provider1="Provider=Microsoft.Jet.OLEDB.4.0;   Data Source="+DBFile+";Jet OLEDB";
  ADOConnection->ConnectionString = Provider1;
  ADOConnection->Open()  ;

String Provider1="Provider=Microsoft.Jet.OLEDB.4.0;  Data Source="+DBFile;

×î½üÀÏÊdzö´í

ÎÒ²ÂÊÇ£¬Óà welcome page ÕÒ¿ªÏîÄ¿£¬ ¹¤³ÌµÄĬÈÏĿ¼Ϊ

C:\Documents and Settings\neeme\×ÀÃæ\

Óà File->Open Project ÕÒ¿ªÏîÄ¿£¬ ¹¤³ÌµÄĬÈÏĿ¼Ϊ

¹¤³ÌµÄµ±Ç°Ä¿Â¼£


Ïà¹ØÎÊ´ð£º

Access²éÕÒÖØ¸´ÎÊÌâ

ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏ 
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡± 
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......

½â¾öaccess¼¶Áª¸üÐÂÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

CREATE TABLE Product(model integer, 
maker varchar(20), 
CONSTRAINT SAND PRIMARY KEY (model), 
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model) 
ON DELETE CASCADE ......

²éѯACCESSÖзûºÏÌõ¼þ¼Ç¼µÄÓï·¨¸ñʽ

ÎÒ×öÁËÒ»¸öС³ÌÐò£¬ÏëʵÏֵŦÄܾÍÊÇÔÚÎı¾¿òÖÐÊäÈëÐÕÃû£¬µã»÷²éѯ°´Å¥£¬¾ÍÄܲ鵽ACCESSÊý¾Ý¿âÖдËѧÉúµÄÐÅÏ¢£¨±àºÅ£¬ÐÕÃû£¬ÐÔ±ð£¬ÄêÁ䣩¿ÉÎÒ²»ÖªµÀÓï·¨¸ñʽ£¬ÎÒ×Ô¼ºÐ´µÄÓï¾äµ÷ÊÔÄÜͨ¹ý£¬¿ÉÊÇÔËÐÐʱ³ö´í£¨µã»÷²éѯ°´ ......

dOOdads Á¬½Ó ACCESS µÄÊý¾Ý·ÖÒ³ÎÊÌâ

ÈçÌâ dOOdads Á¬½Ó ACCESS µÄÊý¾Ý·ÖÒ³ÎÊÌ⣡
ʹÓà dOOdads Á¬½Ó ACCESSÊý¾ÝµÄʱºò Êý¾Ý·ÖÒ³µÄÎÊÌ⣡
¸ù¾ÝÕâ¸ö¸Ä°É
C# code:

public static Product[] SearchProducts(string keyword, int categoryID, int pa ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ