RowFilter 模糊查询出现：Like 运算符中出错: 字符串模式“2#%门%”无效。

Question

dv = dt.DefaultView;
sWhere += string.Format(" AND ( companyUseRange LIKE '{0}%' or GroupUseRange LIKE '%{0}%')", "2#"+par["GroupUseRangeOther"]);
dv.RowFilter = sWhere;

Answer 1

查找内容中的%字符需要转义："2#"+par["GroupUseRangeOther"].Replace("%","[%]")