Error Serializing Datatable Into JSON using Javascript serializer

Question

I have a class as,

public class Parameters
{
   public int Id {get;set;}
   public string FilterParam {get;set;}
   public string NameParam {get;set;}
   public IList<int> CollectionsIds {get;set;}
   public DataTable ParamTable {get;set;}
}

When I try to serialize to JSON I get circular reference error "A circular reference was detected when serializing the object".

My serializer code is:

JSONSerializer.SerializeObject<Parameters>(parameters)

private static JavaScriptSerializer _jsonSerializer = null;
private static JavaScriptSerializer JSONSerializer
{
    get
    {
        if (_jsonSerializer == null)
        {
            _jsonSerializer = new JavaScriptSerializer();
            _jsonSerializer.MaxJsonLength = 999999999;
        }
        return _jsonSerializer;
    }
}

public static string SerializeObject<T>(T obj)
{
    return JSONSerializer.Serialize(obj);
}

How do I serialize class into JSON format if the class contains dataTable as well?

Note: if I set dataTable to null it works fine but whenever I try to populate dataTable and call method to serialize it fails.

I thin Paramtable has same field from Parameters class. look at this stackoverflow.com/questions/17818386/… — V2Solutions - MS Team
– V2Solutions - MS Team, Commented Sep 12, 2014 at 10:10
@Tolga No I need to store Datatable to JSON as well along with Parameters class. In a worst case scenario probably I need to do workaround by creating class corresponding to DataTable. But I'm trying to get a solution for the existing class structure. — Joshua I
– Joshua I, Commented Sep 12, 2014 at 10:14
A V2Solutions, No its DataTable and name is completely different. I meant the column name of datatable is different from property declared in class parameters. — Joshua I
– Joshua I, Commented Sep 12, 2014 at 10:15

Tolga Evcimen · Accepted Answer · 2014-09-12 10:37:54Z

Just add a field(list of dictionaries) to fake your DataTable to your class. And ignore the DataTable member. Then you can serialize an object of this class as you needed.

public class Parameters
{
    public int Id {get;set;}
    public string FilterParam {get;set;}
    public string NameParam {get;set;}
    public IList<int> CollectionsIds {get;set;}
    [ScriptIgnore]
    public DataTable ParamTable {get;set;}

    public List<Dictionary<string, object>> _fakeParamTable
    {
        get
        {
            List<Dictionary<string, object>> rows = new List<Dictionary<string, object>>();
            Dictionary<string, object> row;

            foreach ( DataRow dr in ParamTable .Rows )
            {
                row = new Dictionary<string, object>();
                foreach ( DataColumn col in dt.Columns )
                {
                    row.Add(col.ColumnName, dr[col]);
                }
                rows.Add(row);
            }
            return rows;
        }
    }
}

user666 · Accepted Answer · 2014-09-12 10:16:36Z

0

Use this library: https://www.nuget.org/packages/newtonsoft.json/

This JSON:

{
 Parameters :
 {
   id: 1,
   FilterParam: "2",
   NameParam: "2",
   CollectionsIds: [1,2,3,1],
   ParamTable: {id:1,name:2,code:"3"}
 }
}

Will have classes (http://json2csharp.com/):

p

ublic class ParamTable
{
    public int id { get; set; }
    public int name { get; set; }
    public string code { get; set; }
}

public class Parameters
{
    public int id { get; set; }
    public string FilterParam { get; set; }
    public string NameParam { get; set; }
    public List<int> CollectionsIds { get; set; }
    public ParamTable ParamTable { get; set; }
}

public class RootObject
{
    public Parameters Parameters { get; set; }
}

So you will siple serialize, what you want like this:

JsonConvert.DeserializeObject<RootObject>(myJSON);

answered Sep 12, 2014 at 10:16

user666

2261 silver badge8 bronze badges

2 Comments

Joshua I Over a year ago

I'm aware of this approach. I have kept it as worst case scenario if there is absolutely no solution to fix dataTable to JSON. Thats my last hope to convert dataTable to meaningfull class and then call serialzer code.

user666 Over a year ago

Just use SerializationBinder then msdn.microsoft.com/en-us/library/ffas09b2 realization for JSON you will find there: james.newtonking.com/json/help/index.html?topic=html/…

Collectives™ on Stack Overflow

Error Serializing Datatable Into JSON using Javascript serializer

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related