usingSystem;usingSystem.Collections.Generic;usingSystem.Data;usingSystem.Linq;usingSystem.Text;usingsystem.web;usingSystem.Web.Script.Serialization;/// <summary>///Summary description of JsonConvert/// </summary> Public classjsonconvert{#regionDataTable converted to JSON format/// <summary> ///DataTable converted to JSON format/// </summary> /// <param name= "DT" ></param> /// <returns></returns> Public Static stringToJson (DataTable dt) {JavaScriptSerializer Jsserializer=NewJavaScriptSerializer (); List<Dictionary<string,Object>> ParentRow =Newlist<dictionary<string,Object>>(); Dictionary<string,Object>Childrow; foreach(DataRow rowinchdt. Rows) {Childrow=Newdictionary<string,Object>(); foreach(DataColumn Colinchdt. Columns) {Childrow.add (col. ColumnName, Row[col]); } parentrow.add (Childrow); } returnjsserializer.serialize (ParentRow); } #endregionDataTable converted to JSON format#regionDataSet into JSON format/// <summary> ///DataSet into JSON format/// </summary> /// <param name= "ds" >DataSet</param> /// <returns></returns> Public Static stringToJson (DataSet ds) {StringBuilder json=NewStringBuilder (); foreach(DataTable DTinchds. Tables) {json. Append ("{\""); Json. Append (dt. TableName); Json. Append ("\":"); Json. Append (ToJson (DT)); Json. Append ("}"); } returnJSON. ToString (); } #endregion}
DataTable and DataSet Transfer JSON