temp.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=data.mdb;Jet OLEDB:Database Password=19791002;Persist Security Info=False"
If temp Is Nothing ThenIf temp.Recordset.RecordCount = 0 Then
Exit Sub
End If
temp.Recordset.MoveFirst
Do While temp.Recordset.EOF = False
Combo1.AddItem temp.Recordset.Fields(0)
temp.Recordset.MoveNext
Loop
If temp Is Nothing ThenIf temp.Recordset.RecordCount = 0 Then
Exit Sub
End If
temp.Recordset.MoveFirst
Do While temp.Recordset.EOF = False
Combo1.AddItem temp.Recordset.Fields(0)
temp.Recordset.MoveNext
Loop
解决方案 »
- 各位大哥大姐帮帮我,求一个复杂的SQL语句!我只有20分,全部奉上,高手们就当我做好事吧!!!!
- 郁闷,散分。。。。。。。。。。。。。。。。。。
- 请问谁有发送邮件的控件
- 请问,如何用VB存储ORACLE数据库的BLOB字段,高手求教!!
- VB新手求助!~ 如何获得指定路径下的文件夹名和文件名?谢谢~
- treeview控件操作出现错误:run-time error '35605,This item's control has been deleted,为什么?---在线等待
- MSGBOX的输入信息框显示乱码
- 一个VB操作的小问题,请帮忙
- vb2005打印超级困难呀!
- 向用VB吃饭的专家请教!
- 连接远程数据库的问题
- 开机自启动代码,有点小问题。
Data Source="& app.path & "\data.mdb
If temp.Recordset.RecordCount = 0 Then
Exit Sub
End If
temp.Recordset.MoveFirst
Do While temp.Recordset.EOF = False
Combo1.AddItem temp.Recordset.Fields(0)
temp.Recordset.MoveNext
Loop
End If结帖率:0.00%
给人印象不好,得到答案的要结贴
dim temp as new connectiontemp.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=data.mdb;Jet OLEDB:Database Password=19791002;Persist Security Info=False"
If temp Is Nothing Then If temp.Recordset.RecordCount = 0 Then
Exit Sub
End If
temp.Recordset.MoveFirst
Do While temp.Recordset.EOF = False
Combo1.AddItem temp.Recordset.Fields(0)
temp.Recordset.MoveNext
Loop
Exit Sub
End If
temp.Recordset.MoveFirst
Do While temp.Recordset.EOF = False
Combo1.AddItem temp.Recordset.Fields(0)
temp.Recordset.MoveNext
Loop帮帮忙啊,我以前忘了给分,以为注册就行了
temp.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\data.mdb;Jet OLEDB:Database Password=19791002;Persist Security Info=False" If temp.Recordset.RecordCount = 0 Then
Exit Sub
End If
temp.Recordset.MoveFirst
Do While temp.Recordset.EOF = False
Combo1.AddItem temp.Recordset.Fields(0)
temp.Recordset.MoveNext
Loop
这句没有If temp Is Nothing Then
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
cn.CursorLocation = adUseClient
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\My Documents\date.mdb;Persist Security Info=False"
cn.Open
rs.Open "select * from t2", cn, adOpenStatic, adLockOptimistic
Combo1.Clear
Combo1.AddItem ""
If rs.RecordCount > 0 Then
While Not rs.EOF
Combo1.AddItem rs.Fields(1)
rs.MoveNext
Wend
End If
rs.Close
cn.Close
Set rs = Nothing
Set cn = Nothing
End Sub
temp.RecordSource = "select * from temp"
temp.Refresh
With temp.Recordset
.AddNew
.Fields(0) = Combo1.Text .Update
End WithEnd SubPrivate Sub Form_Load()temp.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\data.mdb;Jet OLEDB:Database Password=19791002;Persist Security Info=False"If temp Is Nothing Then
If temp.Recordset.RecordCount = 0 Then
Exit Sub
End If
temp.Recordset.MoveFirst
Do While temp.Recordset.EOF = False
Combo1.AddItem temp.Recordset.Fields(0)
temp.Recordset.MoveNext
Loop
End IfEnd Sub