I have added a search function to my grid, essentially a stored procedure to refine the grid display for a term entered by the user that occurs in any of 2 columns.
This works fine initially, but isnt maintained for any actions such as paging, edit or cancel, the grid then returns to the initial default databinding of all records.
I added a Clear button to allow the user to load all records again, but would like to be able to make any search done persist and only show these records until the user clicks clear or page reloads.