DataRow State Property Change in C#

Question

0.00/5 (No votes)

See more:

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 9:28am

srastogi85

Add a Solution

Comments

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

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

frostcox · Answer 1 · 2013-03-17T10:56:00

Solution 1

Hey calling the AcceptChanges method on the data set will set the rowstate to unchanged.
Please see http://msdn.microsoft.com/en-us/library/system.data.dataset.acceptchanges.aspx[^]

Posted 17-Mar-13 10:56am

frostcox

Comments

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

frostcox 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?