Dim sql As String
Dim rs As New ADODB.Recordset
sql = "Select * From 班级信息表 Order By ID Desc"
rs.CursorLocation = adUseClient
rs.Open sql, Conn, adOpenDynamic, adLockPessimistic
If Not (rs.EOF = True And rs.bof = True) Then
Do Until rs.EOF = True
cbobanji.AddItem rs.Fields("班级编号").Value
rs.MoveNext
Loop
cbobanji.ListIndex = 0
End If
rs.Close: Set rs = Nothing
Dim rs As New ADODB.Recordset
sql = "Select * From 班级信息表 Order By ID Desc"
rs.CursorLocation = adUseClient
rs.Open sql, Conn, adOpenDynamic, adLockPessimistic
If Not (rs.EOF = True And rs.bof = True) Then
Do Until rs.EOF = True
cbobanji.AddItem rs.Fields("班级编号").Value
rs.MoveNext
Loop
cbobanji.ListIndex = 0
End If
rs.Close: Set rs = Nothing
解决方案 »
- mshflexgrid如何在某两列里的单元格里同时绑定TEXT,COMMAND,实现点选COMMAND弹出一个框点选数据填充到TEXT里面,然后TEXT里面的值赋予MSHF
- 救命啊。。。。。。(综合)
- 我送分的!:)
- 急!!!####我用的是DBASE数据库,现在有个问题,数据库很大,搜索起来特别的慢。有没有什么好的办法解决。谁解决给谁另加100分#####
- 请问用怎么样才可以实现把html等文件显示在form上面,并且保存网页上的文字???
- 水晶报表!江湖求急!!!!100分高手请进!!!
- 怎样使VB的窗体总在顶层显示!
- 一个没有特长和项目经验的程序员能找到好工作吗?我的自荐书。
- 那位能帮我将VFP程序反编译,清告诉我软件的名字.
- vb中如何实现对某一列计数,然后列出出现次数最多的项
- 如何用ado方式操作dbf文件?
- 如何把一个dbf的数据库导入access数据库中?
Dim rs As New ADODB.Recordset
sql = "Select * From 班级信息表 Order By ID Desc"
rs.CursorLocation = adUseClient
rs.Open sql, Conn, adOpenDynamic, adLockPessimistic
if rs.recordcount<>0 then
rs.movefrist
Do while not rs.eof
cbobanji.AddItem rs.Fields("班级编号").Value
rs.MoveNext
Loop
cbobanji.ListIndex = 0
End If
rs.Close: Set rs = Nothing