UPDATE/DELETE/INSERT in dataset

Question

1.60/5 (2 votes)

See more:

Hello all,
I have one dataset which populating from xml file and has below stucture.

{Id},{Name},{Amount}

I want to
1) Update name and amount in this dataset for particular id
2) Delete record which has particular id from dataset
3) Insert new record in dataset if particular id is not present in dataset.

Please let me know the code.

Posted 6-May-13 1:37am

RDBurmon

Add a Solution

2 solutions

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)

**Joezer BH** · Accepted Answer · 2013-05-06T01:43:00

Solution 1

That shouldn't be a problem, see Updating Existing Records in a Dataset[^]

Cheers,
Edo

Posted 6-May-13 1:43am

Joezer BH

Raja Soosai · Accepted Answer · 2013-05-06T01:46:00

Solution 2

Use .select method in datatable. The parater for this method is a string. You can specify the filter condition here. The filtered records will be come as Data Row collection. From that collection you can update any record. if no records for your criteria u can directly add that row into the datatable.

Posted 6-May-13 1:46am

Raja Soosai

Comments

RDBurmon 6-May-13 8:19am

Thank you. I understood first part.
Could you please explain me below statement using code ?
"From that collection you can update any record. if no records for your criteria u can directly add that row into the datatable."

Raja Soosai 7-May-13 5:32am

For updating existing row:

modify the filtered row collection by looping each row and each column.

Add a new row:

If no record found for your critetia then as per requirement, you can create a new row and add it into the same data table.