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
[解决办法]