Filtering of gridview

Question

Dear experts
I am taking data in gridview from database now how can i get filtered result as soon as user enters some text in textbox
means if user enters A all rows from gridview starting from A should only be visible

Prabhakar Parihar · Answer

Hi Mayur .. i think u try this way to your query . with textbox text select * from Firm where name like 'A%'

Mayur Gujrathi · Answer

Thanks I got it now if i am getting data in dataset from sql query can i operate on dataset without considering database

piyush sardhara · Answer

hi?? you can use this query on your textbox filter select * from Firm where name like 'A%'

kritika · Answer

hi is the textbox part of your gridview?... if not then you can fire the like query on textbox's change event..