Is there a way to refresh a table row in a dataset after its changed and saved using DDA. I don't want to reload the whole table - just refresh the record that was changed.

Majority of time the users tend to use search that produces a large number of records that I display in a grid. Database connection is Non Exclusive Read Only.

I use DDA to save changes they make to a record on separate form. 

Thanks

Sunil