VB¸üÐÂDATAGRIDÀïÃæÊý¾Ý£¿£¿ - VB / »ù´¡Àà
Dim strSQL As String
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
rs.LockType = adLockOptimistic
rs.CursorType = adOpenKeyset
cnn.CursorLocation = adUseClient
cnn.ConnectionString = connstr
cnn.Open
rs.Open "SELECT ÐÕÃû,ѧºÃ,×Ü·Ö,¿Î³Ì from ZERO_TAB", cnn
If Not rs.EOF Then
Set Datagrid.DataSource = rs
End If
Çë½ÌÈçºÎʵÏÖ°´ÕÕ×Ü·ÖÔÚDATAGRIDÀïÃæ°´ÕÕ½µÐòÅÅÁУ¿²¢ÇÒ°ÑÅÅÁеÄǰ10λµÄ¿Î³Ì¸Ä³É¡°¼ÆËã»ú¡±£¨10Õâ¸öÊý¾ÝÊÇÔÚTEXT2ÀïÃæ£¬ÓпÉÄܲ»ÊÇ10£©£¬·Çǰ10µÄ²»Óùܣ¿£¿Ð»Ð»
ÍæµÃ²»Ò»°ãµÄ¸ß£¬ÄãµÄ·Ö¶¼ÊÇÕâôÀ´µÄ£¿
Ïà¹ØÎÊ´ð£º
ÎÒÔÚÀàÖÐÓÐÒ»¸öº¯Êý
Public Function DownloadAdditionalSite(SiteName As siteconfig, Directory As String, ymd As String) As Boolean
siteconfigÊÇÎÒ×Ô¶¨ÒåÀàÐ͵ÄÊý¾Ý£¬ÎªÊ²Ã´»áÌáʾ¡°Ö»ÓÐÔÚ¹«¹²¶ÔÏóÄ£¿éÖж ......
vbÖÐ ÏÖÔÚÎÒÒª°ÑÊý¾Ý¿âÀï´æ´¢µÄÒ»¸ö¸½¼þµÄÄÚÈÝÌæ»»ÁË£¬Ôõô×ö£¬Ö»ÊÇÌæ»»ÎÒÖ¸¶¨µÄλÖ㬲»ÊÇÈ«²¿Ìæ»»
Ç뽫ÎÊÌâ˵Ã÷°×£¬´æ´¢×ֶθñʽ£¬Èç¹ûÊÇBinary¸ñʽµÄ±È½ÏÂé·³£¬Èç¹ûÊÇ×Ö´®£¬Ö±½ÓÌæ»»¡£×îºÃ²»Òª½øÐÐÖ¸¶¨Î»ÖÃÌæ»»¡ ......
ÏÖÔÚÓиöxmlÎļþÊÇ<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xm ......
ÓÃVB±à³Ì¶ÁÈ¡¶ÌÐÅ,µÃµ½Ò»´ó¶Ñunicode±àÂë,Çë½ÌÈçºÎת»»³ÉÎı¾
ÀýÈç:¶ÁÈ¡¶ÌÐźó(»ªÎª900C»òTC35i),´®¿ÚµÃµ½ÈçÏÂÊý¾Ý:
+CMGL: 17,"REC UNREAD","8615007557713",,"10/03/30,09:37:15+32&qu ......