Datagridview databinding/refresh

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.

flybet
Fri Oct 20 22:46:03 CDT 2006

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.
mkd1919 wrote:
> 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.

mkd1919
Mon Oct 23 11:54:01 CDT 2006

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.

"flybet" wrote:

> 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.
> mkd1919 wrote:
> > 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.
>
>