How I can filter a Datatable

Question

I use a DataTable with Information about Users and I want search a user or a list of users in this DataTable  I try it butit don t work      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

User · Accepted Answer

You can use DataView   DataView dv   new DataView yourDatatable   dv RowFilter    query      query example    id   10     http   www csharp-examples net dataview-rowfilter

User · Answer

use it   CopyToDataTable    example  string  sqlWhere    quot Nachname    test  quot   string  sqlOrder    quot Nachname DESC quot    DataTable  newDataTable   yurDateTable Select  sqlWhere   sqlOrder  CopyToDataTable

User · Answer

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   gt  row Field lt String gt   Nachname      username                     amp  amp    row Field lt String gt   Ort      location             OrderByDescending row   gt  row Field lt String gt   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

User · Answer

Sometimes you actually want to return a DataTable than a DataView  So a DataView was not good in my case and I guess few others would want that too  Here is what I used to do  myDataTable select  myquery   CopyToDataTable     This will filter myDataTable which is a DataTable and return a new DataTable  Hope someone will find that is useful

User · Answer

It is better to use DataView for this task   Example of the using it you can find in this post  How to filter data in dataview

User · Answer

For anybody who work in VB NET  just in case   Dim dv As DataView   yourDatatable DefaultView  dv RowFilter   query    ex   parentid   0

User · Answer

Hi we can  use ToLower Method sometimes it is not filter   EmployeeId   Session  EmployeeID   ToString    var rows   dtCrewList AsEnumerable   Where     row   gt  row Field lt string gt   EmployeeId   ToLower     EmployeeId ToLower         if  rows Any                 tblFiltered   rows CopyToDataTable lt DataRow gt

[c#] How I can filter a Datatable?

Examples related to c#

Examples related to asp.net

Examples related to filter

Examples related to datatable

Examples related to dataset