<Root> (Root node) <Record> (Secondary node) <Name> A </Name> (Child node1) <Age> 21 </Age> (Child node2) </Record> <Record> <Name> b </Name> <Age> 22 </Age> </Record> </Root>
How to meet the task? Thanks.
How to get data from XML and send it into table
Want to get values Coming in XML format using stored procedure. The
values i am getting are like in the format as mentioned below . What i
am trying to do is to just create a table in database as 'RecordsDB' and
using Stored procedure parsing the XML, inserts the value in 'Records'.
I am trying to search question like this on stack overflow and net but
not getting answer ,only knows the mini way is to read the node value
like line.column.value(something). But i do have some thousands of
records coming from ASP.NET web service.*
Iftikar HussainPosted Aug 27, 2013, 2:54 AM
Regards,
Iftikar
rachit sharmaPosted Aug 27, 2013, 2:51 AM
Iftikar HussainPosted Aug 26, 2013, 11:50 PM
As per my understanding you want to read the xml value in your ASP.NET application and insert into database.
Please refer the below link
http://www.aspdotnet-suresh.com/2012/12/aspnet-send-xml-file-as-parameter-to.html
http://www.aspdotnet-suresh.com/2012/12/c-insertupload-xml-file-data-into-sql.html
Regards,
Iftikar