将 JSON 转换为数据表 [英] Convert JSON to DataTable

问题描述

我有以下格式的 JSON:

<预><代码>[{"id":"10","name":"User","add":false,"edit":true,"authorize":true,"view":true},{"id":"11","name":"Group","add":true,"edit":false,"authorize":false,"view":true},{"id":"12","name":"Permission","add":true,"edit":true,"authorize":true,"view":true}]

如何将其转换为 C# DataTable 对象，如下所示?

---------------------------------------------------------------------身份证 |姓名 |添加 |编辑 |查看 |授权---------------------------------------------------------------------10 |用户 |真实|真实|真实|真的11 |集团 |真实|真实|真实|真的12 |权限|真实|真实|真实|真的

解决方案

将你的 jsonstring 反序列化为某个类

列表<用户>UserList = JsonConvert.DeserializeObject>(jsonString);

将以下扩展方法写入您的项目

使用 System.ComponentModel;public static DataTable ToDataTable(这个IList数据){PropertyDescriptorCollection 道具 =TypeDescriptor.GetProperties(typeof(T));DataTable table = new DataTable();for(int i = 0 ; i < props.Count ; i++){PropertyDescriptor prop = props[i];table.Columns.Add(prop.Name, prop.PropertyType);}object[] values = new object[props.Count];foreach(数据中的T项){for (int i = 0; i < values.Length; i++){values[i] = props[i].GetValue(item);}table.Rows.Add(values);}返回表；}

电话扩展方法如

UserList.ToDataTable();

I have JSON in the following format:

[
    {"id":"10","name":"User","add":false,"edit":true,"authorize":true,"view":true},
    {"id":"11","name":"Group","add":true,"edit":false,"authorize":false,"view":true},
    {"id":"12","name":"Permission","add":true,"edit":true,"authorize":true,"view":true}
]

How can I convert that into a C# DataTable object as follows?

---------------------------------------------------------------------
ID    |  Name     |  Add    |   Edit  | View   | Authorize
---------------------------------------------------------------------
10    | User      | true    |  true   | true   |  true
11    | Group     | true    |  true   | true   |  true
12    | Permission| true    |  true   | true   |  true

解决方案

Deserialize your jsonstring to some class

List<User> UserList = JsonConvert.DeserializeObject<List<User>>(jsonString);

Write following extension method to your project

using System.ComponentModel;

public static DataTable ToDataTable<T>(this IList<T> data)
{
    PropertyDescriptorCollection props =
    TypeDescriptor.GetProperties(typeof(T));
    DataTable table = new DataTable();
    for(int i = 0 ; i < props.Count ; i++)
    {
        PropertyDescriptor prop = props[i];
        table.Columns.Add(prop.Name, prop.PropertyType);
    }
    object[] values = new object[props.Count];
    foreach (T item in data)
    {
        for (int i = 0; i < values.Length; i++)
        {
            values[i] = props[i].GetValue(item);
        }
        table.Rows.Add(values);
    }
    return table;        
}

Call extension method like

UserList.ToDataTable<User>();

这篇关于将 JSON 转换为数据表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！