Retrieve data from Sql server data table column to xml file

Question

Hello C# Corner I want to retrieve data from sql server data table column consisting inserted JSON strings [ {Subscriptions:{UsersDetails:{SubscriptionsScope:{ImportTenant:https://Bondariprojectonline.sharepoint.com ImportEnvironment:https://Bondariprojectonline.sharepoint.com ExportTenant:https://Bondariprojectonline.sharepoint.com/sites/pwa ExportEnvironment:https://Bondariprojectonline.sharepoint.com}}}} ] in the column and load into XML file in C# Window application. Possible someone to help with explanation or Code  Thanks

Manas Mohapatra · Answer

Find below steps: Add JSON.NET library from Nuget package manager and add namespace in your code file. Then add following code: string json = @ [{ Subscriptions :{ UsersDetails :{ SubscriptionsScope :{ ImportTenant : https: //Bondariprojectonline.sharepoint.com ImportEnvironment : https://Bondariprojectonline.sharepoint.com  ExportTenant : https://Bondariprojectonline.sharepoint.com/sites/pwa  ExportEnvironment : https://Bondariprojectonline.sharepoint.com }}}}]; XmlDocument doc = (XmlDocument)JsonConvert.DeserializeXmlNode(json); doc.Save( your path );