2
Vote

Sorting & Search Problem

description

Cannot Sort Columns
Cannot Do Multiple String Search Matching
 
Example : Column 1 Matches + Column 2 Matches
 
  • Searching on column 1 with Department
  • Searching on column 2 with Location
     
    When searching the LIKE Clause it will be Department AND Location when it matches.
    Whereas searching the LIKE Clause it could be Department OR Location when there are matches.
     
    Original:
    dtSearch.DefaultView.RowFilter = String.Join(" AND ", lstWhereClause.ToArray());
     
    Proposed Change:
    dtSearch.DefaultView.RowFilter = String.Join(" OR ", lstWhereClause.ToArray());

comments