DataTable 的 JSON 序列化

在JS中我们需要对对象进行JSON序列化通常使用JSON.net, 不过它对DataTable的序列化不能很好的满足的我们的需求，后来在CodeProject发现一个兄弟已经写好了 Convert ASP.NET DataTable to JSON, to use datatable in JAVASCRIPT ，记一下，免得忘记了。 public string JsonToDataTable(DataTable dt) { /**************************************************************************** * Without goingin to the depth of the functioning of this Method, i will try to give an overview * As soon as this method gets a DataTable it starts to convert it into JSON String, * it takes each row and ineach row it creates an array of cells and in each cell is having its data * on the client side it is very usefull for direct binding of object to TABLE. * Values Can be Access on clien in this way. OBJ.TABLE[0].ROW[0].CELL[0].DATA * NOTE: One negative point. by this method user will not be able to call any cell by its name. * *************************************************************************/ StringBuilder JsonString = new StringBuilder(); JsonString.Append("{ "); JsonString.Append("/"TABLE/":[{ "); JsonString.Append("/"ROW/":[ "); for (int i = 0; i < dt.Rows.Count; i++) { JsonString.Append("{ "); JsonString.Append("/"COL/":[ "); for (int j = 0; j < dt.Columns.Count; j++) { if (j < dt.Columns.Count - 1) { JsonString.Append("{" + "/"DATA/":/"" + dt.Rows[i][j].ToString() + "/"},"); } else if (j == dt.Columns.Count - 1) { JsonString.Append("{" + "/"DATA/":/"" + dt.Rows[i][j].ToString() + "/"}"); } } /*end Of String*/ if (i == dt.Rows.Count - 1) { JsonString.Append("]} "); } else { JsonString.Append("]}, "); } } JsonString.Append("]}]}"); return JsonString.ToString(); } public string DataTableToJson(DataTable dt) { /***************************************************************************** * Without goingin to the depth of the functioning of this Method, i will try to give an overview * As soon as this method gets a DataTable it starts to convert it into JSON String, * it takes each row and in each row it grabs the cell name and its data. * This kind of JSON is very usefull when developer have to have Column name of the . * Values Can be Access on clien in this way. OBJ.HEAD[0]. * NOTE: One negative point. by this method user will not be able to call any cell by its index. * *************************************************************************/ StringBuilder JsonString = new StringBuilder(); //Exception Handling if (dt != null && dt.Rows.Count > 0) { JsonString.Append("{ "); JsonString.Append("/"Head/":[ "); for (int i = 0; i < dt.Rows.Count; i++) { JsonString.Append("{ "); for (int j = 0; j < dt.Columns.Count; j++) { if (j < dt.Columns.Count - 1) { JsonString.Append("/"" + dt.Columns[j].ColumnName.ToString() + "/":" + "/"" + dt.Rows[i][j].ToString() + "/","); } else if (j == dt.Columns.Count - 1) { JsonString.Append("/"" + dt.Columns[j].ColumnName.ToString() + "/":" + "/"" + dt.Rows[i][j].ToString() + "/""); } } /**/ /*end Of String*/ if (i == dt.Rows.Count - 1) { JsonString.Append("} "); } else { JsonString.Append("}, "); } } JsonString.Append("]}"); return JsonString.ToString(); } else { return null; } }