用Rowfilter加入过滤条件
eg:
string sql = "select Name,Age,Sex from UserInfo";
DataTable dt = DataAccess.GetDataTable(sql);//外部方法(通过一条查询语句返回一个DataTable)
dt.DefaultView.RowFilter = "Sex=女";
dt.DefaultView.RowFilter = "Age>18";
dt.DefaultView.RowFilter = "Name like '%张%'";
不过RowFilter不支持不等于(<>、!=、not like),不过如果只是单纯的对确定的字符串操作,可以用in和not in,数据库查询语句则不行。
eg:
dt.DefaultView.RowFilter = "Name in ('zhang')";
dt.DefaultView.RowFilter = "Name not in ('zhang')";
dt.DefaultView.RowFilter = "Name in (select Name from StudentInfo)"; //错误