Êý¾Ý¿âÊÇ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Êý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏ ±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡± ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×Ö¶Î from ±í ¶ÁÈ¡Êý¾Ý È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËÙ¶È£¡ Ò»´ÎÈ«²¿¶ÁÍê ......
ÇëÎʸ÷λ´óʦ£¬ÎÒÏÖÔÚÐèÒª½«XMLµÄÊý¾ÝʵʱµÄ´æÈëµ½Êý¾Ý¿âÖУ¬ÎÒÊÇÓÃasp±àµÄ³ÌÐò£¬´óÁ¿Ãǰïæ·ÖÎö һϣ¡£¡£¡ ÏÂÃæÊÇÎÒµÄXMLÎļþ´úÂë XML code: <?xml version="1.0" encoding="utf-8"? ......
Âé·³¸÷λ°ïæ¿´¿´°¡ ´úÂëÈçÏ£º CoInitialize(NULL); _ConnectionPtr pConn(__uuidof(Connection)); _RecordsetPtr pRst(__uuidof(Recordset)); pConn->ConnectionString="Provider ......