隨著AJAX，MVC等WEB框架的使用，JavaScript又更多的回到了我們身邊。
在JS中我們需要對對象進行JSON序列化通常使用JSON.net, 不過它對DataTable的序列化不能很好的滿足的我們的需求，后來在CodeProject發(fā)現(xiàn)一個兄弟已經(jīng)寫好了 Convert ASP.NET DataTable to JSON, to use datatable in JAVASCRIPT ，記一下，免得忘記了。

?1public?string?CreateJsonParameters(DataTable?dt)
?2????????{
?3????????????/**//*?/****************************************************************************
?4?????????????*?Without?goingin?to?the?depth?of?the?functioning?of?this?Method,?i?will?try?to?give?an?overview
?5?????????????*?As?soon?as?this?method?gets?a?DataTable?it?starts?to?convert?it?into?JSON?String,
?6?????????????*?it?takes?each?row?and?in?each?row?it?grabs?the?cell?name?and?its?data.
?7?????????????*?This?kind?of?JSON?is?very?usefull?when?developer?have?to?have?Column?name?of?the?.
?8?????????????*?Values?Can?be?Access?on?clien?in?this?way.?OBJ.HEAD[0].<ColumnName>
?9?????????????*?NOTE:?One?negative?point.?by?this?method?user?will?not?be?able?to?call?any?cell?by?its?index.
10?????????????*?*************************************************************************/
11????????????StringBuilder?JsonString?=?new?StringBuilder();
12????????????//Exception?Handling????????
13????????????if?(dt?!=?null?&&?dt.Rows.Count?>?0)
14????????????{
15????????????????JsonString.Append("{?");
16????????????????JsonString.Append("\"Head\":[?");
17????????????????for?(int?i?=?0;?i?<?dt.Rows.Count;?i++)
18????????????????{
19????????????????????JsonString.Append("{?");
20????????????????????for?(int?j?=?0;?j?<?dt.Columns.Count;?j++)
21????????????????????{
22????????????????????????if?(j?<?dt.Columns.Count?-?1)
23????????????????????????{
24????????????????????????????JsonString.Append("\""?+?dt.Columns[j].ColumnName.ToString()?+?"\":"?+?"\""?+?dt.Rows[i][j].ToString()?+?"\",");
25????????????????????????}
26????????????????????????else?if?(j?==?dt.Columns.Count?-?1)
27????????????????????????{
28????????????????????????????JsonString.Append("\""?+?dt.Columns[j].ColumnName.ToString()?+?"\":"?+?"\""?+?dt.Rows[i][j].ToString()?+?"\"");
29????????????????????????}
30????????????????????}
31????????????????????/**//*end?Of?String*/
32????????????????????if?(i?==?dt.Rows.Count?-?1)
33????????????????????{
34????????????????????????JsonString.Append("}?");
35????????????????????}
36????????????????????else
37????????????????????{
38????????????????????????JsonString.Append("},?");
39????????????????????}
40????????????????}
41????????????????JsonString.Append("]}");
42????????????????return?JsonString.ToString();
43????????????}
44????????????else
45????????????{
46????????????????return?null;
47????????????}
48????????}

轉(zhuǎn)載于:https://www.cnblogs.com/xingzhixp/archive/2007/11/24/971422.html

總結(jié)

以上是生活随笔為你收集整理的DataTable 的 JSON 序列化的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。