假设数据库中有学生信息表stud（sno，sname，ssex）。其中，性别ssex字段已建索引，要在
调试窗口中显示第一个男同学的信息，程序空白处应填写的语句是
Private Sub Form_Load( )
Dim rs As ADODB.Recordset
Set rs= New ADODB.Recordset
rs.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source= e:\考试中心教程\教学管理.mdb;"
rs.CursorType = adOpenKeyset
rs.LockType = adLockOptimistic
rs.Index = "ssex"
rs.Open "stud" , , , , adCmdTableDirect
_______________
Debug.Print rs("sno "), rs("sname "), rs("ssex ")
rs.Close
Set rs = Nothing
End Sub
🔥 607 热度
A
rs.Find "男", adSeekFirstEQ
B
rs.Seek "男", adSeekFirstEQ
C
rs.Find "男", adSeekLastEQ
D
rs.Seek "男", adSeekLastEQ
