How I can filter a Datatable by name?

Question

I have a DataTable with information about users and I want to search for a user or a list of users in this DataTable.

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

Answer 1

You can use DataView.

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

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