时间: 2020-11-22|24次围观|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();

        }

转载于:https://www.cnblogs.com/rukialu/p/4120316.html

原文链接:https://blog.csdn.net/weixin_30342827/article/details/98103465

本站声明:网站内容来源于网络,如有侵权,请联系我们,我们将及时处理。

本博客所有文章如无特别注明均为原创。
复制或转载请以超链接形式注明转自起风了,原文地址《DataTable转换为Json格式
   

还没有人抢沙发呢~