假设数据库中有学生信息表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
- A.rs.Find "男", adSeekFirstEQ
- B.rs.Seek "男", adSeekFirstEQ
- C.rs.Find "男", adSeekLastEQ
- D.rs.Seek "男", adSeekLastEQ
热度🔥352
解析:打开微信小程序查看本题解析