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
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 //?????
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
string expression = "Modul =" + value; DataRow selectedRows = tb.Select(expression);