VB´´½¨ACCESSÊý¾Ý¿âÈ«½â
VB´´½¨ACCESSÊý¾Ý¿âÈ«½â ¶¯Ì¬´´½¨Êý¾Ý¿â¡¢´´½¨±í£¬´´½¨¼Ç¼ ADO¡¢ADOX2009Äê04ÔÂ20ÈÕ ÐÇÆÚÒ» 10:17ÕªÒª£º ±¾ÎIJûÊöÁËÔÚVB³ÌÐòÖÐÀûÓÃADO¶ÔÏó¶¯Ì¬´´½¨Êý¾Ý¿âºÍÊý¾Ý±íµÄ·½·¨£¬ÕâЩ·½·¨ÔÚ¿ª·¢VBÊý¾Ý¿âÓ¦ÓóÌÐòÖкÜÓÐʵÓüÛÖµ£¬Ëü¿ÉÒÔÌá¸ßÊý¾Ý¿â³ÌÐòÁé»îÐÔ¡£
¡¡¡¡¹Ø¼ü´Ê£ºÊý¾Ý¿â¡¢Êý¾Ý±í¡¢ADO¡¢ADOX
¡¡¡¡1: ÎÊÌâµÄÌá³ö
¡¡¡¡ÔÚVisual BasicÖУ¬³£ÓõÄÊý¾Ý·ÃÎʽӿÚÓÐÏÂÁÐÈýÖÖ£ºÊý¾Ý¿â·ÃÎʶÔÏó(DAO£¬Data Access Object)¡¢Ô¶³ÌÊý¾Ý¿â¶ÔÏó(RDO£¬Remote Data Object)ºÍActiveXÊý¾Ý¶ÔÏó(ADO£¬ActiveX Data Object )¡£Êý¾Ý¿â·ÃÎʼ¼ÊõÒ»Ö±ÔÚ²»¶Ï½ø²½£¬¶øÕâÈýÖÖ½Ó¿ÚµÄÿһÖÖ¶¼·Ö±ð´ú±íÁ˸ü¼ÊõµÄ²»Í¬·¢Õ¹½×¶Î¡£×îеÄÊÇADO£¬ËüÊDZÈRDOºÍDAO¸ü¼Ó¼òµ¥£¬È»¶ø¸ü¼ÓÁé»îµÄ¶ÔÏóÄ£ÐÍ¡£ÕýÒòÈç´Ë£¬Ô½À´Ô½¶àµÄÈËÔÚÓÃVB¿ª·¢Êý¾Ý¿âÈí¼þʱʹÓÃADO×÷ΪÊý¾Ý·ÃÎʽӿڡ£ÔÚ¿ª·¢¹ý³ÌÖУ¬ÎÒÃÇͨ³£µÄʹÓõķ½·¨ÊÇ£ºÏÈʹÓÃÊý¾Ý¿â¹ÜÀíϵͳ(ÀýÈ磺Microsoft Access)»òVBÖеĿÉÊÓ»¯Êý¾Ý¹ÜÀíÆ÷½¨Á¢ºÃÊý¾Ý¿âºÍÊý¾Ý±í½á¹¹£¬È»ºóÔÚ³ÌÐòÖÐͨ¹ýʹÓÃADODCÊý¾Ý¿â¿Ø¼þ»òÒýÓÃADO¶ÔÏóÓëÊý¾Ý¿âÖÐµÄ±í½¨Á¢Á¬½Ó£¬ÔÙͨ¹ýÊý¾Ý¿â¸ÐÖª¿Ø¼þ(ÀýÈ磺Îı¾¿ò¡¢DataGridµÈ)À´½øÐÐÊý¾Ý¿âµÄ¸÷ÖÖ²Ù×÷¡£ÔÚÕâÖÖ¿ª·¢¹ý³ÌÖУ¬ÎÒÃÇÓÐʱÐèÒªÃæ¶ÔÕâÑùÒ»¸öÎÊÌ⣺ÈçºÎÈÃÓû§ÔÚ³ÌÐòÔËÐйý³ÌÖж¯Ì¬µØ½¨Á¢×Ô¼ºËùÐèµÄÊý¾Ý¿âºÍÊý¾Ý±íÒÔÌá¸ß³ÌÐòµÄÁé»îÐÔÄØ£¿ÔÚ³ÌÐòÔËÐйý³ÌÖн¨Á¢×Ô¼ºËùÐèµÄÊý¾Ý¿âºÍÊý¾Ý±í£¬Æä±¾ÖʾÍÊÇÓôúÂë(»òÕß˵ͨ¹ý±à³Ì)À´½¨Á¢Êý¾Ý¿âºÍÊý¾Ý±í¡£ÖÚËùÖÜÖª£¬ÔÚFoxpro»òASP±à³ÌÖУ¬ÕâÊǺÜÈÝÒ×µÄÒ»¼þʼþ¡£ÄÇôÔÚVBÊý¾Ý¿â±à³ÌÖÐÓÖÊÇÔõÑùÀ´²Ù×÷µÄÄØ£¿ÔÚVBÊý¾Ý¿â±à³ÌÖУ¬Èç¹ûʹÓÃDAO×÷ΪÊý¾Ý¿â·ÃÎʽӿڼ¼Êõ£¬Ôò¿ÉÒÔÓÃCreateDatabase½áºÏCreateTableDef·½·¨À´ÊµÏÖ£¬Ä¿Ç°ÒÑÓв»ÉÙÊéºÍÔÓÖ¾¶¼½²µ½ÁËÕâÖÖ·½·¨£¬±¾ÎľͲ»ÔÙ½²ÊöÁË£»µ«ÄãÈç¹ûʹÓõÄÊÇ×îеÄÊý¾Ý¿â·ÃÎʽӿڼ¼ÊõADO£¬ÄãÈ´·¢ÏÖÄ¿Ç°µÄÊéºÍÔÓÖ¾ÉÏûÓÐÎÄÕ½²µ½ÈçºÎÓôúÂëÀ´½¨Á¢Êý¾Ý¿âºÍÊý¾Ý±íµÄ·½·¨£¬¿ÉÓÐʱÎÒÃǷdz£ÐèÒªÓõ½ÕâÖÖ·½·¨£¬ÏÂÃæÎÒÃǾÍÀ´½â¾öÕâ¸öÎÊÌâ¡£
¡¡¡¡2: ADOÓëADOX
¡¡¡¡ÎÒÃÇÏÈÀ´¶ÔADO ºÍADOX½øÐмòµ¥µÄÈÏʶ¡£ÔÚVB6ÖУ¬Ê¹ÓÃADO¿ª·¢Êý¾Ý¿âÓ¦ÓóÌÐòʱ£¬ÎÒÃÇÒªÒýÓöÔÏó¿â"Microsoft ActiveX Data Objects 2.5 Library"£¬ Õâ¸ö¶«Î÷µÄ¼ò³Æ¾ÍÊÇADO£¬ËüÊÇVB6Êý¾Ý¿â×îºËÐĵĶÔÏóȺ£¬Ò²ÊÇVBÊý¾Ý¿â¿ª·¢ÈËÔ±¾³£ËùÒýÓõĶÔÏó¿â£¬ÔÚVB6ÖÐÄã¿ÉÒÔ¿´µ½ËüµÄ¸÷ÖÖ°æ±¾£¬´Ó2.0°æµ½2.6°æ¶¼ÓУ¬ºÜ¶àÈ˶ÔËüÒѾºÜÊìϤ£¬ÔÚ´ËÎÒÃDz»ÔÙÏêϸ½éÉÜ¡£Èç¹ûÒªÔÚ³ÌÐòÔËÐйý³ÌÖд´½¨Êý¾
Ïà¹ØÎĵµ£º
VB Winsock StateÊôÐÔÖµ
'winsock ״̬³£Êý
'sckClosed 0 ¹Ø±Õ״̬
'sckOpen 1 ´ò¿ª×´Ì¬
'sckListening 2 ÕìÌý״̬
'sckConnectionPending 3 Á¬½Ó¹ÒÆð
'sckResolvingHost 4 ½âÎöÓòÃû
'sckHostResolved 5 ÒÑʶ±ðÖ÷»ú
'sckConnecting 6 ÕýÔÚÁ¬½Ó
'sckConnected 7 ÒÑÁ¬½Ó
'sckClosing 8 ͬ¼¶ÈË ......
VB ²éÕÒÓÎÏ·´°¿Ú¾ä±úµÄ·½·¨
ÐÅÏ¢À´Ô´£ººÚ¿Í´úÂë ±à¼£ºroot ä¯ÀÀ´ÎÊý£º191 ¼ÓÈëʱ¼ä£º2010-3-20 1:40:47 ÆÀÂÛ(0)
[ÎÊÌâÒ»,²»ÄÜ»ñµÃ´°¿Ú¾ä±ú]
Ò»°ãÑ°ÕÒ´°¿Ú¾ä±ú¶¼ÊÇÖ±½ÓFindWindow°É,ÕâÑùÊDz»ÐеÄ,QQÈý¹úÔÚÕâЩº¯ÊýÉÏ×öÁËһЩ´¦Àí.ÎÒÀ´¸ø´ó¼Ò˵¸öÍòÄܵķ½·¨°É,
¶ÔÓÚGetWindowText·½·¨ÓÎÏ·¾Í¹Ü²»µ½ÁË,¿ÉÒÔÅäºÏʹÓÃGetW ......
C#Á¬½ÓÁ¬½ÓAccess
Ê×ÏÈ¿´Ò»¸öÀý×Ó´úÂëƬ¶Ï:
³ÌÐò´úÂë:
--------------------------------------------------------------------------------
using System.Data;
using System.Data.OleDb;
......
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+=@"Data Source=C:\BegASPNET\Northwin ......
²éѯÓï¾äÖ»ÒªÕâÑùд,¾Í¿ÉÒÔËæ»úÈ¡³ö¼Ç¼ÁË
SQL="Select top 6 * from Dv_bbs1 where isbest = 1 and layer = 1 order by newID() desc"
ÔÚACCESSÀï
SELECT top 15 id from tablename order by rnd(id)
SQL Server£º
Select TOP N * from TABLE Order By NewID()
Access£º
Select TOP N * from TABLE Order By Rnd(ID ......