最近在做vb+sql的毕业设计 关于图书管理系统的 在运行时遇到点问题 报错:对象名‘类别’无效

来源:百度知道 编辑:UC知道 时间:2024/09/20 12:14:38
Dim rs_find As New ADODB.Recordset

Dim sql As String
sql = "select * from Àà±ð"
rs_find.CursorLocation = adUseClient
rs_find.Open sql, conn, adOpenKeyset, adLockPessimistic
rs_find.MoveFirst
If Not rs_find.EOF Then
Do While Not rs_find.EOF
Combo1.AddItem rs_find.Fields(0)
rs_find.MoveNext
Loop
Combo1.ListIndex = 0
End If
rs_find.Close
是这段代码 报错时显示 rs_find.Open sql, conn, adOpenKeyset, adLockPessimistic有问题
请求帮助 啊 谢谢了

Dim rs_find As New ADODB.Recordset

代码帮繁锁了,简化一下
Dim sql As String
sql = "select * from tablename"
rs_find.Open sql, conn, 1,3
Do While Not rs_find.EOF
Combo1.AddItem rs_find.Fields(0)
rs_find.MoveNext
Loop
Combo1.ListIndex = 0
rs_find.Close