使用条件过滤数据集 [英] Filtering dataset with condition

问题描述

我正在使用 asp.net 2.0 和 c#.

I am using asp.net 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);

这篇关于使用条件过滤数据集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！