The following code will not update the original database table from which the data-adapter loaded -
DataRow row = myDT.NewRow( );
row[0] = 25;
row[1] =DateTime.Parse( "25/09/2008" );
row[2] ="This is the first line";
myDT.Rows.Add( row );
myDT.AcceptChanges( );
daSQL.Update( myDS.Tables[0] );
The problem lies in the second but last line which you migh be tempted to code to confirm the changes you have inserted.
However, this will prevent the subsequent line from posting any changes to the originating database table.
Hope this prevents you having the hassle I had until I found this little gem - I should have paid more attention to the 'Update' help entry..!