C# Newtonsoft.Json DataRow 单行转json

最新推荐文章于 2024-07-26 16:22:28 发布

天若2013

最新推荐文章于 2024-07-26 16:22:28 发布

阅读量306

点赞数 2

文章标签： c# json java

本文链接：https://blog.csdn.net/ldevs/article/details/137448640

版权

将datarow转换成json字符串转换时将表字段名转小写

internal class DataRowConverter: Newtonsoft.Json.Converters.CustomCreationConverter<DataRow>
{
    public override bool CanWrite => true;
    public override DataRow Create(Type objectType)
    {
        return null;
    }

    public override void WriteJson(JsonWriter writer, object value, JsonSerializer serializer)
    {
        if (value == null)
        {
            writer.WriteNull();
            return;
        }

        writer.WriteStartObject();
        DataRow row = (DataRow)value;
        foreach (DataColumn column in row.Table.Columns)
        {
            object obj2 = row[column];
            if (serializer.NullValueHandling != NullValueHandling.Ignore || (obj2 != null && obj2 != DBNull.Value))
            {
                writer.WritePropertyName(column.ColumnName.ToLower());
                serializer.Serialize(writer, obj2);
            }
        }

        writer.WriteEndObject();
    }
}