GridView Ajax Filter

Upon users’ requests to enhance the GridView Ajax Filter control, I made some changes to the control to allow more flexibility and functionality to it. I will discuss all the features of the control and how to use it on your project. P.S. I am using Visual Studio 2010 for the current demo.
Features:
1. More operations have been added “=, LIKE, NOT LIKE, <>, >, <, >=, <=”:

2. Search for multiple keyword in the same filter by adding a semicolon after each keyword:

3. Updating the filter (Column , Operation, or Keyword) without removing it:

4. Adding multiple filter with AND / OR operation between them:

5. Adding dynamic date values to the keyword:
“For this example I am selecting all the products that have been created 8 months from today’s date using this value { t - m(8) }”. t: today, m:month

6. The filter for each page will be stored throughout your session, so you don’t have to re-create the filter if you visited another page then came back to the filtered page again.
How to Use:
- Create a new ASP.NET Empty Web Application and name it DataFilterDemo

- Drag and drop the following files from DataFilter folder to your project “DataFilter.ascx, DataFilter.ascx.cs, and Filter.cs” (Can be found in the attached file below)

- Right-click on your project and click on Convert to Web Application

-Right-Click on your project and click on Add -> New Item… -> Web Form then name it “Default.aspx”

- From Solution Explorer drag DataFilter.ascx control to the design view of Default.aspx Page.

- Add Script Manager and Update Panel to the page.

- Add new GridView inside the Update Panel “UpdatePanel1” to the page and just keep the name as “GridView1” for demonstration proposes.

- Expand GridView Properties and add new Sql Data Source


- Choose your database connection and configure the SELECT data for your GridView





- If you want, change columns’ names to whatever names you like.
- Right click on the page and click View Code

- Inside Page_Load function, add the following code:

- Add a new Event Handler function to handle the call back from the control:

- Done, press F5 to debug and run your application
Please note the following:
- Date format must be as dd/MM/yyyy to be able to filter the column or you can change that by re-write the part of Filter.cs that handles the date format.
- To Implement Sorting and Paging when the filter is applied call the Event Handler “DataFilter1_OnDataBound()” on the following Events of GridView “Sorted” and “PageIndexChanged”


Source Code & Demo