Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
Dim St As String
St = "Provider=sqloledb;data source=数据库;uid=;pwd='"
cn.ConnectionString = St
cn.Open
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
Set rs.ActiveConnection = cn
rs.Open "select * from 序号 where 序号名 ='" & Bhmc & "'", cn, adOpenStatic, adLockOptimistic
Set cn = New ADODB.Connection
Dim St As String
St = "Provider=sqloledb;data source=数据库;uid=;pwd='"
cn.ConnectionString = St
cn.Open
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
Set rs.ActiveConnection = cn
rs.Open "select * from 序号 where 序号名 ='" & Bhmc & "'", cn, adOpenStatic, adLockOptimistic
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货