Loading

generate nested xml form Country and corresponding states and download

Somen Natta

Contry and state table in sql server has foreign key relationship. How to generate and download country and coresponding states in nested xml format?

2 Replies

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

Rijwan Ansari5y ago
Hi,

You can get solution from these links:
https://www.codeproject.com/Questions/1213892/How-to-convert-list-to-XML-string-and-XML-to-list
https://www.c-sharpcorner.com/article/convert-generic-list-into-xml-in-Asp-Net-mvc/
Mohsin Azam5y ago
Get Data from both table by countryId.if you are using Entity framework you can use Include() and it will get all states ,id using stored procedure you can add join b/w 2 table.
After getting the record ,you can use Linq to XML where you can create your own XML Formatted Data.
plz refer : https://docs.microsoft.com/en-us/dotnet/standard/linq/linq-xml-overview