¼±~~~~!!VC 8.0,ADO ACCESS,¶ÁÈ¡,¸ß·Ö~~!!!!!!
¸÷λ´óÏÀ,ÎÒÓõÄÊÇVC8.0ºÍADOÀ´²Ù×÷access,ÔÚûÓдòVS 2005 SP1µÄʱºò,·¢²¼ÁË,³ÌÐòÔËÐÐÕý³£.
ºóÀ´ÎÒ´òÁËSP1Ö®ºó,ÔÙ·¢²¼,³ÌÐòÿ´ÎÔÚÈ¡³öÊý¾Ý¼¯Ö®ºó,×ÜÊdzö´í(´úÂëûÓи͝).³ö´íÀàËÆÓÚ:
ÎÒselect *,°ÑËùÓÐ×ֶεÄÖµ¶¼È¡³öÀ´,±ÈÈçÓÐ6¸ö×Ö¶Î,Ç°Ãæ4¸ö×ֶζ¼ºÜÕý³£,µÈµ½µÚ5¸ö,µÚÁù¸öʱºò³ö´í,»¹²¢²»ÊÇÔÚGetCollectʱºò,¶øÊǽ«Öµ×ª»»³É×Ö·û´®µÄʱºò,ÎÒÒ²¼ÓÁËÅжÏVT!=NULL,¿ÉÊdzÌÐò»¹ÊDZÀÀ£.
ÎÒÊÇÖ±½ÓתµÄ±ÈÈç:CString strResult=(char *)_bstr_t(varResult);°üÀ¨ÆäËûµÄת»»¶¼ÊÔ¹ý,»¹ÊDZÀÀ£.
ÕâÒ»Çж¼ÊÇÔÚûÓдòSP1µÄʱºòËùûÓз¢ÉúµÄ.
´òÍêSP1¸Ã³ÌÐòÔÚ±¾»úÔËÐÐÕý³£,µ«ÊÇÒ»µ©·¢µ½ÆäËû»úÆ÷ÉϾͱÀÀ£.
ÏëÇë½Ì¸÷λ´óÏÀ,ÔõÑù½â¾ö???
лл,лл
»¹ÊÇÔÚͬһ¸öµØ·½±ÀÀ£,²»Ðа¡
²¶»ñ²»µ½Òì³£
´úÂëÀàËÆÓÚ
CString strResult;
try
{
strResult=(char *)_bstr_t(varResult);
}
catch(_com_error &e)
{
....
}
¸ù±¾½ø²»ÁËcatch,Ö±½ÓÔÚstrResult=(char *)_bstr_t(varResult);Õâ¸öÓï¾ä¾Í±ÀÀ£ÁË
strResult=(char *)_bstr_t(varResult);Õâ¾äûÓÐʲôÎÊÌâ°¡¡£¡£
ÓÐʲôÎÊÌâÄØ?
catch(...)Ò²²»ÐÐ
µ«ÊÇÔÚ±¾»ú¾ÍÔËÐеĺܺÃ,ÆäËû»úÆ÷¾Í²»ÐÐ
Ïà¹ØÎÊ´ð£º
ÎÊÌ⣱
ÎÒÓÃADOÁ¬½ÓÉèÁËÓû§ÃûÃÜÂëµÄÊý¾Ý¿â
µ«ÊÇÎÒ·¢ÏÖÎÒ²»ÊäÈë Óû§ÃûºÍÃÜÂë ¶¼¿ÉÒÔÁ¬½Ó³É¹¦ ¶øÇÒ»¹ÄܰÑÊý¾Ý¶Á³öÀ´
¼ôÁËÒ»¸öÃûΪtestÊý¾Ý¿â ½¨ÁËÒ»¸öÃûΪpeopleµÄ±í
¼ûÁËÒ»¸ö Óû§Ãû1234 ÃÜÂë1234 µÄ ......
ÎÒ×öÁËÒ»¸öС³ÌÐò£¬ÏëʵÏֵŦÄܾÍÊÇÔÚÎı¾¿òÖÐÊäÈëÐÕÃû£¬µã»÷²éѯ°´Å¥£¬¾ÍÄܲ鵽ACCESSÊý¾Ý¿âÖдËѧÉúµÄÐÅÏ¢£¨±àºÅ£¬ÐÕÃû£¬ÐÔ±ð£¬ÄêÁ䣩¿ÉÎÒ²»ÖªµÀÓï·¨¸ñʽ£¬ÎÒ×Ô¼ºÐ´µÄÓï¾äµ÷ÊÔÄÜͨ¹ý£¬¿ÉÊÇÔËÐÐʱ³ö´í£¨µã»÷²éѯ°´ ......
ACCESSÖвéѯÈçÏ£º
PARAMETERS letter Text ( 255 );
SELECT ¡¡¡¡ from table1 WHERE letter = letter
ÎÒ¿´µ½¹ý´«µÝÁ½¸ö²ÎÊý£¨Ê±¼ä£©µÄÀý×Ó¡£ÒòΪСµÜÊǰ®ºÃ£¬²»ÊÇרҵ³ÌÐòÔ±£¬ËùÒÔ²»ÖªµÀÔõ ......
¾ÍÊÇÊÇ·ñÖ§³Ö¶à¸öÁ¬½ÓµÄ²Ù×÷£¿ÔÚÒ»¸ö³ÌÐòÁ¬½ÓÕâ¸öÊý¾Ý¿âʱ£¬ÁíÒ»¸ö³ÌÐò»¹ÄÜÔÙÁ¬½ÓÕâ¸öÊý¾Ý¿âÂð£¿
×î¶àÖ§³Ö¶àÉÙ²¢·¢Á¬½Ó£¿
Ö§³Ö¡£
http://msdn.microsoft.com/en-us/library/ms810829.aspx
×î¶àÖ§³Ö¶àÉÙ²¢· ......
±í½á¹¹ÊÇÕâÑùµÄ£º
µ«ÎÒÓÃDTSµ¼³öµÄʱºò³ö´íÁË£º
²Ù×÷ÒÑÍ£Ö¹...
- ÕýÔÚ³õʼ»¯Êý¾ÝÁ÷ÈÎÎñ (³É¹¦)
- ÕýÔÚ³õʼ»¯Á¬½Ó (³É¹¦)
- ÕýÔÚÉèÖà SQL ÃüÁî (³É¹¦)
- ÕýÔÚÉèÖÃÔ´Á¬½Ó (³É¹¦)
- ÕýÔÚÉèÖÃÄ¿±êÁ¬½Ó (³É¹¦)
- ......