1 public string ToJson(DataTable tbl)
2 {
3 if (tbl.Rows.Count > 0)
4 {
5 DataRowCollection rows = tbl.Rows;
6 StringBuilder sb = new StringBuilder();
7 sb.Append("[");
8 int rowcount = 0;
9 int columnCount = 0;
10 foreach (DataRow row in tbl.Rows)
11 {
12 rowcount++;
13 sb.Append("{");
14 foreach (DataColumn column in tbl.Columns)
15 {
16 columnCount++;
17 sb.AppendFormat("{0}:'{1}'{2}", column.ColumnName, row[column.ColumnName].ToString(), columnCount == tbl.Columns.Count ? "" : ",");
18 }
19 columnCount = 0;
20 sb.Append("}");
21 sb.AppendFormat("{0}", rowcount == tbl.Rows.Count ? "" : ",");
22 }
23 sb.Append("]");
24 return sb.ToString();
25 }
26 else
27 {
28 return "";
29 }
30 }