前面load和yx_click,都是对的,运行commok_clock()就报对象名无效“xjjbxx”可xjjbxx是表名啊,和前面的连接一模一样,why!! Dim adoconn As ADODB.Connection
Dim adors As ADODB.Recordset
Dim adors1 As ADODB.Recordset
Dim adors2 As ADODB.Recordset
Dim adors3 As ADODB.Recordset
Dim adors4 As ADODB.Recordset
Dim adors5 As ADODB.Recordset
Private Sub CommOK_Click()
Set adoconn = New ADODB.Connection
Set adors = New ADODB.Recordset
sConnectionString = "provider=sqloledb;data source=210.45.240.136;initial catalog=stuinfosys;uid=sa;pwd=8172045"
adoconn.Open sConnectionString
adors.Open "select * from xjjbxx ", adoconn, adOpenDynamic, adLockOptimistic, adcmdTabe
End SubPrivate Sub Form_Load()
Set adoconn = New ADODB.Connection
Set adors1 = New ADODB.Recordset
Set adors2 = New ADODB.Recordset
Set adors3 = New ADODB.Recordset
sConnectionString = "Provider=MSDASQL.1;Password=8172045;Persist Security Info=True;User ID=sa;Data Source=jxgl;Mode=Read"
adoconn.Open sConnectionString
adors1.Open "select * from dm_mz", adoconn, adOpenDynamic, adLockOptimistic, adcmdTabe
While Not adors1.EOF
mz.AddItem adors1!mc
adors1.MoveNext
Wend
adors2.Open "select * from dm_jg", adoconn, adOpenDynamic, adLockOptimistic, adcmdTabe
While Not adors2.EOF
jg.AddItem adors2!mc
adors2.MoveNext
Wend
adors3.Open "select * from dm_yx", adoconn, adOpenDynamic, adLockOptimistic, adcmdTabe
While Not adors3.EOF
yx.AddItem adors3!yxmc
adors3.MoveNext
Wend
End SubPrivate Sub yx_click()
zy.Clear
Set adoconn = New ADODB.Connection
Set adors4 = New ADODB.Recordset
sConnectionString = "Provider=MSDASQL.1;Password=8172045;Persist Security Info=True;User ID=sa;Data Source=jxgl;Mode=Read"
adoconn.Open sConnectionString
adors4.Open "select * From dm_zy where left(zydm,2) in (select yxdm from dm_yx where yxmc='" & yx.Text & "')", adoconn, adOpenDynamic, adLockOptimistic, adcmdTabe
While Not adors4.EOF
zy.AddItem adors4!zymc
adors4.MoveNext
Wend
End Sub
Dim adors As ADODB.Recordset
Dim adors1 As ADODB.Recordset
Dim adors2 As ADODB.Recordset
Dim adors3 As ADODB.Recordset
Dim adors4 As ADODB.Recordset
Dim adors5 As ADODB.Recordset
Private Sub CommOK_Click()
Set adoconn = New ADODB.Connection
Set adors = New ADODB.Recordset
sConnectionString = "provider=sqloledb;data source=210.45.240.136;initial catalog=stuinfosys;uid=sa;pwd=8172045"
adoconn.Open sConnectionString
adors.Open "select * from xjjbxx ", adoconn, adOpenDynamic, adLockOptimistic, adcmdTabe
End SubPrivate Sub Form_Load()
Set adoconn = New ADODB.Connection
Set adors1 = New ADODB.Recordset
Set adors2 = New ADODB.Recordset
Set adors3 = New ADODB.Recordset
sConnectionString = "Provider=MSDASQL.1;Password=8172045;Persist Security Info=True;User ID=sa;Data Source=jxgl;Mode=Read"
adoconn.Open sConnectionString
adors1.Open "select * from dm_mz", adoconn, adOpenDynamic, adLockOptimistic, adcmdTabe
While Not adors1.EOF
mz.AddItem adors1!mc
adors1.MoveNext
Wend
adors2.Open "select * from dm_jg", adoconn, adOpenDynamic, adLockOptimistic, adcmdTabe
While Not adors2.EOF
jg.AddItem adors2!mc
adors2.MoveNext
Wend
adors3.Open "select * from dm_yx", adoconn, adOpenDynamic, adLockOptimistic, adcmdTabe
While Not adors3.EOF
yx.AddItem adors3!yxmc
adors3.MoveNext
Wend
End SubPrivate Sub yx_click()
zy.Clear
Set adoconn = New ADODB.Connection
Set adors4 = New ADODB.Recordset
sConnectionString = "Provider=MSDASQL.1;Password=8172045;Persist Security Info=True;User ID=sa;Data Source=jxgl;Mode=Read"
adoconn.Open sConnectionString
adors4.Open "select * From dm_zy where left(zydm,2) in (select yxdm from dm_yx where yxmc='" & yx.Text & "')", adoconn, adOpenDynamic, adLockOptimistic, adcmdTabe
While Not adors4.EOF
zy.AddItem adors4!zymc
adors4.MoveNext
Wend
End Sub
解决方案 »
- VB中如何控制excel单元格中某个字体上下标
- 最近要开发一个小型的考试系统,有问题请教
- 我的程序的启动窗体不清楚,怎么办呢?
- 请问如何连接局域网内服务器上的Access数据库?
- 如何做选项菜单?
- 请问如何让TEXTBOX在失去焦点时内容时不为空?怎样给您分?在线等候!
- 菜鸟请教大家一个问题;addoc的翻页和查询还有添加的功能该怎么实现啊
- 關于一個Textbox的事件問題
- 这样的连接字符串可以吗?
- vb用shell执行外部命令行的问题!!!!希望得到帮助!
- 有关输入的问题,在线等待
- 我想在一个picturebox中拖动另一个picturebox,当松开鼠标时被拖动的pic会定位在鼠标的当前位置,给个例子代码好吗
这个地方路径是不是有问题,你断点查询试验一下!
你的表在这个库吗?