怎样在datatable上实现条件是子查询的过程,代码如下,请大家帮帮忙,在线等等
dataview = new DataView(dt1);
dt1 = new DataTable();
dataview.RowFilter = "器名ID in (select 器名ID from tblzhulu where 章節 like'%" + RichSelect.Text + "%' and 著录ID in (select ID from 金文著录书目 where 書名 ='" + combsdzlsm.Text + "' order by ID ))";
dataview.RowFilter的条件无法这样用,你们说我该怎样查询呢