Dim cnn As cnn
Dim cmd As Command
Dim rs As Recordset
Dim sqlstr As String
Set cnn = New Connection
Set cmd = New Command
Set rs = New Recordset
cnn.ConnectionString = "Provider=MSDASQL.1;Password=data;Persist Security Info=True;User ID=sa;Data Source=AMMICPRO-ODBC;Initial Catalog=XJDEMO"
cnn.Open
cmd.ActiveConnection = cnn
sqlstr = "select fitemno from itemm"
cmd.CommandText = sqlstr
Set rs = cmd.Execute
cbofitem.Clear
Dim i As Long
If Not rs.EOF Then
For i = 1 To rs.RecordCount
cbofitem.AddItem rs!fitemno
rs.MoveNext
Next i
End If
rs.Close
Set rs = Nothing
**************************************************************代码执行后没有反应,但是如果把该代码 cnn.ConnectionString = "Provider=MSDASQL.1;Password=data;Persist Security Info=True;User ID=sa;Data Source=AMMICPRO-ODBC;Initial Catalog=XJDEMO"
cnn.Open替换成已有的连接则是正常的,谢谢!
Dim cmd As Command
Dim rs As Recordset
Dim sqlstr As String
Set cnn = New Connection
Set cmd = New Command
Set rs = New Recordset
cnn.ConnectionString = "Provider=MSDASQL.1;Password=data;Persist Security Info=True;User ID=sa;Data Source=AMMICPRO-ODBC;Initial Catalog=XJDEMO"
cnn.Open
cmd.ActiveConnection = cnn
sqlstr = "select fitemno from itemm"
cmd.CommandText = sqlstr
Set rs = cmd.Execute
cbofitem.Clear
Dim i As Long
If Not rs.EOF Then
For i = 1 To rs.RecordCount
cbofitem.AddItem rs!fitemno
rs.MoveNext
Next i
End If
rs.Close
Set rs = Nothing
**************************************************************代码执行后没有反应,但是如果把该代码 cnn.ConnectionString = "Provider=MSDASQL.1;Password=data;Persist Security Info=True;User ID=sa;Data Source=AMMICPRO-ODBC;Initial Catalog=XJDEMO"
cnn.Open替换成已有的连接则是正常的,谢谢!
dim cnn as dao.connection
或
dim cnn as ado.connection
sqlstr = "select fitemno from itemm"
cmd.CommandText = sqlstr
Set rs = cmd.Execute
'省为:set rs=cnn.execute sqlstr