Loading

how to read xml nested node from xml to sql database

Uday Bhan Singh

9y917.NET

Sir/Maim i have a long xml file in which 3000 sub node and chile node of sub node also.

node have many attribute like name section id so on.

please help me sir/main who know how to do this.

2 Replies

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

Mayank9y ago
http://stackoverflow.com/questions/4815836/how-do-you-read-xml-column-in-sql-server-2008

If this resolve your issue then mark as answer.
0
Ananth G9y ago
Read xml file by using this code
string filePath = "D:\\Self Practice\\Sol1\\Sol1\\Information.xml";
DataSet ds = new DataSet();
ds.ReadXml(filePath);
that dataset have mutiple table based on ur xml node .
then insert data to db
0