Instead of XML,I want to insert data using JSON to SQL Table

Beavon Oigazy

10y795.NET

Hello ,

Please, can someone able to explain for me how i will do this in json

T07E3DD0-31C7-1722-Y0EC-322F5BDE4AB8

Professional

2016-01-22

2017-01-22

https://bondariprojectonline.sharepoint.com

https://Bondariprojectonline.sharepoint.com

https://Bondariprojectonline.sharepoint.com/sites/pwa

https://Bondariprojectonline.sharepoint.com

Thanks,

Beavon

2 Replies

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

Manas Mohapatra10y ago
Accepted answer
If this helps you please accept the answer..
Manas Mohapatra10y ago
Try with below code:
Before start coding, you need to add/download JSON.NET library from Nuget package.
string xmlData = @"

01
T07E3DD0-31C7-1722-Y0EC-322F5BDE4AB8
Professional
2016-01-22
2017-01-22

https://bondariprojectonline.sharepoint.com
https://Bondariprojectonline.sharepoint.com
https://Bondariprojectonline.sharepoint.com/sites/pwa
https://Bondariprojectonline.sharepoint.com


";

XmlDocument doc = new XmlDocument();
doc.LoadXml(xmlData);
string jsonText = JsonConvert.SerializeXmlNode(doc);