如何过滤数据表? [英] How I can filter a Datatable?

问题描述

我使用带有用户信息的数据表，我想在此数据表中搜索用户或用户列表.我试过了，但它不起作用:(

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 :(

这是我的 C# 代码:

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; 
        }

推荐答案

您可以使用 DataView.

You can use DataView.

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

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

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