Private Sub Form_Load() Dim txtsql As String Dim Rs As ADODB.Recordset Dim msgtext As String
Dim Cnn As New ADODB.Connection Cnn.ConnectionString = "PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=192.168.1.100;DATABASE=finance;UID=sa;PWD=" If Cnn.State <> ADODB.ObjectStateEnum.adStateClosed Then Cnn.Close Cnn.Open
Rs.Open "select type from fianace", Cnn, adOpenStatic, adLockReadOnly If Not Rs.EOF And Not Rs.BOF Then Rs.MoveFirst Do While Not Rs.EOF Combo1.AddItem Rs.Fields(0).Value Rs.MoveNext Loop End If Rs.Close Set Rs = Nothing End Sub
Rs.Open "select type from fianace", Cnn, adOpenStatic, adLockReadOnly 我说的是这行是不是有问题?因为我运行的时候出错了。
实时错误‘91’对变量或with块变量未设置
忘了写了 dim rs as new adodb.recordset或者加一句 set rs=new adodb.recordset
Dim txtsql As String
Dim Rs As ADODB.Recordset
Dim msgtext As String
Dim Cnn As New ADODB.Connection
Cnn.ConnectionString = "PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=192.168.1.100;DATABASE=finance;UID=sa;PWD="
If Cnn.State <> ADODB.ObjectStateEnum.adStateClosed Then Cnn.Close
Cnn.Open
Rs.Open "select type from fianace", Cnn, adOpenStatic, adLockReadOnly
If Not Rs.EOF And Not Rs.BOF Then
Rs.MoveFirst
Do While Not Rs.EOF
Combo1.AddItem Rs.Fields(0).Value
Rs.MoveNext
Loop
End If
Rs.Close
Set Rs = Nothing
End Sub
我说的是这行是不是有问题?因为我运行的时候出错了。
dim rs as new adodb.recordset或者加一句 set rs=new adodb.recordset