APNSoft.com - Web Controls, components for ASP.NET
 About Us 

Controls Suite 4.5

Reference Book
Live Demos
Populating with Data
Row uniqueness
Alternating rows
Hovered row
CSS Formatting
Client-side selection
Server-side selection
Cell editing
Fixed (Summary) row
Appearance & Layout
Bottom Bar
Application scenarios

Alphabetic Filter:
 A  B  C  D  .....   All

APNSoft DataGrid includes the filter feature which allows users to quickly locate records they are looking for. Row filter can be applied from the server side or client side (JavaScript procedure, context menu, input box, etc.). This example demonstrates how you can filter records by using the bar for alphabetic filtering.

In conjunction with filter feature, Grid displays special button/indicator in the bottom bar. This element is useful to reflect the current filter state. It also can be used to switch ON/OFF applied row filter. For instance, when a row filter is applied, the filter indicator is marked as active. Likewise, when the filter is removed, the indicator is disabled (inactive).

You can use the following methods and properties to add/remove row filter.
  • The RowFilter is a server-side property which specifies the filter expression.
  • The dg.SetRowFilter(GridID,Filter) is a client-side method which sets the filter.
  • The dg.RemoveRowFilter(GridID) is a client-side method which removes the filter.
  • The dg.GetRowFilter(GridID) is a client-side method which returns the filter.
  • The dg.AddRowFilter(GridID,Filter) is a client-side method which adds a filter expression to the current Grid's filter expression.
Row Filter is a string expression that specifies how rows are to be filtered. For complete info about filter expressions, refer to the MSDN Library (the DataColumn.Expression property).
Below are examples of the most popular filter expressions (C#):

dg1.RowFilter = "CustomerID = 'ANTON'";
dg1.RowFilter = "CustomerID Like 'A%'";
dg1.RowFilter = "Date = #12/31/2008#";
dg1.RowFilter = "Date < #1/1/2008#";
dg1.RowFilter = "City <> 'Tokyo' AND City <> 'Paris'";
dg1.RowFilter = "Age < 16 OR Age > 65 ";

To apply a filter which is switched off by default, use the "minus" sign at the first position:

dg1.RowFilter = "-CustomerID Like 'A%'";

Code Samples:

© 2003-2024 APNSoft. All rights reserved.    Terms of use.