How to make changes of clone dataset into database ?

Question

Hi,

We are developing Windows application in .NET 3.0 .

We have one MDI form in which we are showing data from database into ComponentOne's TrueDB grid and on row double click of this grid we are showing a modal window in which only selected row data will be displayed in the form format into ComponentOne's TrueDB grid.

So to display only one selected row data in the grid of modal window we have created a clone of MDI window dataset and used this clone into modal window. Also we have created a datarow object for selected row of MDI form grid and it is imported in the clone dataset.

So our modal window grid shows only one selected record and now we want to add the data editing functionality in this window so that user can add new record, update existing row and undo changes.

To add new record we are adding the new datarow in the clone dataset but now our modal window grid showing 2 records i.e. selected row of MDI form and newly added empty row. Now we want that the grid should show only newly added empty row when user tries to add new record. Please let us know how we will have to manage this ?

Also as we are making changes in the clone dataset so how it will be saved in the database ?

Please advise us in this.

Thanks and Regards
Prasad.G.Godbole