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

Êý¾Ý¿âÊÇAccessµÄ£¬¿ÉÒÔÓô洢¹ý³ÌÂð

Êý¾Ý¿âÊÇAccessµÄ£¬¿ÉÒÔÓô洢¹ý³ÌÂð ?

ÔõôÓÃà¸?

ACCESSûÓд洢¹ý³ÌµÄ.Ö»ÓÐQUERY

»òÕßдºê»òÕßVBAÄ£¿é°É

תµ½SQLÖÐÈ¥ÓÃ

ûÓÐ

ÒýÓÃ
ACCESSûÓд洢¹ý³ÌµÄ.Ö»ÓÐQUERY



QUERY¿ÉÒÔ´úÌæ´æ´¢¹ý³ÌÂð

ÒýÓÃ
ÒýÓà 1 Â¥ icelovey µÄ»Ø¸´:
ACCESSûÓд洢¹ý³ÌµÄ.Ö»ÓÐQUERY


QUERY¿ÉÒÔ´úÌæ´æ´¢¹ý³ÌÂð

µ±È»Ã»Óд洢¹ý³ÌÇ¿´ó, Ò»¸öQUERYÖ»ÊÇÖ´ÐÐÒ»²½¸üлòÕßɾ³ý²åÈëµÄ¶¯×÷¶øÒÑ
¶ø´æ´¢¹ý³ÌÀïÃæ¿ÉÒÔдºÜ¶àµÄ¶¯×÷..
ͨË×µã¾ÍÊÇÒ»¸ö´æ´¢¹ý³ÌµÈÓںܶà¸öQUERYµÄ¼¯ºÏ

ÒýÓÃ
ÒýÓà 5 Â¥ jiejie526 µÄ»Ø¸´:
ÒýÓà 1 Â¥ icelovey µÄ»Ø¸´:
ACCESSûÓд洢¹ý³ÌµÄ.Ö»ÓÐQUERY


QUERY¿ÉÒÔ´úÌæ´æ´¢¹ý³ÌÂð

µ±È»Ã»Óд洢¹ý³ÌÇ¿´ó, Ò»¸öQUERYÖ»ÊÇÖ´ÐÐÒ»²½¸üлòÕßɾ³ý²åÈëµÄ¶¯×÷¶øÒÑ
¶ø´æ´¢¹ý³ÌÀïÃæ¿ÉÒÔдºÜ¶àµÄ¶¯×÷..
ͨË×µã¾ÍÊÇÒ»¸ö´æ´¢¹ý³ÌµÈÓںܶà¸öQUERYµÄ¼¯ºÏ


ÕâЩÄÜÓÃÔÚQueryÀïÂ𣿣¿

C# code:

--參¿¼ 轉
declare @str varchar(100)
set @str='SA' --ÒªËÑË÷µÄ×Ö·û´®

declare @s varchar(8000)
declare tb cursor local for
select s='if exists(select 1 from ['+b.name+'] where ['+a.name+'] like ''%'+@str+'%'')
print ''ËùÔÚµÄ±í¼°×Ö¶Î: ['+b.nam


Ïà¹ØÎÊ´ð£º

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

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

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

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

ʹÓÃRepeater¶ÁÈ¡access±í£¬Ò³Ãæ´ò¿ª·Ç³£Âý

accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×Ö¶Î from ±í  ¶ÁÈ¡Êý¾Ý
È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ
ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý
Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËÙ¶È£¡
Ò»´ÎÈ«²¿¶ÁÍê ......

ÈçºÎ½«XMLÊý¾Ý´æÈëACCESSÊý¾Ý¿â

ÇëÎʸ÷λ´óʦ£¬ÎÒÏÖÔÚÐèÒª½«XMLµÄÊý¾ÝʵʱµÄ´æÈëµ½Êý¾Ý¿âÖУ¬ÎÒÊÇÓÃasp±àµÄ³ÌÐò£¬´óÁ¿Ãǰïæ·ÖÎö һϣ¡£¡£¡
ÏÂÃæÊÇÎÒµÄXMLÎļþ´úÂë
XML code:

<?xml version="1.0" encoding="utf-8"? ......

MFCÁ¬½ÓACCESS ³ö´í

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