How to add xml out put in Datatable

Question

0.00/5 (No votes)

See more:

ASP.NET

Dear All,

As per subject line,
I want to add my xml out put in datatable.
Please help/suggest me on this.

-
YRishi

Posted 30-Jun-11 23:29pm

yrishi

Add a Solution

Comments

Parwej Ahamad 1-Jul-11 5:47am

I think your requirement is, fetch records from the XML out put and insert into Database.
If yes then search on Google first how to read XML file then you can easily insert record into Database OR you can do directly
Edit your question OR ask to them who created this requirement document.

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)

Christian Graus · Answer 1 · 2011-06-30T23:30:00

Solution 1

What do you mean by 'add'. You wnat to use XML as a data source ? Might it not make more sense to turn your XML in to a collection of objects ? XML does not always conform to a format that's conducive to showing in a table. LINQ can turn your XML in to a collection of objects in one line of code.

Posted 30-Jun-11 23:30pm

Christian Graus

v2

Comments

yrishi 1-Jul-11 5:35am

Thanks for your reply.
I am reciving xml format output from webservice, I want to save this xml format output in datatable.

ParthaDinda · Answer 2 · 2011-06-30T23:34:00

Solution 2

It's not clear to me? I think you want this.

dt.ReadXml(MapPath("filename.xml"));

Posted 30-Jun-11 23:34pm

ParthaDinda

Updated 30-Jun-11 23:35pm

v3

Comments

yrishi 1-Jul-11 5:38am

thanks for your reply.
I am getting xml format out put from webservice. what i want to do is, I want to store this output in asp.net datatable and after that i want to store datatable into sqlserver db.
Please reply.

ParthaDinda 1-Jul-11 6:03am

Then convert your xml to stream obj .
then read it as dt.readXml(streamread);
and after that insert it to db.