VB..........Óï·¨´íÎ󣬰ïæ¿´¿´£¬Ð»Ð»
´ó¼Ò°ïæ¿´¿´£¬Ã»ÓдíÎóÌáʾ£¬sql2ûִÐеÄÑù×Ó£¬Ö÷Òª¿´ÏÂDBA.DISPOSITION¸úsql2£¬£¬£¬Ð»Ð»£¬ÔÚÏßµÈ
VB code:
Private Sub Command1_Click()
Dim cn_db As New ADODB.Connection
Dim rs_db As New ADODB.Recordset
Dim rs_db2 As New ADODB.Recordset
Dim cn_sql As New ADODB.Connection
Dim sql As String
Dim sql2 As String
Dim dispcount As Integer
dispcount = 0
cn_db.Open "DSN=004_8V;uid=guest;pwd=guest;"
cn_db.CursorLocation = adUseClient
If cn_db.State = 1 Then
rs_db.Open "select City,Areacode,PhoneNumber,LastDisposition,LastModifiedDateTime from DBA.SAMPLE", cn_db, adOpenDynamic, adLockOptimistic
rs_db2.Open "select Disposcode,Description from DBA.DISPOSITION", cn_db, adOpenDynamic, adLockOptimistic
If rs_db.RecordCount > 0 Then
cn_sql.Open "driver={sql server};server=(local);database=tmp_cati;uid=sa;pwd=;"
'On Error Resume Next
'cn_sql.BeginTrans
Do While rs_db(3) = "18"
DoEvents
sql = "insert into ºÅÂë×Ü¿â(³ÇÊÐ,ÇøºÅ,ºÅÂë,´¦ÀíÇé¿ö,½Ó´¥Ê±¼ä) " & _
"values('" & rs_db(0) & "','" & rs_db(1) & "','" & rs_db(2) & "','" & rs_db(3) &
Ïà¹ØÎÊ´ð£º
¿´ÁËһЩVB iniÎļþдÈë¶ÁÈ¡µÄ·½·¨ µ«ÊÇ»¹ÊDz»ÖªµÀÔõôд£¬ÉÏÃæÐ´Á˺ܳ¤ ºÜ¶à£¬µ«ÊÇÎÒ²»ÖªµÀÔõôÓã¬ÎÒÏëÎÊÒ»ÏÂÔõÑùд²ÅÄÜʵÏÖÔÚTEXT1ÖÐд×Ö£¬È»ºóµãCommand1Ìá½»£¬È»ºóTEXT1ÀïÃæµÄÊý×Ö¾Íд½øINIÀïÃæ[Section]µÄKey1 ......
ÔÚÏÂÊÇvbµÄÐÂÊÖ£¬Ïëд¶Î³ÌÐò£¬ÔÚvbÖУ¬Ê¹ÓÃwscriptµ÷ÓÃһЩÍⲿµÄÃüÁµ«ÊdzÌÐòÖ´ÐÐÒ»Ö±ÓдíÎó£¬Çë¸÷λ¸ßÊÖ°ïæ½â´ðÏ£¬Ð»Ð»¡£
´úÂëÈçÏ£º
VB code:
Private Function getFile_CMD(filename, filepath) As Bo ......
ÎÒÊÇVBµÄгÉÔ±£¬ÏÖÔÚÏëÓÃVBÀ´×ö¸öTXTÎĵµ£¬Çë´ó¼Ò¸øÎÒ´úÂë¼°½éÉÜÒ»ÏÂÏàÓ¦µÄ¿Ø¼þ£¡
·Ç³£¸Ðл£¡£¡£¡£¡£¡£¡
¿ÉÒÔÓÃһЩOFFICE¿Ø¼þ
googleÉÏÕÒһϰÉ,VBдÈëTXT,ºÜ¶àÑùÀý´úÂëµÄ
Ö±½Óµ÷²éÓþͿÉÒÔÁË
Ãæ¶ÔÃÀÅ® ......
VBÔõÑù»ñµÃÊó±ê´¦µÄ³¬¼¶Á¬½ÓÄØ£¿
ÔÚWebBrowser¿Ø¼þÖÐÓÐÕâÑùÒ»¸öʼþ:StatusTextChange(index As Integer, ByVal Text As String)
ËüµÄText²ÎÊýÕýÊÇÊó±ê´¦µÄ³¬¼¶Á¬½Ó,µ«ÎÊÌâÊÇÈç¹ûÎÒµÄä¯ÀÀÆ÷Õýà ......
ÎÒÔÚÀàÖÐÓÐÒ»¸öº¯Êý
Public Function DownloadAdditionalSite(SiteName As siteconfig, Directory As String, ymd As String) As Boolean
siteconfigÊÇÎÒ×Ô¶¨ÒåÀàÐ͵ÄÊý¾Ý£¬ÎªÊ²Ã´»áÌáʾ¡°Ö»ÓÐÔÚ¹«¹²¶ÔÏóÄ£¿éÖж ......