JSON.NET convert specific key to integer

Question

I'm taking a DataSet and converting it to JSON via JSON.NET

The issue I'm facing is that one of the fields is stored as a floating point value but I need it to serialize as an integer instead. I don't want to change all floating point to integer, just that one field.

Does anyone have an example of that?

How do you convert a DataSet to JSON? please share your code and some sample data and your expected result of that -HTH ;). — shA.t
– shA.t, Commented Sep 20, 2017 at 16:29

Z.R.T. · Accepted Answer · 2017-09-20 18:34:16Z

let say we have ds filled with data from dbTable. we need to change field dbTableField value type from it's own to double:

var ds = new DataSet();
new SqlDataAdapter(com).Fill(ds, "dbTable");
var result = JsonConvert.SerializeObject(ds, Formatting.Indented, new 
DataSetFieldTypeConverter(typeof(double), "dbTable", "dbTableField"));

below is a DataSetFieldTypeConverter class:

class DataSetFieldTypeConverter : JsonConverter
{
    private Type convertTo;
    private string tableName;
    private string fieldName;
    public DataSetFieldTypeConverter(Type convertTo, string tableName, string fieldName)
    {
        this.convertTo = convertTo;
        this.tableName = tableName;
        this.fieldName = fieldName;
    }

    public override void WriteJson(JsonWriter writer, object value, JsonSerializer serializer)
    {
        JToken t = JToken.FromObject(value);

        if (t.Type != JTokenType.Object)
        {
            t.WriteTo(writer);
        }
        else
        {
            JObject jsonObj = t as JObject;
            if (jsonObj != null && jsonObj[tableName] != null && jsonObj[tableName][0][fieldName] != null)
            {
                var propVal= jsonObj[tableName][0][fieldName].Value<string>();

                //Write your own covert logic here

                if (convertTo == typeof(int))
                {
                    int propValInt;
                    if (int.TryParse(propVal, out propValInt))
                    {
                        jsonObj[tableName][0][fieldName] = propValInt;
                    }
                }
                if (convertTo == typeof(double))
                {
                    double propValInt;
                    if (double.TryParse(propVal, out propValInt))
                    {
                        jsonObj[tableName][0][fieldName] = propValInt;
                    }
                }
                jsonObj.WriteTo(writer);
            }
        }
    }

this link would be useful : https://www.newtonsoft.com/json/help/html/CustomJsonConverter.htm

Collectives™ on Stack Overflow

JSON.NET convert specific key to integer

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related