读书人

vb6.0中ADO怎么进行多条数据同时查询

发布时间: 2012-01-13 22:43:30 作者: rapoo

vb6.0中ADO如何进行多条数据同时查询?
代码如下:

ljm1 = Tex20 & "\" & Tex21 & "\" & Tex22 & Ch1.Caption
ljm2 = Tex20 & "\" & Tex21 & "\" & Tex22 & Ch2.Caption

Adodc1.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=db_cfg"
Adodc1.RecordSource = "YLRGXX where 连接码 ='" & ljm1 & "'"
Adodc1.RecordSource = "YLRGXX where 连接码 ='" & ljm2 & "'"
Adodc1.Refresh
Set DataGrid1.DataSource = Adodc1

请问各位老师如何实现这个功能!

[解决办法]
Adodc1.RecordSource = "YLRGXX where 连接码 ='" & ljm1 & "'" & "or 连接码 = " & ljm2
[解决办法]

探讨
Adodc1.RecordSource = "YLRGXX where 连接码 ='" & ljm1 & "'"  & "or 连接码 = " & ljm2

读书人网 >VB

热点推荐