ÓÃC#¶ÔAccessÊý¾Ý¿â²éѯÎÊÌâ
ÎÒÏëÎÊÎÊ£¬ÔÚc#±àдµÄ¶ÔAccessÊý¾Ý¿â²Ù×÷µÄ³ÌÐòÖУ¬±àдʲô´úÂë¿ÉÒÔ¶ÔAccessÊý¾Ý¿âÖеÄÁ½¸ö±í½øÐвéѯ£¿£¿£¿
End_rbody_61188804//-->
¸Ã»Ø¸´ÓÚ2009-11-17 09:09:27±»¹ÜÀíԱɾ³ý
¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP
starj1
(ľ¹Å¿ÚÊ®)
µÈ¡¡¼¶£º
#2Â¥ µÃ·Ö£º0»Ø¸´ÓÚ£º2009-11-16 03:28:34
¶þ¸ö±íÁªºÏ²éѯµÄ×Ӿ䣺
left join/inner join/right join/join on table1.key = table2.key
Ïà¶ÔÓÚMS SQLÀ´½²£¬AccessµÄ¹¦ÄÜÉÔ΢ÈõÁËһЩ£¬²»¹ý»¹ÊÇ¿ÉÒÔÍê³É»ù±¾ÊµÏÖ¡£ÖÁÓÚ¶ÔÊý¾Ý¿âµÄ¶ÁдÓëMS SQL ²î±ð²¢²»ÊǺܴó¡£
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
¸øÐ¡µÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË
officeÍêÕ ......
ÇëÎʸ÷λ´óʦ£¬ÎÒÏÖÔÚÐèÒª½«XMLµÄÊý¾ÝʵʱµÄ´æÈëµ½Êý¾Ý¿âÖУ¬ÎÒÊÇÓÃasp±àµÄ³ÌÐò£¬´óÁ¿Ãǰïæ·ÖÎö һϣ¡£¡£¡
ÏÂÃæÊÇÎÒµÄXMLÎļþ´úÂë
XML code:
<?xml version="1.0" encoding="utf-8"? ......
×î½üÔÚ×ö¸öÍøÉÏÉ̳ǣ¬¹ºÎﳵģ¿é£¬Ã»ÓÐ×ö¹ý£¬Âé·³¸÷λ°ïæ˵Ï´óÖÂ˵ÏÂ˼·£¬ÄÜ·¢Ò»·ÝÔ´Âë¸üºÃ¡£Ð¡µÜÏÈл¹ý¸÷λÁË£»
QQ£º413763818£»
eamil:swebook@126.com
ÍøÉÏÒ»´ó¶Ñ£¡
www.51aspx.com
ȥϠ......
Âé·³¸÷λ°ïæ¿´¿´°¡
´úÂëÈçÏ£º
CoInitialize(NULL);
_ConnectionPtr pConn(__uuidof(Connection));
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->ConnectionString="Provider ......