Multi column filtering in gridview asp.net

Posted by Laghaterohan under ASP.NET on 4/26/2013 | Points: 10 | Views : 4032 | Status : [Member] | Replies : 1
Hi,
I have a gridview. I will be having a textbox above each column of this gridview. User will enter values in these columns and accordingly the data will be filtered for each column. How to achieve this functionality?

I tried using datatable plugin gridviewname.dataTable().columnFilter() however, this requires adding an additional footer to the existing table. How to do this?

Please help.

Best Regards,
Rohan Laghate



Responses

Posted by: Jitendrasoft09 on: 4/26/2013 [Member] [MVP] Starter | Points: 25

Up
0
Down
Hi,
You can achieve this using select LIKE clause from SQL Server, that code to write in c# code behind to read each character of textbox and filter according to that, please refer to the link where is used dropdownlist, change to textbox concept and go ahead.
http://www.aspdotnetcodes.com/Asp.Net_GridView_Filter.aspx

Jitendra Kumar
If my post helps you, plz mark as an answer.

Laghaterohan, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response