raise event from a sql database?
I have an MDI parent form and 2 child forms. Each child form has data bound controls bound to the same sql table; one from is for displaying data and the other is for editing data. After the editing form closes, I need to update the data in the display form (if it is displayed). I can think of a few ways to do this, but I would like the display form to simply respond to an event raised by the database. Is it possible to create (and raise) an event in the database proper? If not what is the best/acceptable way to update data on a data bound form?
thanks
kevin
Re: raise event from a sql database?
You're doing it the wrong way around. The correct way would be for the editing form to update the data in the display form and then the display form should update the database. If you must update the database from the editing form then at least use the same data source, so any changes you make automatically update the display form. Going the long way around doesn't make sense. Why should the database have to notify an application of a change that the application itself made? Such database notifications should only be used when absolutely necessary, which would only ever be between clients.