Multi column filtering in gridview

Posted by Laghaterohan under ASP.NET on 4/26/2013 | Points: 10 | Views : 4514 | Status : [Member] | Replies : 1
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


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

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.

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