How do I combine results from both JSON and XML files in a unified output in ASP.NET web service.</pre>

See more:

ASP.NET

XML

C#3.5

JSON

webservice

I am having an XML file which contains details Library and books and a JSON file which also contains details Library and books as well, but with a different structure and we need a web service which manipulates the two different files and returns a unified output as XML to a front-end MVC app that displays returned results in a grid (each row represent a hotel with child rows that represent rooms) with a filtration facility. Combine results from both JSON and XML files in a unified output.

What I have tried:

[WebMethod]
public DataSet XmlReadHotel()
{
XmlTextReader xrdr = new XmlTextReader(Server.MapPath("Xml Hotels Result.xml"));

DataSet ds = new DataSet();

ds.ReadXml(xrdr);

return ds;
}