how to read xml nested node from xml to sql database

Question

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.

Ananth G · Answer

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

Mayank · Answer

http://stackoverflow.com/questions/4815836/how-do-you-read-xml-column-in-sql-server-2008 If this resolve your issue then mark as answer.