多字段查询问题,
我在程序中有个combo和text
combo中为字段,text为关键字。查询代码如下:
Private Sub Command1_Click()
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "select 学号,姓名 from student_table where 学号=" & "'" & Text1.Text & "'"
Set DataGrid1.DataSource = Adodc1
Adodc1.Refresh
DataGrid1.Refresh
End Sub
Private Sub Form_Load()
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\学生管理系统\db1.mdb;Persist Security Info=False"
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "select * from student_table"
Adodc1.Refresh
DataGrid1.Refresh
Combo1.AddItem "学号"
Combo1.AddItem "姓名"
End Sub
问题是。怎么把“学号”字段换成combo中的字段实现查询。代码就在我的程序上改就可以了,会的帮个忙。谢谢了