¡ù==================================================================
¡ù±¾Á¬ÔØÎÄÕÂ˵Ã÷£º
¡ù1¡¢Á¬ÔØÊ×·¢ÓÚ¡¶Èí¼þ±¨¡·£¨http://www.sweek.com£©2006Äê21ÆÚ£¨2006Äê5ÔÂ22ÈÕ£©£»
¡ù2¡¢´Ë´ÎÍøÉÏÁ¬ÔزÉÓõÄÊÇÔ¸å¼þ½á¹¹£¬ÄÚÈÝÓë¡¶Èí¼þ±¨¡··¢±íÂÔÓв»Í¬£»
¡ù3¡¢Ð»¾ø³ý¡¶Èí¼þ±¨¡·¼°ÆäÏà¹Ø¿¯ÎïÖ®ÍâµÄ´«Í³Ã½Ì岿·Ö»òÈ«²¿×ªÔØ£»
¡ù4¡¢Ð»¾øÈκÎÊÕ·ÑýÌå¡¢ÍøÂç×ªÔØ£»
¡ù5¡¢Ô×÷Õߣºuruseibest £¬blog£ºhttp://blog.csdn.net/uruseibest£»
¡ù6¡¢ÈçÓÐÆäËüÒÉÎÊ£¬ÇëÁªÏµ×÷Õߣ»
¡ù7¡¢ÈçÓÐ×ªÔØ£¬±ØÐëÁ¬Í¬±¾ËµÃ÷Ò»²¢·¢±í£¬·ñÔò½«×·¾¿×ªÔØÕßÔðÈΡ£
¡ù======================================================================
µÚÒ»Õ ǰÑÔ
Windows 98ÒÔÉϵIJÙ×÷ϵͳÔÚϵͳĿ¼Ï¶¼´øÓÐiphlpapi.dllÕâ¸ö¶¯Ì¬Á´½Ó¿âÎļþ£¬Ëü¿ÉÒÔ°ïÖú³ÌÐòÔ±·½±ãµØ»ñÈ¡¼ÆËã»úÍøÂçÐÅÏ¢¡£¶ÔÓÚC³ÌÐòÔ±À´Ëµ£¬Ö»ÒªÓÐiphlpapiµÄÍ·Îļþ£¬µ÷ÓÃiphlpapi.dllÊǺܼòµ¥µÄÊ£¬µ«ÊǶÔÓÚVb³ÌÐòÔ±ÔòÊDZȽÏÀ§ÄѵÄÎÊÌâ¡£±¾ÎĽ«¾ÍVbÖе÷ÓÃiphlpapi.dllÀ´½éÉÜiphlpapiµÄʹÓá£
±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/UruseiBest/archive/2006/12/20/1450351.aspx ......
µ±MDB Îļþ¼ÓÁËÃÜÂ룬ֱ½ÓÓÉ Access ´òÓ¡MDBÎļþʱ£¬»á³öÏÖÃÜÂë¶Ô»°¿ò£¬Ñ¯ÎÊÃÜÂë¡£µ«ÊÇÈôÒªÓÉ VB ³ÌÐòÖдòÓ¡£¬±Ø須¸ü¸Ä VB³ÌÐòÖдò¿ªMDBÎļþµÄÖ¸Á·ñÔò»á³öÏÖ´íÎóÐÅÏ¢£¡ÒÔÏÂÕë¶Ô¸÷ÖÖÇé¿ö£¬·Ö別¼ÓÒÔ˵Ã÷£º
1¡¢ ʹÓà DAO ÃüÁî´ò¿ªMDBÎļþ£ºOpenDatabase
ÈôÒªÓɳÌÐòÖдò¿ª£¬ÃüÁîÈçÏ£º
Set DB = OpenDatabase(DatabaseName, False, False, ";Pwd=ÃÜÂë")
ʵÀý£º
Dim db As Database
Set db = OpenDatabase("C:\db1.mdb", False, False, ";Pwd=1")
ÈôҪʹÓà Data ¿Ø¼þ£¬É趨·½·¨ÈçÏ£º
1¡¢É趨 DatabaseName ÊôÐÔ (MDBÎļþÃû³Æ / º¬Â·¾¶)
2¡¢É趨 Connect ÊôÐÔ£¬將Ô¤ÉèµÄ×Ö´® "Access" ¸Ä³É ";Pwd=ÃÜÂë" ......
¡ù==================================================================
¡ù±¾Á¬ÔØÎÄÕÂ˵Ã÷£º
¡ù1¡¢Á¬ÔØÊ×·¢ÓÚ¡¶Èí¼þ±¨¡·£¨http://www.sweek.com£©2006Äê21ÆÚ£¨2006Äê5ÔÂ22ÈÕ£©£»
¡ù2¡¢´Ë´ÎÍøÉÏÁ¬ÔزÉÓõÄÊÇÔ¸å¼þ½á¹¹£¬ÄÚÈÝÓë¡¶Èí¼þ±¨¡··¢±íÂÔÓв»Í¬£»
¡ù3¡¢Ð»¾ø³ý¡¶Èí¼þ±¨¡·¼°ÆäÏà¹Ø¿¯ÎïÖ®ÍâµÄ´«Í³Ã½Ì岿·Ö»òÈ«²¿×ªÔØ£»
¡ù4¡¢Ð»¾øÈκÎÊÕ·ÑýÌå¡¢ÍøÂç×ªÔØ£»
¡ù5¡¢Ô×÷Õߣºuruseibest £¬blog£ºhttp://blog.csdn.net/uruseibest£»
¡ù6¡¢ÈçÓÐÆäËüÒÉÎÊ£¬ÇëÁªÏµ×÷Õߣ»
¡ù7¡¢ÈçÓÐ×ªÔØ£¬±ØÐëÁ¬Í¬±¾ËµÃ÷Ò»²¢·¢±í£¬·ñÔò½«×·¾¿×ªÔØÕßÔðÈΡ£
¡ù======================================================================
µÚÎåÕ ½áÊøÓï
Windows×ÔÉíÌṩÁËһЩÔÚÃüÁîÌáʾ·ûϲÙ×÷µÄÃüÁî¿ÉÒÔ»ñµÃÍøÂçÐÅÏ¢£¬±ÈÈçIpconfig¡¢ArpµÈ£¬¶¼¿ÉÒÔʹÓÃIphlpapi.dllµÄº¯ÊýÀ´»ñµÃͬÑùЧ¹û£¬ÎÒÃÇ¿ÉÒÔʹÓÃIphlpapiº¯ÊýÀ´ÖÆ×÷×Ô¼ºµÄIpconfig³ÌÐò¡¢Arp³ÌÐò»òÕß±ðµÄ³ÌÐò¡£
ÒÔÉÏ×ܽáÁËIphlpapi.dllËùÌṩ´ó²¿·Öº¯Êý£¬ËäÈ»ÒÔÉϺ¯ÊýÏêϸµÄ˵Ã÷ºÍÓ¦Óö¼ÊǶÔVb³ÌÐòÔ±µÄ£¬µ«ÊÇÒ²²»Ê§ÎªC³ÌÐòÔ±µÄ¸¨Öú×ÊÁÏ¡£ÎÄÕÂÖÐËù¸½´úÂë¾ùÊÇÔ´³ÌÐòµÄ¹Ø¼ü´úÂ룬Դ³ÌÐò¸½Îĺó¡£ÓÉÓÚ¸÷È˵ĵçÄÔÍøÂçÇé¿ö²»Ò»£¨±ÈÈçÎҵĵçÄÔ¾ ......
×î½üÔÚÀûÓÃvb±àд¹ØÓڰٶȿռäÑéÖ¤Âë×Ô¶¯Ê¶±ðµÄ³ÌÐò£¬µ«ÊÇһֱûÄÜʵÏÖ£¬ÔÒò¾ÍÊÇÎÒµÄˮƽ»¹ÊÇÌ«²Ë¡£ÓÚÊÇ´ÓÍøÉÏѰÕÒÁËºÜ¶à¹ØÓÚÑéÖ¤Âëʶ±ðµÄÔ´´úÂ룬´ÓÀïÃæÑ§µ½²»ÉÙ¶«Î÷£¬ËãÊÇû°×ŬÁ¦°É¡£ÔÚ´Ë×ܽáÒ»ÏÂѧµ½µÄ¶«Î÷£¬Ï£ÍûÄܶÔÅóÓÑÃÇÓÐЩ°ïÖú°É¡£
Ê×ÏÈÕûÀíϱàдÑéÖ¤Âëʶ±ðµÄ˼·°É£º
1£¬Ê×Ïȱàд»ñÈ¡ÑéÖ¤ÂëͼƬµÄ³ÌÐò£¬ÒÔ»ñÈ¡°Ù¶È¿Õ¼äÁôÑÔΪÀý£¨×¢£ºÒÔϽÔÒ԰ٶȿռäÁôÑÔÑéÖ¤ÂëΪÀý£©¡£
2£¬Æä´Î±àд´¢´æÑéÖ¤ÂëͼƬµÄ³ÌÐò£»
3£¬½«Í¼Æ¬ÖеÄÏñËØ½øÐйéÀà£¬Ö»Çø·Ö°×É«ºÍºÚÉ«£¬²¢½«ºÚÉ«µÄ×ø±ê¼Ç¼£»
4£¬Çø·ÖËĸöÑéÖ¤Âë µÄλÖ㬽«Ã¿¸öÑéÖ¤ÂëµÄ×ø±ê¹éµ½µ¥¶ÀµÄÊý×éÖÐÈ¥£»
5£¬½«Ã¿¸öÑéÖ¤ÂëµÄÏßÌõ½øÐÐÆ½¾ù»¯£¬²¢½«ÑéÖ¤ÂëµÄ ......
ÏÂÃæÊÇÎÒËùÕÆÎÕµÄʹÓÃADO¶ÔÊý¾Ý¿â²Ù×öµÄһЩ³£Ó÷½·¨£¬Ö÷ÒªÊÇÌṩ¸ø³õѧÕß×öΪ²Î¿¼£¬Óв»¶ÔµÄµØ·½ÇëÖ¸Õý¡£ÈçÓв¹³ä²»Ê¤ÈÙÐÒ
×¼±¸¹¤×ö
========
À´Ô´£ºwww.va1314.com/bc
Dim conn As New ADODB.Connection '´´½¨Ò»¸ö Connection ʵÀý£¬ÔÚÕâÀïʹÓÃNewµÈÓÚ½«DimºÍSetºÏ²¢ÎªÒ»¶Î´úÂëÖ´ÐÐ
Dim rs As ADODB.Recordset '´´½¨Ò»¸ö Recordset ʵÀý£¬²»Ê¹ÓÃNew ÊÇÒòΪ£¬¾³£ÐèÒªÖØ¸´Ê¹ÓÃSet£¬Òò¶øÃ»±ØÒªÔÚÕâÀïʹÓÃ
Dim CnStr As String, Sql As String '´´½¨Á½¸ö×Ö·û´®±äÁ¿·Ö±ð´æ·ÅÁ½¸ö¼¯ºÏµÄSQLÓï¾ä´úÂë¶Î
1¡¢×°ÔØÊý¾Ý¿â(²»ÊôÓÚRecordset¼¯ºÏ)
=============
Dim FileNamw$, DbIp$, DbName$, DbUser$, DbPw$
'ÒÔÉÏ5¸ö×Ö·û´®±äÁ¿·Ö±ð±íʾÎļþ·¾¶ºÍÎļþÃû¡¢Êý¾Ý¿âµØÖ·¡¢Êý¾Ý¿âÃû¡¢Êý¾Ý²Ù×öÔ±Óû§Ãû¡¢²Ù×öÔ±ÃÜÂë
FileName = App.Path & "'Êý¾Ý¿âÃû'"
DbIp = "Êý¾Ý¿âµØÖ·"
DbName = "Êý¾Ý¿âÃû"
DbUser = "Êý¾Ý²Ù×öÔ±Óû§Ãû"
DbPw = "²Ù×öÔ±ÃÜÂë"
'ÒÔÉϱäÁ¿¸ù¾ÝÊý¾Ý¿âÀàÐ͵IJ»Í¬¶ø²»Í¬£¬ÓпÉÄÜÖ»ÐèÒª1ÖÁÁ½¸ö±äÁ¿
'1)Á¬½ÓAccessÊý¾Ý¿â:
'-------------------
CnStr = "PROVIDER=microsoft.jet.oledb.3.51;persi ......
Option Explicit
Private Const INTERNET_OPEN_TYPE_DIRECT = 1
Private Const scuseragent = "vb wininet"
Private Const INTERNET_FLAG_PASSIVE = &H8000000
'µ÷ÓÃÉèÖû·¾³
Private Declare Function InternetOpen Lib "wininet.dll" Alias "InternetOpenA" (ByVal sAgent As String, ByVal lAccessType As Long, ByVal sProxyName As String, ByVal sProxyBypass As String, ByVal lFlags As Long) As Long
'Á¬½Ó·þÎñÆ÷
Private Declare Function InternetConnect Lib "wininet.dll" Alias "InternetConnectA" (ByVal hInternetSession As Long, ByVal sServerName As String, ByVal nServerPort As Integer, ByVal sUsername As String, ByVal sPassword As String, ByVal lService As Long, ByVal lFlags As Long, ByVal lContext As Long) As Long
'ÉÏ´«ºÊý
Private Declare Function FtpPutFile Lib "wininet.dll" Alias "FtpPutFileA" (ByVal hFtpSession As Long, ByVal lpszLocalFile As String, ByVal lpszRemoteFile As String, ByVal dwFlags As Long, ByVal dwContext As Long) As Boolean
Private Declare Function FtpGetFile Lib "wininet.dl ......