How to convert a XMl File to DataTable using C# without saving XML file into local drive

Question

0.00/5 (No votes)

See more:

Hi all,

Is there any way to read the XML file into datatable which is creating in runtime ,without saving xml file into local drive?

See Here also[^]

Posted 14-Jun-12 23:10pm

P_A_1

Add a Solution

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)

Manas Bhardwaj · Accepted Answer · 2012-06-14T23:18:00

Solution 1

C#

DataSet ds = new DataSet(); 
ds.ReadXml(new XmlTextReader(new StringReader(xml)));

DataTable books = ds.Tables[0];

OR

C#

XmlDocument xdoc = MethodReturnsXmlDocument();

DataSet ds = new DataSet()
ds.ReadXml(new XmlNodeReader(xdoc));

Posted 14-Jun-12 23:18pm

Manas Bhardwaj

Updated 15-Jun-12 0:11am

v3

Comments

P_A_1 15-Jun-12 5:38am

Hi i saw ur code and doc.Load is nothing but, opening the saved file in the drive....
I mean it is simply opening it but what i need is i will create the xml file from database with the help of web service and i need to read it without saving it any where....

I hope u understand it....

Manas Bhardwaj 15-Jun-12 5:43am

You are correct. I missed the file thingy.
Improved my solution. Pleasee see if it helps.

P_A_1 15-Jun-12 5:58am

Hai , here u wrote like this "new StringReader(xml)"...

What Do u mean by this...

Should i need to convert the my xmldocument to any stringreader type???

I hope u understand it....

Manas Bhardwaj 15-Jun-12 6:12am

I thought you have xml in string format. And you can always get the string xml out of xmldocument with document.OuterXml method.
Anyways, modified my solution to load xml document in dataset.

P_A_1 15-Jun-12 6:16am

Hai...
Thanks for reply and ur second solution is much better than first one and first one solved my task and

a heartfull thanks to u for saving my most valuable time bye... ;)

VJ Reddy 15-Jun-12 6:18am

Good answer. 5!

Manas Bhardwaj 15-Jun-12 6:24am

thnx!