Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Dim strText As String Set cn = New ADODB.Connection cn.ConnectionString = "Provider=sqloledb;Data Source=QQ-03FIJRCFBORK;Initial Catalog=temm;User Id=sa;Password=sa;" cn.CursorLocation = adUseClient cn.OpenSet rs = New ADODB.Recordset rs.Open "select * from 客户表", cn Set ado_czjlb.Recordset = rs ado_czjlb.Refresh
Dim rs As ADODB.Recordset
Dim strText As String
Set cn = New ADODB.Connection
cn.ConnectionString = "Provider=sqloledb;Data Source=QQ-03FIJRCFBORK;Initial Catalog=temm;User Id=sa;Password=sa;"
cn.CursorLocation = adUseClient
cn.OpenSet rs = New ADODB.Recordset
rs.Open "select * from 客户表", cn
Set ado_czjlb.Recordset = rs
ado_czjlb.Refresh