首页 > Web开发 > 详细

DataTable转换为Json格式

时间:2014-11-25 10:39:14      阅读:281      评论:0      收藏:0      [点我收藏+]

public string DataTableToJson(string jsonName, DataTable dt, TemplateFilter temp)         {

            StringBuilder Json = new StringBuilder();

            Json.Append("[");

            Json.Append("{");            

//当前页码            

Json.Append("\"pageIndex\":\"" + temp.PageIndex.ToString() + "\",");            

//总条数           

Json.Append("\"pagenum\":\"" + Convert.ToInt32(Math.Ceiling(Convert.ToDouble(temp.AllPageNum) / Convert.ToDouble(temp.PageSize))) + "\",");

            //搜索结果            

Json.Append("\"result\":\"" + temp.Results + "\"");

 

            if (dt.HasData())             {                

Json.Append("},");               

for (int i = 0; i < dt.Rows.Count; i++)                 {                    

Json.Append("{");

                    for (int j = 0; j < dt.Columns.Count; j++)                     {

                        Json.Append("\"" + dt.Columns[j].ColumnName.ToString() + "\":\"" + dt.Rows[i][j].ToString() + "\"");

                        if (j < dt.Columns.Count - 1)                         {

                            Json.Append(",");

                        }

                    }

                    Json.Append("}");

                    if (i < dt.Rows.Count - 1)                     {

                        Json.Append(",");

                    }

                }             }             else             {                 Json.Append("}");             }

 

            Json.Append("]");

            return Json.ToString();

        }

DataTable转换为Json格式

原文:http://www.cnblogs.com/rukialu/p/4120316.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!