Data conversion format for JSON (DataTable or DataSet)

2. <span style="FONT-SIZE:18PX;" >public class Datatableconvertjson
4. {
8. Convert #region DataTable into JSON format
10. // <summary>
12. // DataTable converted to JSON format
14. // </summary>
16. /// <param name= "DT" ></param>
18. // <returns></returns>
20. public static string Datatable2json (DataTable dt)
22. {
24. StringBuilder Jsonbuilder = new StringBuilder ();
26. Jsonbuilder.append ("{\" ");
28. Jsonbuilder.append (dt. TableName);
30. Jsonbuilder.append ("\": [");
32. Jsonbuilder.append ("[");
34. For (int i = 0; i < dt. Rows.Count; i++)
36. {
38. Jsonbuilder.append ("{");
40. For (int j = 0; j < dt. Columns.count; J + +)
42. {
44. Jsonbuilder.append ("\" ");
46. Jsonbuilder.append (dt. COLUMNS[J]. ColumnName);
48. Jsonbuilder.append ("\": \ "");
50. Jsonbuilder.append (dt. ROWS[I][J]. ToString ());
52. Jsonbuilder.append ("\", ");
54. }
56. Jsonbuilder.remove (jsonbuilder.length-1, 1);
58. Jsonbuilder.append ("},");
60. }
62. Jsonbuilder.remove (jsonbuilder.length-1, 1);
64. Jsonbuilder.append ("]");
66. Jsonbuilder.append ("}");
68. return jsonbuilder.tostring ();
70. }
74. Convert #endregion DataTable into JSON format
76. #region DataSet into JSON format
78. // <summary>
80. /// DataSet converted to JSON format
82. // </summary>
84. /// <param name= "ds" >DataSet</param>
86. // <returns></returns>
88. public static string Dataset2json (DataSet ds)
90. {
92. StringBuilder JSON = new StringBuilder ();
96. foreach (DataTable dt in ds. Tables)
98. {
100. Json.  Append ("{\" ");
102. Json. Append (dt. TableName);
104. Json.  Append ("\": ");
106. Json. Append (Datatable2json (DT));
108. Json.  Append ("}");
110. } return JSON.  ToString ();
112. }
114. #endregion
118. // <summary>
120. // MSDN
122. // </summary>
124. /// <param name= "Jsonname" ></param>
126. /// <param name= "DT" ></param>
128. // <returns></returns>
130. public static string Datatabletojson (string jsonname, DataTable dt)
132. {
134. StringBuilder Json = new StringBuilder ();
136. Json.append ("{\" "+ jsonname + " \ ": [");
138. if (dt. Rows.Count > 0)
140. {
142. For (int i = 0; i < dt. Rows.Count; i++)
144. {
146. Json.append ("{");
148. For (int j = 0; j < dt. Columns.count; J + +)
150. {
152. Json.append ("\" "+ dt. COLUMNS[J]. Columnname.tostring () + "\": \ "" + dt. ROWS[I][J].  ToString () + "\" ");
154. if (J < dt. COLUMNS.COUNT-1)
156. {
158. Json.append (",");
160. }
162. }
164. Json.append ("}");
166. if (i < dt. ROWS.COUNT-1)
168. {
170. Json.append (",");
172. }
174. }
176. }
178. Json.append ("]}");
180. return json.tostring ();
182. }
184. }</span>

Data conversion format for JSON (DataTable or DataSet)