/// <summary> ///DataTable converted to JSON format/// </summary> /// <param name= "DT" ></param> /// <returns></returns> Public Static stringToJson (DataTable dt) {StringBuilder Jsonbuilder=NewStringBuilder (); Jsonbuilder.append ("{\""); Jsonbuilder.append (dt. Tablename.tostring ()); Jsonbuilder.append ("\":["); for(inti =0; i < dt. Rows.Count; i++) {jsonbuilder.append ("{"); for(intj =0; J < dt. Columns.count; J + +) {jsonbuilder.append ("\""); Jsonbuilder.append (dt. COLUMNS[J]. ColumnName); Jsonbuilder.append ("\":\""); Jsonbuilder.append (dt. ROWS[I][J]. ToString ()); Jsonbuilder.append ("\","); } jsonbuilder.remove (Jsonbuilder.length-1,1); Jsonbuilder.append ("},"); } jsonbuilder.remove (Jsonbuilder.length-1,1); Jsonbuilder.append ("]"); Jsonbuilder.append ("}"); returnjsonbuilder.tostring (); } /// <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 (); }
. NET DataTable DataSet transcoding JSON code