怎样将数据库中1列值读入combox中 怎样将数据库中1列值读入combox中?请问 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 '对Access数据库'引用ADO(Microsoft ActiveX Data Objects 2.X Library)Private Sub Command1_Click() On Error GoTo err Dim cn As New ADODB.Connection, rs '有密码的连接方式 'cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Test.mdb;Jet OLEDB:DataBase password=12345;" '无密码的连接方式 cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Test.mdb;Persist Security Info=False" cn.Open rs.CursorLocation=adUseClient'设置客户端游标 rs.Open "select * from 表1", cn, 3, 2 whlie not rs.eof Combo1.AddItem rs.Fields("你需要的列名").value rs.MoveNext wend Exit Suberr: MsgBox err.DescriptionEnd Sub 对SQL Server数据库'引用ADO(Microsoft ActiveX Data Objects 2.X Library)Private Sub Command1_Click() On Error GoTo err Dim cn As New ADODB.Connection, rs '有密码的连接: 'cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=登陆用户名;Password=登录密码;Initial Catalog=数据库名;Data Source=yourSERVICE" '无密码的连接: cn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=数据库名;Data Source=服务器别名" cn.Open rs.CursorLocation=adUseClient'设置客户端游标 rs.Open "select * from 表1", cn, 3, 2 whlie not rs.eof Combo1.AddItem rs.Fields("你需要的列名").value rs.MoveNext wend Exit Suberr: MsgBox err.DescriptionEnd Sub ACCESS数据库,sql语句查询出结果有问题 关于这个函数俺有好多疑问,请高手指点! 想问我通过 VB 该怎么在数据库中的表 插入、删除 数据 帮忙解决一个API小问题 关于MouseLeave 字符如何转换成数字 求救高手!!我快疯了!!winsock连接错误!!!谁能帮我! 请问vb里怎么实现文件打开对话框 好心人大神指导 有谁知道MDI窗口菜单一级菜单、二级菜单的判别方法? 谁可以解决以下问题!对于你来说小菜一碟。。。。 谁有Com+方面的笔试题? datagrid回车转行
'引用ADO(Microsoft ActiveX Data Objects 2.X Library)
Private Sub Command1_Click()
On Error GoTo err
Dim cn As New ADODB.Connection, rs
'有密码的连接方式
'cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Test.mdb;Jet OLEDB:DataBase password=12345;"
'无密码的连接方式
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Test.mdb;Persist Security Info=False"
cn.Open
rs.CursorLocation=adUseClient'设置客户端游标
rs.Open "select * from 表1", cn, 3, 2
whlie not rs.eof
Combo1.AddItem rs.Fields("你需要的列名").value
rs.MoveNext
wend
Exit Sub
err:
MsgBox err.Description
End Sub
'引用ADO(Microsoft ActiveX Data Objects 2.X Library)
Private Sub Command1_Click()
On Error GoTo err
Dim cn As New ADODB.Connection, rs
'有密码的连接:
'cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=登陆用户名;Password=登录密码;Initial Catalog=数据库名;Data Source=yourSERVICE"
'无密码的连接:
cn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=数据库名;Data Source=服务器别名"
cn.Open
rs.CursorLocation=adUseClient'设置客户端游标
rs.Open "select * from 表1", cn, 3, 2
whlie not rs.eof
Combo1.AddItem rs.Fields("你需要的列名").value
rs.MoveNext
wend
Exit Sub
err:
MsgBox err.Description
End Sub