Quick way to Filter data in GridView in ASP.NET SQL Server DB

hi, how do can search data type integer in gridview?

LOVED IT!! This was what I wanted to add to my form. Your directions were very clear and it worked perfect! Not too complicated for a newbie like me. Thanks!

Hi ,I used your code and it was very helpful,but when I type a name in text box for example "Anna" I encounter the error missing the the operand after 'Anna' . What can I do to fix the problem?

Hi ,I used your code and it was very helpful,but when I type a name in text box for example "Anna" I encounter the error missing the the operand after 'Anna' . What can I do to fix the problem?

i am waiting bro just tell me , i am stuck

bro just tell what should i do for Int , i will do it , just give me the ides

bro can you please show me how to do it for Int.

please give me solution , i would be very help full for me , i am new i serching every thing on net i have to get experience ,,.. and also if my grid view is connected in inner join will it work same as its working with one table??? can you please show me how can i filter Int or numeric in my grid view...

@abdul: in this example i've all fiend in varchar type. you need to go for some workaround.

I have used your code it is awesome but its showing some problem for filtering numeric , when i filter the data its showing certain error , -->>Exception Details: System.Data.EvaluateException: Cannot perform 'Like' operation on System.Int32 and System.String. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. can you please show me the solution .. please

Good for filtering data in GridView.

Hi!! Abhimanyu great work !!!!

Hi, abhimanyu have a great article really , I also trying to do this with XML database