Hi Guyz,
I am having a question about a data bound combo box on a winform. There is a set of applications comprising of:
- A client side application for users distributed geographically accessing a SQL Server database
- An admin application that accesses the database and can manipulate the database
- A web service that connects the client application to the database
The client application has dataset objects that hold the data pulled out from the database on startup. This is done to minimize the database calls.
Now the scenario is, there is a winform in the client application which has a combo box populating the ids for that particular transaction. At a time only one transaction is active; the rest are either closed, to be started in future,or cancelled.
The admin who uses another application, has a direct access to the database and can control the transaction status. If the transaction does not result in a success, it has to be cancelled by the admin, in which case, it is simply made unavailable for any further deals.
Now my requirement is to remove the cancelled transaction from the data bound combo box, in the client application's winform, when it is removed from the data source table/view. Currently, if the form is reopened, then the data source is reloaded and everything just works fine. However, which event should be handled to make it work with out refreshing the entire form or the panel or anything else but the combo box? The cancelled transaction should simply go from the list. Is there any elegant way to do this? Let me know...and thanks for reading through
Bhushan