What is the best way to create a search Filter for a gridview

Question

1.00/5 (2 votes)

See more:

What is the best way to create a filterable gridview with drobdown lists and searchbox :

1- Create multiple datasource and link each filter to it
2- change select statement for gridview datasource (problems in post back on row delete and inputs values)
3- suggest me any other

thanks

Posted 1-Sep-14 2:01am

Hidhoud1991

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Raul Iloc · Answer 1 · 2014-09-01T02:18:00

Solution 1

1.In my ASP.NET projects for each grid view I used the Entity Framework and Stored Procedure (shortly SP) with filter parameters, so the WHERE clause is dynamically build inside of the SP by using these filter parameters.

You could see details (and source code) about this technique in my next article Advanced ASPX GridView Pagination and Data Entities[^]

2. Other solution, without SP, could be to dynamically create LINQ query based on the filter parameters. I am using this technique in my new ASP.NET MVC projects.

Posted 1-Sep-14 2:18am

Raul Iloc

Comments

Hidhoud1991 1-Sep-14 8:21am

Ill Check it out thanks :)

Raul Iloc 3-Sep-14 2:13am

So, did you check it out?

Hidhoud1991 3-Sep-14 2:17am

it is mvc im not familiar with it ... i used the store procedure .. its doing the job .. thanks anyway

Raul Iloc 3-Sep-14 2:22am

My indicated article is not about MVC, it is classical ASP.NET web application, and I provide there also stored procedure code for filtering and pagination that could be customized/extended.