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. 4 2591
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
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" <ha********@hotmail.com> wrote in message
news:%2******************@TK2MSFTNGP14.phx.gbl... 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.
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]" <no************@planet.nl> wrote in message
news:e3**************@TK2MSFTNGP15.phx.gbl... 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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Mark |
last post by:
I have a working PHP/MySQL application used for data entry. The data
entry screen includes a "Save" button. The PHP code for this button
looks like this:
if (isset($_POST))
{
if ($_POST ==...
|
by: Scott |
last post by:
I have a clickable graph that resides on page 1. If user clicks a data point
on the graph, the page runs again yeilding a 2nd graph that shows a more
detailed graph.
Problem is, I have a...
|
by: Andrew Chanter |
last post by:
I have a situation where I am using an unbound dialog form to update data in
an Access 2002 split back end / front end scenario. The data update is done
via an ADO call (direct to the back end...
|
by: tasmisr |
last post by:
This is an old problem,, but I never had it so bad like this before,,
the events are refiring when clicking the Browser refresh button.
In the Submit button in my webform, I capture the server side...
|
by: Jim Little |
last post by:
Hello,
I'm driving myself crazy either because I'm missing something about ASP.NET,
or what I'm trying to do simply can't be done.
First, I am not using session variables to track state. My...
|
by: Antoine |
last post by:
What is considered best when doing an application that allows you to browse
data eg by month?
I've currently got an app working so it does a complete refresh when you
change the month you are...
|
by: Robert |
last post by:
I am trying to give the user dynamic search capabilities to select
almost any record in the database from criteria they select. Everything
seems to work except when I open the display form to...
|
by: martin1 |
last post by:
All,
is there window form refresh property? I try to set up window form refresh
per minute. Thanks
|
by: phforum |
last post by:
Hi,
I wrote a PHP page for user input the information to search the
database. And the database data will update every second. I want to
set the auto refresh to get the data from database every...
|
by: =?Utf-8?B?TWFyaw==?= |
last post by:
Hi -
I'm having trouble refreshing a datagrid control bound to a dataset that was
created from the New Data Source wizard. What is the code required to
refresh the datagrid with data from the...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |