Óйظü¸ÄACCESSÊý¾Ý¿âÎÊÌâ
ÎÒÔÚVS2005ÀïÃæÓÃC#±à¼ÁËÐÞ¸ÄÓû§Ãû¶ÔÓ¦µÄÃÜÂëµÄ³ÌÐò£¬±àÒëÍêºó£¨¶à´Î²âÊÔÎÞÎ󣩰´F5Ö´Ðк󣬵ã»÷´°ÌåÉÏÃæÐÞ¸ÄÃÜÂëµÄBUTTON£¬ACCESSÊý¾Ý¿âÄÚÓû§¶ÔÓ¦µÄÃØÃÜûÓиijÉÎÒÏëÒªµÄ¡£ µ«ÊÇÎÒÉú³ÉÒ»¸öÖ´ÐÐÎļþºó£¬µã»÷ÐÞ¸ÄÃÜÂëµÄBUTTON£¬ACCESSÊý¾Ý¿âÄÚ¶ÔÓ¦Óû§µÄÃÜÂë¾ÍÐÞ¸ÄÁË£¡ÇëÎÊÓа취ÔÚ£Ö£Ó£²£°£°£µÖеã»÷£Æ£µÒ²¿ÉÒÔÕý³£Ö´Ðиü¸ÄACCESSÊý¾Ý¿âÂð£¿
clear
ÖØÐ±àÒë
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
ÕâÁ½Ììѧϰ¡¶Delphi¼¼Êõ·½°¸±¦µä¡·Ò»ÊéÖеÚÈýÕ¹ØÓÚÓû§µÇ¼·½°¸µÄÀý×Ó£¬ÀûÓõÄÊÇSQl ServerÊý¾Ý¿âʵÏÖÓû§µÇ¼£¬±àÒëÔËÐж¼Ã»ÎÊÌ⣬¸ÃʵÏֵŦÄÜÒ²¶¼ÊµÏֵĺܺ㬵«ÊÇÆæ¹ÖµÄÊÇ£¬·´¸´ÔËÐÐÒ»¶Îʱ¼äºó£¬ÓÐʱÔڹرÕÕû¸ö ......
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
Âé·³¸÷λ°ïæ¿´¿´°¡
´úÂëÈçÏ£º
CoInitialize(NULL);
_ConnectionPtr pConn(__uuidof(Connection));
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->ConnectionString="Provider ......