add dataset values back into database

[TJS]

Is there a way to do this ??

[Hermit Dave]

well do you want to put the the values back or the ones updated ?
There's a method on DataSet which is GetChanges method
MSDN: Gets a copy of the DataSet containing all changes made to it since it
was last loaded, or since AcceptChanges was called.

Once you have you just call update on your adapater and pass the dataset
MSDN Example:
[Visual Basic]
Private Sub UpdateDataSet(B yVal myDataSet As DataSet)
' Check for changes with the HasChanges method first.
If Not myDataSet.HasCh anges(DataRowSt ate.Modified) Then Exit Sub
' Create temporary DataSet variable.
Dim xDataSet As DataSet
' GetChanges for modified rows only.
xDataSet = myDataSet.GetCh anges(DataRowSt ate.Modified)
' Check the DataSet for errors.
If xDataSet.HasErr ors Then
' Insert code to resolve errors.
End If
' After fixing errors, update the data source with the DataAdapter
' used to create the DataSet.
myOleDbDataAdap ter.Update(xDat aSet)
End Sub
[C#]
private void UpdateDataSet(D ataSet myDataSet){
// Check for changes with the HasChanges method first.
if(!myDataSet.H asChanges(DataR owState.Modifie d)) return;
// Create temporary DataSet variable.
DataSet xDataSet;
// GetChanges for modified rows only.
xDataSet = myDataSet.GetCh anges(DataRowSt ate.Modified);
// Check the DataSet for errors.
if(xDataSet.Has Errors){
// Insert code to resolve errors.
}
// After fixing errors, update the data source with the DataAdapter
// used to create the DataSet.
myOleDbDataAdap ter.Update(xDat aSet);
}

Hope this helps

HD

"TJS" <no****@here.co m> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. ..

Is there a way to do this ??