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 msdn.microsoft.com/en-us/library/bb669073.aspx — Sain Pradeep
– Sain Pradeep, Commented Oct 18, 2013 at 12:18

Habib · Accepted Answer · 2013-10-18 12:31:11Z

52

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, 2013 at 12:31

Habib

224k30 gold badges420 silver badges446 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user2366842 Over a year ago

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.

Ramon Araujo Over a year ago

@Habib, Just a simple comment. THANKS!!! I was breaking my head trying to cast the Rows, etc, etc, etc, when I found your answer.

Si8 Over a year ago

stackoverflow.com/questions/35507109/… I have multiple columns or single column. How can I do either? Thanks.

Maghalakshmi Saravana · Accepted Answer · 2020-02-24 14:55:03Z

3

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, 2020 at 14:55

Maghalakshmi Saravana

82110 silver badges10 bronze badges

answered Jun 14, 2017 at 8:16

Nayas Subramanian

2,38723 silver badges32 bronze badges

Comments

Maghalakshmi Saravana · Accepted Answer · 2020-01-23 12:28:53Z

1

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

answered Jan 23, 2020 at 12:28

Maghalakshmi Saravana

82110 silver badges10 bronze badges

Collectives™ on Stack Overflow

How I can filter a dataTable with Linq to datatable?

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related