In a DataRow object we have the methods Delete and Remove.
The Delete method marks the row for deletion by changing the RowState property to Delete and hidding the row.
My question is about the Remove method.
It says that it completely revomes the row from the DataRowCollection, but what happens with that row when we save the changes in the dataset to the database?
In understand perfectly what happens when we use the Delete method, but the Remove method is not clear to me.
Also, if we use the Delete method, the row will be hidden and changed to Delete state. How can I undo this operation and bring the row back to its original state?