i have a DataGridView in vb.net that's bound to a SQL server table. The table is being updated by another program.
i use a timer that fills the table adapter and merge that data into the existing dataset, but this action has a bunch of UI repercussions.
How can i make sure this update affects the user as little as possible?
Mostly i'm wondering how to maintain the user's selection and the area of the datagridview that's being displayed. Also i have comboboxes in the datagridview that the user gets kicked out of on the refresh. Is there a way around that too?