Datagridview databinding/refresh

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two questions.

1. Is there a way to keep the datagridview datasource constantly bound to a
sql db? So that as soon as a change takes place in the db by any user, it is
updated on all screens. If so, how is that done? If not, what is the best
practice to perform this type of function?

2. In refrence to above, I have a timer that refreshes the data every 3
minutes. One problem here is the screen flickers when it refreshes. How
would i resolve this? And, if a user is scrolled to the bottom of the
datagridview, when the data refreshes in the grid, the scrollbar
automatically goes back to the top. How would i prevent this from happening
so the user stays on the record they're viewing.
 
i have the same question with you .i find use DataGrid control when
timer refreshed, the scrollbar not automatically goes back to the top.
you can test it.
 
I would prefer to use the datagridview. I realize #1 would create a large
amount of overhead and is not feasible, but my problem with the scrollbar and
screen flicker still exists.
 
Back
Top