OK....I have this application that uses a bound Table. Four users are local and two2 users are at a remote site connected via a T1 connection.
I was asked to add an "autorefresh' option...which is supposed to reload a datagridview that is using the tableadapter as the datasource every 1 minute. I complete and deploy this.
My boss sees a spike in network traffic between us and the remote site and asks me if it could be related to this change. For the refresh, I am using:
Just wondering if there is a better way to do this...The "autorefresh" really only needs to add to the datagridview any new records and remove any closed records, which happen on other screens. It isn't doing any true update from the datagridview itself.
Any suggestions???
=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)
Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB.NET Programmer
I was asked to add an "autorefresh' option...which is supposed to reload a datagridview that is using the tableadapter as the datasource every 1 minute. I complete and deploy this.
My boss sees a spike in network traffic between us and the remote site and asks me if it could be related to this change. For the refresh, I am using:
Code:
Me.VCustomerPaymentExceptionsTableAdapter.Fill(Me.DsSchenckDW.vCustomerPaymentExceptions)Just wondering if there is a better way to do this...The "autorefresh" really only needs to add to the datagridview any new records and remove any closed records, which happen on other screens. It isn't doing any true update from the datagridview itself.
Any suggestions???
=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)
Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB.NET Programmer
