How I can filter a dataTable with Linq to datatable?

Question

hi how i can filter a datatable with linq to datatable? I have a DropDownList and there I can select the value of the Modul Column. Now I want to filter the DataTable with this Modul Column.

here is my datatable structure:

User | Host | TimeDiff | License | Telefon | Modul

Here the Code:

protected void drp_Modules_SelectedIndexChanged(object sender, EventArgs e)
{
    string value = drp_Modules.SelectedValue;

    DataTable tb = (DataTable)Session["dt_Users"];

    tb = from item in tb //?????

    LoadUsertable(tb);
}

please refer this http://msdn.microsoft.com/en-us/library/bb669073.aspx — Sain Pradeep, Oct 18 '13 at 12:18
see [this](http://stackoverflow.com/questions/10855/linq-query-on-a-datatable) for query DataTable with Linq — Jens Kloster, Oct 18 '13 at 12:22

score 50 · Accepted Answer · answered Oct 18 '13 at 12:31

50

You are better of using DataTable.Select method, but if you have to use LINQ then you can try:

DataTable selectedTable = tb.AsEnumerable()
                            .Where(r => r.Field<string>("Modul") == value)
                            .CopyToDataTable();

This would create a new DataTable based on filtered values.

If you use DataTable.Select

string expression = "Modul =" + value;
DataRow[] selectedRows = tb.Select(expression);

answered Oct 18 '13 at 12:31

Habib

219,104
29
407
436

1

I know I'm a little late to the party for this one, but thanks, that helped quite a bit with something I'm working on. – user2366842 Jun 20 '14 at 19:09
1

@Habib, Just a simple comment. THANKS!!! I was breaking my head trying to cast the Rows, etc, etc, etc, when I found your answer. – Ramon Araujo Oct 15 '14 at 07:06
http://stackoverflow.com/questions/35507109/how-to-filter-on-multiple-columns-using-linq I have multiple columns or single column. How can I do either? Thanks. – Si8 Feb 19 '16 at 14:03

score 2 · Answer 2 · edited Feb 24 '20 at 14:55

2

You can use condition to check rows exist in addition before casting. System.Linq namespace is required for Any() to work

var rows = values.AsEnumerable().Where
            (row => row.Field<string>("Status") == action);//get the rows where the status is equal to action

if(rows.Any())
{
    DataTable dt = rows.CopyToDataTable<DataRow>();//Copying the rows into the DataTable as DataRow
}

edited Feb 24 '20 at 14:55

Maghalakshmi Saravana

757
8
9

answered Jun 14 '17 at 08:16

Nayas Subramanian

2,269
21
28

score 1 · Answer 3 · answered Jan 23 '20 at 12:28

To Retrieve the DataTable based on filtering the list of item.(i.e.,if any of the list item is present in datatable, that matched result will received.

 List<string>item=new List<string>(){"TG1","TG2"};     
 DataTable tbsplit = (from a in tbl.AsEnumerable()
              where item.Any(x => a.Field<string>("CSubset").ToUpper().Contains(x.ToUpper()))
              select a).CopyToDataTable();//By Executing this, the Filter DataTable is obtained

How I can filter a dataTable with Linq to datatable?

3 Answers3

Linked