例: 科目:combo1 <----选择科目,使下面combo组可见,并且下拉菜单显示其中的应有的章节
章节
选择题:combo2 <----选择板块,如:1,2,3
单选题:combo2 <----选择板块,如:1,2,3
多选题:combo2 <----选择板块,如:1,2,3
阅读题:combo2 <----选择板块,如:1,2,3
综合题:combo2 <----选择板块,如:1,2,3
数据库:
表1
科目名称表2 科目名称 题型 章节
问题是怎么让combo2组显示相应的章节?请各位大大帮帮忙!!
章节
选择题:combo2 <----选择板块,如:1,2,3
单选题:combo2 <----选择板块,如:1,2,3
多选题:combo2 <----选择板块,如:1,2,3
阅读题:combo2 <----选择板块,如:1,2,3
综合题:combo2 <----选择板块,如:1,2,3
数据库:
表1
科目名称表2 科目名称 题型 章节
问题是怎么让combo2组显示相应的章节?请各位大大帮帮忙!!
解决方案 »
- 读文本调用函数,求大师
- 如何实现窗体用久在前
- 如何查询并修改表的约束关系(用语句)?
- ■■如何获取系统的鼠标单击事件
- 送分:只要大家到http://www.xbitsoft.net发帖提问,站长会想办法帮你搞定你的问题!
- 紧急求助,水晶报表打包运行问题,在线等~~
- 如何实现控制其它程序的菜单操作?
- ~~~~~~~~~~~~~~Set DataGrid1.DataSource = rst 怎么DATAGRID显示不出数据,但Set MSHFlexGrid1.DataSource = rst,MSHFlexGrid1就显示得
- 怎樣在VB中調用DOS函數
- 如果获得DLL中包含的函数???
- vb中Forms
- VSFLEXgrid 退出编辑状态
MsgBox Combo1.Text
End SubPrivate Sub Combo2_DropDown()
Combo2.Clear
If Combo1.Text = "222" Then
Combo2.AddItem "ttttt"
Combo2.AddItem "gggg"
Else
Combo2.AddItem "2222"
Combo2.AddItem "5555"
End If
End SubPrivate Sub Form_Load()
Combo1.AddItem "5555"
Combo1.AddItem "222"
End Sub
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Combo1.AddItem ""
cn.CursorLocation = adUseClient
cn.Open ""
rs.Open "select 科目名称 ,题型 ,章节 from 表2", cn, adOpenStatic, adLockOptimistic
If rs.RecordCount > 0 Then
While Not rs.EOF
For i = 0 To UBound(Combo2)
If Combo2(i).Tag = rs.Fields(1) Then
Combo2(i).AddItem rs.Fields(2)
End If
Next i
rs.MoveNext
Wend
End If
rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing
End SubPrivate Sub Form_Load()
Dim i As Integer
For i = 0 To UBound(Combo2)
Combo2(i).Visible = False
Next i
Combo2().Tag = "选择题"
Combo2().Tag = "单选题"
Combo2().Tag = "多选题"
Combo2().Tag = "阅读题"
Combo2().Tag = "综合题"
End SubPrivate Sub s_FillCombo1()
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Combo1.AddItem ""
cn.CursorLocation = adUseClient
cn.Open ""
rs.Open "select 科目名称 from 表1", cn, adOpenStatic, adLockOptimistic
If rs.RecordCount > 0 Then
While Not rs.EOF
Combo1.AddItem rs.Fields(0)
rs.MoveNext
Wend
End If
rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing
End Sub
Private Sub Combo1_Click()
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Combo1.AddItem ""
cn.CursorLocation = adUseClient
cn.Open ""
rs.Open "select 科目名称 ,题型 ,章节 from 表2", cn, adOpenStatic, adLockOptimistic
If rs.RecordCount > 0 Then
While Not rs.EOF
For i = 0 To UBound(Combo2)
If Combo2(i).Tag = rs.Fields(1) Then
Combo2(i).AddItem rs.Fields(2)
End If
Next i
rs.MoveNext
Wend
End If
rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing
End SubPrivate Sub Form_Load()
Dim i As Integer
Call s_FillCombo1
For i = 0 To UBound(Combo2)
Combo2(i).Visible = False
Next i
Combo2(0).Tag = "选择题"
Combo2(1).Tag = "单选题"
Combo2(2).Tag = "多选题"
Combo2(3).Tag = "阅读题"
Combo2(4).Tag = "综合题"
End SubPrivate Sub s_FillCombo1()
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Combo1.AddItem ""
cn.CursorLocation = adUseClient
cn.Open ""
rs.Open "select 科目名称 from 表1", cn, adOpenStatic, adLockOptimistic
If rs.RecordCount > 0 Then
While Not rs.EOF
Combo1.AddItem rs.Fields(0)
rs.MoveNext
Wend
End If
rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing
End Sub
Private Sub Combo1_Click()
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim i As Integer
Combo1.AddItem ""
cn.CursorLocation = adUseClient
cn.Open ""
rs.Open "select 科目名称 ,题型 ,章节 from 表2", cn, adOpenStatic, adLockOptimistic
If rs.RecordCount > 0 Then
While Not rs.EOF
For i = 0 To UBound(Combo2)
If Combo2(i).Tag = rs.Fields(1) Then
Combo2(i).AddItem rs.Fields(2)
End If
Next i
rs.MoveNext
Wend
End If
rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing
For i = 0 To UBound(Combo2)
Combo2(i).Visible = True
Next i
End SubPrivate Sub Form_Load()
Dim i As Integer
Call s_FillCombo1
For i = 0 To UBound(Combo2)
Combo2(i).Visible = False
Next i
Combo2(0).Tag = "选择题"
Combo2(1).Tag = "单选题"
Combo2(2).Tag = "多选题"
Combo2(3).Tag = "阅读题"
Combo2(4).Tag = "综合题"
End SubPrivate Sub s_FillCombo1()
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Combo1.AddItem ""
cn.CursorLocation = adUseClient
cn.Open ""
rs.Open "select 科目名称 from 表1", cn, adOpenStatic, adLockOptimistic
If rs.RecordCount > 0 Then
While Not rs.EOF
Combo1.AddItem rs.Fields(0)
rs.MoveNext
Wend
End If
rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing
End Sub