How to save Multiple dataset to a xml file

Question

2.00/5 (1 vote)

See more:

Hi
How to save multiple dataset to a single xml.
when i try the below code its overwriting and i am getting only one dataset value

StreamWriter xmldoc = new StreamWriter(HttpContext.Current.Server.MapPath("123.xml"), false);
           ds.WriteXml(xmldoc);
           ds1.WriteXml(xmldoc);

Thanks

Posted 3-Feb-12 21:20pm

Lancy.net

Add a Solution

Comments

Sergey Alexandrovich Kryukov 4-Feb-12 3:29am

Looks like a bad idea. Your code won't give you well-formed XML.
--SA

Lancy.net 4-Feb-12 3:38am

hi i need your valuable suggestion how do i do this please?

3 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)

Wendelius · Answer 1 · 2012-02-03T21:28:00

Solution 1

If you're using WriteXml method the latter write operation overwrites the contents of previously created file.

Before writing the dataset to the file, could you merge the datasets and write the merged dataset. See: DataSet.Merge[^]

Posted 3-Feb-12 21:28pm

Wendelius

Comments

Lancy.net 4-Feb-12 3:37am

Thanks Mika let me try....

Sergey Alexandrovich Kryukov · Answer 2 · 2012-02-03T21:37:00

Not that it is impossible; rather, the question is not fully specified. The method you try to use will create some text which is never represents a well-formed XML, just because concatenation of two XMLs is not a well-formed XML.

You need some "outside" XML schema which would provide a container for two or more different XMLs each corresponding to the portion of two or more unrelated data sets (if they are related, you data model is wrong in first place). This schema is something arbitrary. You don't specify how do you want to store more then one data sets in your XML container, so it can be done in many similar ways.

Most likely, the whole idea is wrong. If you need two data sets in one XMLs, why are two different data sets? They should be one united data set. If this simple principle is not in line with your data model, it means your data model is wrong in first place. Try to prove me wrong though…

—SA

AdnanSafdar · Answer 3 · 2012-06-26T07:03:00

Solution 3

for this purpose you must write an alogrithm for generating xml document dynamically... see how to write xml formate form dataset and make it in loop

Posted 26-Jun-12 7:03am

AdnanSafdar

Comments

Tim Corey 26-Jun-12 13:08pm

Your answer does not really add to the solution and it comes four months after the question was asked.

How to save Multiple dataset to a xml file

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us