本文介绍了使用条件过滤数据集的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在使用 asp 2.0 和 c#.
I am using asp 2.0 and c#.
我有一个数据集,用于获取员工信息.现在我想根据用户在搜索文本框中输入的名称过滤网格视图.
I have a dataset, which is getting the employee info. Now I want to filter the gridview based on a name that the user has put in the search textbox.
我正在这样做:
DataSet ds = new DataSet("EmployeeInformation"); //........ loading DataSet ds with emploee info string strExpr; strExpr = "Name LIKE %" + txtSearchEmployee.Text.Trim() + "%"; ds.Tables[0].Select(strExpr);我在最后一步遇到错误,操作员丢失.
I am getting an error in the last step, that the operator is missing.
请指导我如何实现这一目标.提前致谢.
Please guide me how can I achieve this. Thanks in advance.
推荐答案您只需在 LIKE 条件周围添加单引号:
You just need to add single quotes around your LIKE criteria:
strExpr = "Name LIKE '%" + txtSearchEmployee.Text.Trim() + "%'"; ds.Tables[0].Select(strExpr);更多推荐
使用条件过滤数据集
发布评论