• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    公众号

C#后台构造json数据

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

前后台传值一般情况下,都会用到json类型的数据,比较常见,但是每次用到的时候去网上找比较麻烦,所以自己记录一下,下次直接用。

构造的json串格式,如下:

[{"id":"0","name":"name","active":"active","user_id":"user_id","no_of_reports":"no_of_reports"},
{"id":"1","name":"name","active":"active","user_id":"user_id","no_of_reports":"no_of_reports"},
{"id":"2","name":"name","active":"active","user_id":"user_id","no_of_reports":"no_of_reports"},
{"id":"3","name":"name","active":"active","user_id":"user_id","no_of_reports":"no_of_reports"},
{"id":"4","name":"name","active":"active","user_id":"user_id","no_of_reports":"no_of_reports"},
{"id":"5","name":"name","active":"active","user_id":"user_id","no_of_reports":"no_of_reports"},
{"id":"6","name":"name","active":"active","user_id":"user_id","no_of_reports":"no_of_reports"},
{"id":"7","name":"name","active":"active","user_id":"user_id","no_of_reports":"no_of_reports"},
{"id":"8","name":"name","active":"active","user_id":"user_id","no_of_reports":"no_of_reports"},
{"id":"9","name":"name","active":"active","user_id":"user_id","no_of_reports":"no_of_reports"}]

一、构造DataTable

      public DataTable getData()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("id", typeof(Int32));
            dt.Columns.Add("name", typeof(string));
            dt.Columns.Add("active", typeof(string));
            dt.Columns.Add("user_id", typeof(string));
            dt.Columns.Add("no_of_reports", typeof(string));
            for (int i = 0; i < 10; i++)
            {
                dt.Rows.Add(i, "name", "active", "user_id", "no_of_reports");
            }
            return dt;
        }

二、DataTable转json

     public string DataTableToJsonWithStringBuilder(DataTable table)
        {
            var jsonString = new StringBuilder();
            if (table.Rows.Count > 0)
            {
                jsonString.Append("[");
                for (int i = 0; i < table.Rows.Count; i++)
                {
                    jsonString.Append("{");
                    for (int j = 0; j < table.Columns.Count; j++)
                    {
                        if (j < table.Columns.Count - 1)
                        {
                            jsonString.Append("\"" + table.Columns[j].ColumnName.ToString()
                         + "\":" + "\""
                         + table.Rows[i][j].ToString() + "\",");
                        }
                        else if (j == table.Columns.Count - 1)
                        {
                            jsonString.Append("\"" + table.Columns[j].ColumnName.ToString()
                         + "\":" + "\""
                         + table.Rows[i][j].ToString() + "\"");
                        }
                    }
                    if (i == table.Rows.Count - 1)
                    {
                        jsonString.Append("}");
                    }
                    else
                    {
                        jsonString.Append("},");
                    }
                }
                jsonString.Append("]");
            }
            return jsonString.ToString();
        }

三、调用

  DataTable dt = getData();
  string str = DataTableToJsonWithStringBuilder(dt);              

 


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
C#面向对象基础类与方法发布时间:2022-07-13
下一篇:
【C#】【笔记】Task.Factory.StartNew的相关异常发布时间:2022-07-13
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap