Hi all, coding c# in vs.net 2003.
I have the return dataset of a stored procedure bound to a datagrid with one of the fields being status. The displayed records are filtered using a combo box so that all the records of one status are displayed. The user has the ability to change the status of a single record and I'm wondering how I can update the datagrid to reflect this change. Is there a clean way of removing a single record?
For example, if the filter is set to "Good" status then all records displayed have a status of "Good". If the user changed the status of a record to "Bad" I'd like to remove that record since it no longer matches the filter. I know that I could just call my stored procedure again and rebind the datagrid but I don't want my grid to be refreshed. Let's say the user has scrolled down three pages and changes the status of a record, a refresh would repopulate and lose their selection/sorting.