Update / Refresh Data

  • Thread starter Thread starter chrisd
  • Start date Start date
C

chrisd

Dear all,

i wrote an application (scheduler / timeline ) like outlook calendar.
This app is bound to a sql database . Everything works fine, add,
update , etc.

Now, my problem is that from now on more than one guy will use this
software simultaniously. So, i need to

a) determine if there a changes inside the database which i have to
reload on all other clients

and/or

b) a refresh button, which refetch all NEW data , possibly leaving the
clients data (which are not updated so far) unchanged.

Ist there anybody with an idea ??

Greetings
Chris
 
Use the Refresh... Before you call your update, check if your
dataSet.HasChanges and if so, call the update before requerying the db.
This way you will submit your changes always before you refresh things...

When ADO.NET 2.0 comes out, there's a notification feature, but right now,
short of using Notification services, there's no way to do this.

How are you handling concurrency btw?
chrisd said:
Dear all,

i wrote an application (scheduler / timeline ) like outlook calendar.
This app is bound to a sql database . Everything works fine, add,
update , etc.

Now, my problem is that from now on more than one guy will use this
software simultaniously. So, i need to

a) determine if there a changes inside the database which i have to
reload on all other clients

and/or

b) a refresh button, which refetch all NEW data , possibly leaving the
clients data (which are not updated so far) unchanged.

Ist there anybody with an idea ??

Greetings
Chris
Click to expand...
 
Thanks for your quick answer,

but i think there´s a misunderstanding.

Imagine a system like MS outlook.My cursor is in a calendar sheet from
today.
Now, somebody else types in an appointment. What i want to have then,
is either kind of automat. refresh of the data , so i will see the
change on my sheet. Problem :

When i use refresh (eg. every 10 sec) or on button press, dataset will
loose the actual position (goes to the first record) and systems
slows down.
Is there any poss. to refresh just the changed data or hold the
position and

2.) how am i able to refresh without loosing my changes ??

By the way, i see the concurrency just when i update (error message)

Hope to get an answer soon.

Thanks in advance
Chris
 
Back
Top