我已经在ado控件属性里设置了指向的access数据库及其中的一个表,单我想在程序中根据条件选择其他的表,用一个datagrid控件显示,怎样写代码!
Dim cnstr As String, sqlstr As String
cnstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\SpectrumData.mdb;Mode=Share Deny None;Persist Security Info=False"
Adodc1.ConnectionString = cnstr
Adodc1.CommandType = adCmdTable
sqlstr = "select * from 重车高速二维应力谱"
Adodc1.RecordSource = sqlstr
Adodc1.Refresh
Set dagyinglipu.DataSource = Adodc1
dagyinglipu.Refresh
Dim cnstr As String, sqlstr As String
cnstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\SpectrumData.mdb;Mode=Share Deny None;Persist Security Info=False"
Adodc1.ConnectionString = cnstr
Adodc1.CommandType = adCmdTable
sqlstr = "select * from 重车高速二维应力谱"
Adodc1.RecordSource = sqlstr
Adodc1.Refresh
Set dagyinglipu.DataSource = Adodc1
dagyinglipu.Refresh
TempTableName="asasds" '根据条件选择其他的表名
sqlstr = "select * from " & TempTableName
Adodc1.RecordSource = sqlstr
Adodc1.Refresh你上面已经指定了查询类型:
Adodc1.CommandType = adCmdTable
只要给出表名然后刷新Adodc1即可。
是不是因为我已经在adodc1控件中设置了connetionstring和recordsource
的原因?
用代码设置了设置了connetionstring和recordsource试一试啊
加上这一句 Adodc1.CommandType = adCmdUnknown
就可以了.