Click here to Skip to main content
11,922,641 members (57,868 online)
Rate this:
Please Sign up or sign in to vote.
See more: C#2.0 C#
I have 2 datasets , i copied from 1 dataset to other using importrow and save to database.
Now the dataset from which rows are copied has rowstate as added , can i change it to unchanged , as i need to check later whether changes are saved or not based on rowstate
Posted 17-Mar-13 10:28am
Maciej Los 17-Mar-13 16:50pm
What have you done till now?
What's the problem?
And the question is...
srastogi85 17-Mar-13 18:11pm
Hi Maciej,
What i wass trying to do , have elaborated in below comment by me .

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Hey calling the AcceptChanges method on the data set will set the rowstate to unchanged.
Please see[^]
srastogi85 17-Mar-13 18:10pm
Hi Mike,
I did Accept Changes for the 1st dataset, it changes rowstate to Unchanged thats perfectly ok,
but since due to primary key connstraint i added rows from other dataset also to the dataset i saved, so for this dataset , if i will do Acceptchanges now it will give primary key constraint since rows are already there , so wanted a way to change the rowstate of this dataset to Unchanged , Please suggest
Mickt1985 17-Mar-13 18:18pm
Either way here you won't be able to insert duplicate records in you database with the same ids, can you elaborate a bit more as to what your trying to achieve and post some code so I can take a look for you?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web04 | 2.8.151125.1 | Last Updated 17 Mar 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100