How I can filter a Datatable? How I can filter a Datatable? asp.net asp.net

How I can filter a Datatable?


c# asp.net filter datatable dataset

You can use DataView.

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


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

c# asp.net filter datatable dataset

If you're using at least .NET 3.5, i would suggest to use Linq-To-DataTable instead since it's much more readable and powerful:

DataTable tblFiltered = table.AsEnumerable()          .Where(row => row.Field<String>("Nachname") == username                   &&   row.Field<String>("Ort") == location)          .OrderByDescending(row => row.Field<String>("Nachname"))          .CopyToDataTable();

Above code is just an example, actually you have many more methods available.

Remember to add using System.Linq; and for the AsEnumerable extension method a reference to the System.Data.DataSetExtensions dll (How).

c# asp.net filter datatable dataset

use it:

.CopyToDataTable()

example:

string _sqlWhere = "Nachname = 'test'";string _sqlOrder = "Nachname DESC";DataTable _newDataTable = yurDateTable.Select(_sqlWhere, _sqlOrder).CopyToDataTable();

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last