Adding a new record to the dataset.
Posted on 2004-10-08
Hi, this probably sound like a silly Question....So should be some easy point.
I want to Add a new record to a dataSet, I know how to add a new record to the dataset. My problem is setting the form controls up to accept the new data.
Currently I have a form with a combobox and two text boxes.
They are all bound to the same dataset. Dataset1.
I have a add button that will clear the text boxes and allow the user to enter data form the new record. This is where the problem starts, I only clear the textboxes for the user, the binding architeture recognises it as a changed dataset record. I have a button that will save the values in the text boxes as a new row in the dataset. This work good. accpet the current record in the dataset is effected.
My problem occurred when i tried to cancel the add action, the cleared forms stay and the dataset through they were changes to the current record.
How do i prevent the dataset from accepting the change made.
How do I prepare the form to accpet new values with out effecting the bound dataset.