.acceptchanges and updating to a database

[Niels Jensen]

I have a some code which imports information from a text file to a dataset.
Depending op what is being extracted from the text file, the dataset has 5
tables which can be written to. During this accessing I have to delete some
records depending on certain criteria. I initially had some errors because I
wasn't accepting the changes made to the dataset. So using .acceptchanges
fixed the issue. however later on in the program a user may choose "update
changes to database" from the menu, this will only update any changes made to
the dataset after the last .acceptchanges command was issued.

Is there a way of updating the contents of the entire dataset to a database
instead of simply the changes made since the .acceptchanges command was
issued?

Cheers
Niels

[Cor Ligthert]

Niels,

The problem is that the rowstate of your row should be added to get what I
understand that you want.

http://msdn.microsoft.com/library/de...classtopic.asp

However AFAIK is the rowstate is readonly, which would mean that you should
in my opinion copy all tables and than really as new added rows.

I know that there are some problems which can be resolved with acceptchanges
while those problems should not exist.

Can you tell what that problem was?

Cor

"Niels Jensen" <Ni*********@discussions.microsoft.com>

I have a some code which imports information from a text file to a dataset.
Depending op what is being extracted from the text file, the dataset has 5
tables which can be written to. During this accessing I have to delete
some
records depending on certain criteria. I initially had some errors
because I
wasn't accepting the changes made to the dataset. So using .acceptchanges
fixed the issue. however later on in the program a user may choose "update
changes to database" from the menu, this will only update any changes made
to
the dataset after the last .acceptchanges command was issued.

Is there a way of updating the contents of the entire dataset to a
database
instead of simply the changes made since the .acceptchanges command was
issued?

Cheers
Niels

[Niels Jensen]

Hmmm,

Sorry about the lack of responce - I found a way to sort out my problem by
seperating the tables being modified into their own Dataset. This stopped
the error being flagged.

Niels

"Cor Ligthert" wrote:

Niels,

The problem is that the rowstate of your row should be added to get what I
understand that you want.

http://msdn.microsoft.com/library/de...classtopic.asp

However AFAIK is the rowstate is readonly, which would mean that you should
in my opinion copy all tables and than really as new added rows.

I know that there are some problems which can be resolved with acceptchanges
while those problems should not exist.

Can you tell what that problem was?

Cor

"Niels Jensen" <Ni*********@discussions.microsoft.com>

I have a some code which imports information from a text file to a dataset.
Depending op what is being extracted from the text file, the dataset has 5
tables which can be written to. During this accessing I have to delete
some
records depending on certain criteria. I initially had some errors
because I
wasn't accepting the changes made to the dataset. So using .acceptchanges
fixed the issue. however later on in the program a user may choose "update
changes to database" from the menu, this will only update any changes made
to
the dataset after the last .acceptchanges command was issued.

Is there a way of updating the contents of the entire dataset to a
database
instead of simply the changes made since the .acceptchanges command was
issued?

Cheers
Niels