DataTable to Json string (using Newtonsoft. Json. dll), newtonsoft. json. dll

DataTable to Json string (using Newtonsoft. Json. dll), newtonsoft. json. dll
DataTable to Json string (using Newtonsoft. Json. dll)

When you need to convert the DataTable into a Json string, it is too troublesome to manually splice it, and it is prone to errors, which is time-consuming and laborious. Use Newtonsoft. json. dll can easily implement "a piece of code, Abel → Json ".

 

First of all, need to introduce Newtonsoft. Json. dll (need friends can click Baidu cloud link download, link: http://pan.baidu.com/s/1o8H7SJw password: 1tox)

 

String SQL = "select * from Table"; // obtain a ableabledatatable dt = DBUtility. dbHelperSQL. queryTable (SQL); string json = JsonConvert. serializeObject (dt, new DataTableConverter ());

The process is to define an SQL query statement, and then use SqlHelper (you can also write it yourself) to get a DataTable. Call Newtonsoft. Json. dll to obtain the JSON string.