Refresh Data

[Hardik Shah]

Hi,

I have a combobox for city name help , which uses dataset as datasource ,
when other user from network add any other city or edit city, it is not
reflect in my current form (in run mode) , as ado.net is disconnected data.
How can I refresh my data. Any hints please.

Thanks in advance.

Hardik Shah.

 

[Cor Ligthert [MVP]]

Hardik,

The first question you have to ask yourself with disconnected data is.

How important is it that the current users see the changed made by others.

(And that can be important, don't misunderstand this).

Think by that about the time element, by instance if somebody is starting to
drink his/her coffee, that can give a complete other situation than that he
did not. (Just as sample those samples are endless).

Does protect that in a pessimistic way (pessimistic concurrency), that it
cannot happen in advance, is needed. Are you sure that cannot be used, that
if there are changes made, that the data is not accepted, however that is
told to the user the current state of the data and to do his changes again
or any other method to correct it (optimistic concurrency).

The last method of optimistic concurrency will work with a pda and the
internet as well. Creating pessimistic concurrency on the first device is
impossible while on Interenet I never saw it done.

Pessimistic concurrency is costly to build and cost a lot of resources (the
reason that Microsoft is stopped with ADO).

I hope that this gives some idea's?

Cor

 

[Pieter]

Apparently with SQL Server 2005 you can throw events or something like that
from your sql server to your application in case something changed...

 

[Hardik Shah]

Hi,

Thanks for your reply, I have Same question related to this topic , I added
contextmenu in the combobox to add new city from there. I can successfully
add new city. But combo box data is not updated (Combobox's dataset and new
form dataset' s are diffrent). Is there any method that can refresh my
combobox data after adding new city.

Hardik Shah.

 

[Cor Ligthert [MVP]]

Hardik,

Or you have to use the same dataset/datatable/dataview (the combobox does
not accept a dataset) or you have to refresh (fill again) that table.

Cor