Updating a datarow in a datset
I have an existing set of data in SQL which I am referencing as a DataSet object. I want to update some of the fields on one of the rows based on the info that is entered into a form.
I have already set up the form so that it displays the fields of the row in question in a number of text boxes. When you click a check box it allows you to ammend certain fields. This is the information that I want to send back to the database.
Should i be removing the old row and trying to insert the ammendments as new tow (with the same Id) or using a stored proc?
Any ideas welcome.