datagrid沒辦法實現的,要用綁定的紀錄集Rs set datagrid1.datasource=rs 查詢的條件: rs.filter="編號='" & trim(text1.text) & "' and 名稱 like '%" & trim(text2.text) & "%'" set datagrid1.datasource=rs
还是用SQL查询方便,将查询到的记录集在datagrid中显示rs.open "select * from table where 条件",cn,3,3Set dataGrid1.DataSource = RS
set datagrid1.datasource=rs
查詢的條件:
rs.filter="編號='" & trim(text1.text) & "' and 名稱 like '%" & trim(text2.text) & "%'"
set datagrid1.datasource=rs