Question

vb sql+adodc+datagrid 查询结果显示

myrs.Open "select * from 职员基本信息 where 职员编码 = '" & Trim(DataCombo1.Text) & "'", Cnn, adOpenKeyset, adLockOptimistic
DataGrid1.Refresh
Set DataGrid1.DataSource = myrs
myrs.Close
为什么得不到查询后的结果 却显示还是
myrs.Open "select * from 职员基本信息 where 职员编码 = '" & Trim(DataCombo1.Text) & "'", Cnn, adOpenKeyset, adLockOptimistic
DataGrid1.Refresh
Set DataGrid1.DataSource = myrs
myrs.Close
为什么得不到查询后的结果 却显示还是整张表的信息 没有筛选~~

Answer 1

myrs.Open "select * from 职员基本信息 where 职员编码 = '" & Trim(DataCombo1.Text) & "'", Cnn, adOpenKeyset, adLockOptimistic

Set DataGrid1.DataSource = myrs
DataGrid1.Refresh
myrs.Close