Merge DataTable

[Kit Fisto]

Hi all. I have a problem and i can't seem to solve it. I have a DataTable with all the Data a need. From time to time i need to make a call to the DataBase to refresh the DataTable. I need to add/update/remove the rows from the DataTable comparing them to the rows that came from the DataBase. How can i do that? I can add the new rows, but if some rows where deleted/updated in the DataBase how can i delete/update them from my DataTable?

[snorkie]

How about just clearing the DataTable and re-grabbing the data from the database. since you're bring all the data down anyway, it would probably save some CPU time as well. Hogan

[Kit Fisto]

Thats right. But theres only one problem. If the user has scroll down the Grid and i clear the DataTable and refill-it then scroll will go to the first item in the list. Is there a way of avoinding that? Thanks for your reply.