¼±!!!!!!!!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¸Ã³ÌÐòÔÚ±¾»úÔËÐÐÕý³£,µ«ÊÇÒ»µ©·¢µ½ÆäËû»úÆ÷ÉϾͱÀÀ£.
ÏëÇë½Ì¸÷λ´óÏÀ,ÔõÑù½â¾ö???
лл,лл
¾ÍÊÇÖ¸ÁîÒýÓõÄ0x0000000ÄÚ´æ,¸ÃÄÚ´æ²»ÄÜread.
accessÊÇ2003£¬ADO,ÎÒ²»ÖªµÀÔõô¿´°æ±¾,²»¹ýÊÇ2008-4-14ÕâÌìµÄ,ºÇºÇ.
Ö´ÐÐʲô²Ù×÷³öÏÖÕâÖÖÇé¿ö£¬SQLÓï¾ä£¿
¾ÍÊÇ select * from ABCÕâÑùµÄ¼òµ¥µÄÓï¾ä°¡
Ò²ÐíÊÇÆäËü»úÆ÷ÉÏÃæÃ»ÓÐÏàÓ¦µÄXX.mdbÎļþµÄÔµ¹Ê°É£¿
{{
Ïà¹ØÎÊ´ð£º
µÚÒ»´Î½Ó´¥CrystalReport
¼±Ñ°ÕÒVb.net Access ͨ¹ý²éѯ³öµÄÊý¾ÝÊä³öµ½CrystalReportµÄÀý×Ó.
ÓеÄÅóÓÑÂé·³·¢À´Ñ§Ï°.¶àл!
¸úÄãµÄÒªÇó²î²»¶à£¬²Î¿¼Ò»Ï£º
http://topic.csdn.net/u/20090823/21/87af02d3-f4ca-480 ......
ÎÊÌâÊÇÕâÑùµÄ,ÏÖÔÚÓÐÒ»¸ö¹¤×ʱí,ÊÇEXCELµÄ,ÎÒÒª°ÑËüµ¼ÈëACCESS,ÒòΪ Òª²éѯÿ¸öÈ˵Ť×Ê,¸ù¾Ý²»Í¬µÄ±àºÅ¿ÉÒÔ²éѯµ½Ïà¶ÔµÄÈË,
ÓÃASP Ôõô½«EXCELµ¼Èëµ½ACCESS,¶øÇÒÿÔ¶¼Óв»Í¬µÄ±í,
ÒýÓÃ
Æäʵ¾ÍÊǰÑEXCELµ±³ÉÊý ......
$conn = @new COM("ADODB.Connection") or die ("ADOÁ¬½Óʧ°Ü!");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("database.mdb");
$conn-&g ......
´íÎóÌáʾ£º
Error creating bean with name 'DAOProxy' defined in class path resource [appcontext.xml]: Cannot resolve reference to bean 'transactionManager' while setting bean property 'transactionMana ......
oracle ´úÂ룺
select * from (select * row_number() over ( partition by ÁªÏµºÅÂë order by ÒµÎñºÅÂë ) rn from ºÅÂë²éѯ) where rn<2
Ч¹ûÊÇ£º½« ijһָ¶¨×ֶΠɾ³ýÖØ¸´µÄºÅÂ룬²¢±£Áô¸ÃºÅÂëÏà¹ØµÄÆäËûÐ ......