Please tell me the = best Way to read XML, and store it in datatable(C#,Asp.net).

Vikas Ahlawat

Hi i got the following XML

LCY
AMS
Sun 27Feb11
17:50

AR8
217
1:15
734185403402799
KL 2760 CITYJET
1

AMS
CDG
Sun 27Feb11
20:45
M
321
247
1:15
734185403402799
KL 2023 AIR FRANCE
:40
1

CDG
AMS
Thu 24Mar11
20:25
M
737
247
1:15
734185403402799
2

For store this in datatable i am using following strategies

//Code in sort form.....

xmldoc1.LoadXml(responseFromServer1); // I got the above XML here
XmlNodeList leg = xmldoc1.GetElementsByTagName("Leg");

for (int i = 0; i < leg.Count; i++)
{
for(...........
.................
dr1["From"] = leg[i].ChildNodes[0].InnerText.ToString(); // here i m storing the value of node in datatable
...............
...............
}

but I think it is not good code.
Can any one tell me the bast way to achieve my goal?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Choudhary15y ago
Accepted answer
Hi vikas,

Reading the XML file with FileStream is the fastest way to read any XML file. Go through below article by Mahesh:
http://www.c-sharpcorner.com/uploadfile/mahesh/readwritexmltutmellli2111282005041517am/readwritexmltutmellli21.aspx

Simplest way, You can also use DatTable1.ReadXml() to load the xml file data in Datatable directly but i'm having doubt you may need to format your XML file little more. like adding the root element and an XML tag specifying the version and all information to the XML file.

If you need to manipulate your XML then use XPath query by loading XMLDoc object which you have used.

Well go for the approach which best suited you.

Thanks.
0
div v15y ago
hi,
ref this link it helps you....
http://www.codeproject.com/KB/database/DataTableAsXMLToDataBase.aspx
0