how to convert xml string to DataTable in asp.net c#

Question

1.11/5 (2 votes)

See more:

I have an XML file. I want to convert this to a DataTable. How do I do this, please?

[edit]1) Big and useless chunk of XML file removed. 2) English improved.[/edit]

Posted 15-Mar-10 22:28pm

Ganesh_verma

Updated 9-Oct-17 2:16am

OriginalGriff

v2

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)

**R. Giskard Reventlov** · Answer 1 · 2010-03-15T22:48:00

Solution 1

You need to edit this and remove the dump of xml (presumably in the hope that someone will just write some code for you).

What have you tried? How did that work out? What problems did you encounter?

Posted 15-Mar-10 22:48pm

R. Giskard Reventlov

v2

OriginalGriff · Answer 2 · 2010-03-15T22:50:00

Solution 2

Google.
Wonderful site.
You type a question, it gives you answers.
For example, I tried "use XML with datatable c#" and the top site was titled "Loading a DataSet from XML" on MSDN! A quick look, and it tells you how to load a DataTable from an XML file! Try it - it's not difficult, all you have to do is type "www.google.com" in the address bar of your browser, and off you go. :doh:

Looking at this web page gives descriptions, instructions, and even code! Admittedly, it's in VB, but it's not exactly difficult to understand...
Look here[^].

Posted 15-Mar-10 22:50pm

OriginalGriff

Comments

Divas Gupta 9-Oct-17 7:43am

he is asking about xml string not file...

OriginalGriff 9-Oct-17 7:50am

Read the question again: "I have an XML file..."

Divas Gupta 9-Oct-17 8:09am

Sorry, I saw heading of the question.. :-(

OriginalGriff 9-Oct-17 8:19am

Do not post solutions to old questions: it looks a lot like "rep point farming" which will get you banned from this site in very short order. A seven year old question probably does not need a solution any more.
I deleted your answer to prevent the reports beginning...