C# 根据DataTable 转换成JSON 文本字符串数据


C# 根据 DataTable 转换为 JSON 字符串文本

public string DataTable2Json(DataTable data)
{
    System.Collections.ArrayList dic = new System.Collections.ArrayList();
    foreach (DataRow row in data.Rows)
    {
        System.Collections.Generic.Dictionary<string, object> drow = new System.Collections.Generic.Dictionary<string, object>();
        foreach (DataColumn dc in data.Columns)
        {
            drow.Add(dc.ColumnName, row[dc.ColumnName]);
        }
        dic.Add(drow);
    }
    string json = Newtonsoft.Json.JsonConvert.SerializeObject(dic, Newtonsoft.Json.Formatting.Indented);
    return json;
}
GarsonZhang www.yesdotnet.com

 

C# 根据List<DataRow> 转换为JSON数据

public string DataTable2Json(List<DataRow> data)
{
    System.Collections.ArrayList dic = new System.Collections.ArrayList();
    foreach (DataRow row in data.Rows)
    {
        System.Collections.Generic.Dictionary<string, object> drow = new System.Collections.Generic.Dictionary<string, object>();
        foreach (DataColumn dc in data.Columns)
        {
            drow.Add(dc.ColumnName, row[dc.ColumnName]);
        }
        dic.Add(drow);
    }
    string json = Newtonsoft.Json.JsonConvert.SerializeObject(dic, Newtonsoft.Json.Formatting.Indented);
    return json;
}
GarsonZhang www.yesdotnet.com

C# 获得 dataGridView 选择的行,并且转换为 JSON 文本数据

System.Collections.ArrayList dic = new System.Collections.ArrayList();
foreach (DataGridViewRow o in dataGridView1.SelectedRows)
{
    DataRow row = (o.DataBoundItem as DataRowView).Row;
    System.Collections.Generic.Dictionary<string, object> drow = new System.Collections.Generic.Dictionary<string, object>();
    foreach (DataColumn dc in row.Table.Columns)
    {
        drow.Add(dc.ColumnName, row[dc.ColumnName]);
    }
    dic.Add(drow);
}

string json = Newtonsoft.Json.JsonConvert.SerializeObject(dic, Newtonsoft.Json.Formatting.Indented);
GarsonZhang www.yesdotnet.com

 

 

版权声明:本文为YES开发框架网发布内容,转载请附上原文出处连接
YES开发框架
上一篇:C# 根据DataTable 转换成JSON 文本字符串数据
下一篇:C# Newtonsoft.Json.JsonConvert.SerializeObject生成格式化的JSON字符串
评论列表

发表评论

评论内容
昵称:

联系我们
联系电话:15090125178(微信同号)
电子邮箱:garson_zhang@163.com
站长微信二维码
微信二维码