ҪʾÀý´úÂë ¹ØÓÚaccessµÄ»ù±¾²Ù×÷(2)
http://topic.csdn.net/u/20091119/08/72e9d486-7364-41b7-8c86-effe1cda216b.html
½ÓÉÏÒ³£¬Çë¼ÌÐøÌÖÂÛ
ÕâÀï²åÈë²»ÁËÁ´½Ó£¬ÇëÏÂÂ¥°ÑÉÏÃæµÄµØÖ·¸ÄΪÁ´½Ó
Õâ¸öÀý×Ó»¹Òª¿ª¼¸Ìù°¡£¿
ÍøÉϺܶà³ÌÐòŶ£¬Ëæ±ãgoogleһϾÍÕÒµ½ÁË
µ½µ×Òª¸ÉÂ´´½¨¸öÊý¾Ý¿âÈ»ºó²éѯ£¿Èç¹ûÕâÑùµÄ»°ÍøÉ϶àµÄÊÇ¡£¡£¡£¡£¡£¡£¡£
²»½â¡£¡£¡£¡£¡£
°ï¶¥,ËÑË÷һϰÉ,±È½Ï¼òµ¥
¼ÌÐø°É£¬ÒªÓкܸߵĴæÖüËÙ¶È£¬
Delphi(Pascal) code:
sql := 'create table MyTable (id int,data1 decimal(6,5) )';
//...
Query.SQL.Clear;
Query.SQL.Add('Insert into MyTable (id,data1 ) ');///´Ë´¦²»ÖªµÀÈçºÎд
for i:=0 to 100 do
Query.SQL.Add(' values ??? ');////´Ë´¦ÓÖÈçºÎÐ´ÄØ
Query.ExecSQL;
»¹ÓÐÆäËüÎÊÌâÂð
Ïà¹ØÎÊ´ð£º
accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×Ö¶Î from ±í ¶ÁÈ¡Êý¾Ý
È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ
ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý
Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËÙ¶È£¡
Ò»´ÎÈ«²¿¶ÁÍê ......
ËüµÄ¶¨ÒåÊÇÕâÑùµÄ
_CRTIMP __checkReturn int __cdecl _access(__in_z const char * _Filename, __in int _AccessMode);
´ó¸ç£¬¿´¸öº¯ÊýÉùÃ÷¾ÍÄÜ¿´³öËû¸ÉɶµÄ£¿
´ÓÃüÃûÀ´¿´Ó¦¸ÃÊÇÅж ......
¸÷λ´óϺ£¬Ð¡µÜÓõÄÊÇADOÁ¬½ÓACCESSÊý¾Ý¿â£¬ÓÃDBGridÏÔʾ²éѯµÄÊý¾Ý£¬ÎÒ×öµÄÊǸöÊý¾Ý²É¼¯ÏµÍ³£¬¸ù¾Ý²»Í¬µÄµØÖ·°ÑÊý¾Ý·ÅÔÚACCESSÊý¾Ý¿âÖв»Í¬µÄ±íÀïÃæ£¬ÏÖÔÚÎÒÏë²éѯijһ¶Îʱ¼äÄÚËùÓбíÄÚµÄÊý¾Ý£¬²¢ÇÒÔÚDBGridÖÐÏÔʾ³ ......
Çë¸÷λָµãÏ£º³ÌÐò´úÂëÈçÏÂmingchen = "C:\Îļþ·¾¶\"
cat = New ADOX.Catalog
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & min ......
win2000ϵͳADOÁ¬½ÓACCESSÊý¾Ý¿â±ØÐèÒª½øÈë×ÀÃæÂð?
ÎÒÓÐÒ»¸ö×°ÁËwin2000-SP4µÄ»ú×Ó,ÒÑ×°ÁËMDAC 2.8 ,дÁ˸öwindows·þÎñ³ÌÐòÊÇÓÃADO²Ù×÷ACCESSÊý¾Ý¿âµÄ,Ææ¹ÖµÄÊÇ´ò¿ªÊý¾Ý¿âÎļþʱ,±ØÐèÒªµÇ¼µ½×ÀÃæ²ÅÄÜÕý³£´ò¿ ......