我怎么能过滤一个DataTable？ [英] How I can filter a Datatable?

问题描述

我使用一个DataTable与有关用户的信息，我想搜索的用户或用户在此数据表中的列表。我尝试butit不工作:(

下面是我的C＃code：

 公开数据表GetEntriesBySearch（用户名字符串，字符串位置，DataTable的表）
        {
            名单= NULL;
            名单=表;            字符串前pression;
            字符串中将sortOrder;            前pression =Nachname ='测试';
            中将sortOrder =nachname DESC;            的DataRow []行数= list.Select（如pression，中将sortOrder）;            名单= NULL; //测试
            名单=新的DataTable（）; //测试            的foreach（行的DataRow行）
            {
                list.ImportRow（行）;
            }            返回列表;
        }
 

解决方案

您可以使用数据视图。结果

  DataView的DV =新的数据视图（yourDatatable）;
dv.RowFilter =查询; //查询示例=ID = 10
 

结果
<一href=\"http://www.csharp-examples.net/dataview-rowfilter/\">http://www.csharp-examples.net/dataview-rowfilter/

I use a DataTable with Information about Users and I want search a user or a list of users in this DataTable. I try it butit don't work :(

Here is my c# code:

 public DataTable GetEntriesBySearch(string username,string location,DataTable table)
        {
            list = null;
            list = table;

            string expression;
            string sortOrder;

            expression = "Nachname = 'test'";
            sortOrder = "nachname DESC";

            DataRow[] rows =  list.Select(expression, sortOrder);

            list = null; // for testing
            list = new DataTable(); // for testing

            foreach (DataRow row in rows)
            {
                list.ImportRow(row);
            }

            return list; 
        }

解决方案

You can use DataView.

DataView dv = new DataView(yourDatatable);
dv.RowFilter = "query"; // query example = "id = 10"

http://www.csharp-examples.net/dataview-rowfilter/

这篇关于我怎么能过滤一个DataTable？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！