Big question!!!Who can help me!

Question

As we know the DataSet is working with disconnected Data. Once we fetch the results of a query into a DataSet using a DataAdatper object. there is no longer a connection between DataSet and Database. If other user modify data in database that corresponds to the data in DataSet , we will not see those charges in our DataSet.

But in a Bussiness windows Application System. it need to responds any changes.

For example, if Sales department Manager queries the data from Databas and fills it into DataSet. Maybe there are 10 records in DataSet, But at the same time the Sales department Sales cancel a customer orders , how colud the Manager know the change ? Because the DataSet is disconnected, he will never know the changes except he close the Application and re-open it.

Is it right?If it is right, it will make a big trouble.