Showing Additions to a DataSet
-
Hi Everyone: Is there a way I can show the records I added and/or modified to a DataSet before I commit them to the database? I think it is something like MyDataSet.GetChanges. Cleako - BTW the problem with the dataset primary ID number being off didn't seem to make a difference when I wrote the data out to the SQL Server Database using the SQLDataAdapter. Thanks, Quecumber256
-
Hi Everyone: Is there a way I can show the records I added and/or modified to a DataSet before I commit them to the database? I think it is something like MyDataSet.GetChanges. Cleako - BTW the problem with the dataset primary ID number being off didn't seem to make a difference when I wrote the data out to the SQL Server Database using the SQLDataAdapter. Thanks, Quecumber256
I found this - "Gets a copy of the DataSet that contains all changes made to it since it was loaded or since AcceptChanges was last called."[^]. So it does look like that's what happens. Im glad the update finally worked for you, I figured that it would reorder the IDs as they were REALLY added to the database.
CleaKO
"Now, a man would have opened both gates, driven through and not bothered to close either gate." - Marc Clifton (The Lounge)
-
I found this - "Gets a copy of the DataSet that contains all changes made to it since it was loaded or since AcceptChanges was last called."[^]. So it does look like that's what happens. Im glad the update finally worked for you, I figured that it would reorder the IDs as they were REALLY added to the database.
CleaKO
"Now, a man would have opened both gates, driven through and not bothered to close either gate." - Marc Clifton (The Lounge)
Thank you. I going to see if I can adapt it for my use. Quecumber256