Create Json in C# from DataTable

Question

I am using the wdcalendar with asp.net. After getting the records from the database I need to return a JSON string back to the page. I have the DataTable which contains the records from the DB but I am not sure how to convert it to this exact format:

{ 
  "end" : "09/29/2013 23:59",
  "error" : null,
  "events" : [ [ 1,
        "test",
        "09/26/2013 08:11",
        "09/26/2013 08:08",
        0,
        0,
        0,
        "1",
        1,
        "loca",
        ""
      ],
      [ 2,
        "test2",
        "09/27/2013 08:11",
        "09/27/2013 08:08",
        0,
        0,
        0,
        "1",
        1,
        "loca",
        ""
      ]
    ],
  "issort" : true,
  "start" : "09/23/2013 00:00"
}

I added a new line to show the different data which contains two rows from the database and then at the end there is additional info appended to the data which is the last line shown above.

I am hoping there is a better way then building the string manually.

Thanks.

Aravind · Accepted Answer · 2013-09-27 05:57:50Z

2

Try like this

 public class RootObject
 {
public string end { get; set; }
public object error { get; set; }
public List<List<object>> events { get; set; }
public bool issort { get; set; }
public string start { get; set; }
}

Create a Object and set the properties ... you will get all the details then put it in datatable ...

   Copy paste your json string it will generate the class

http://json2csharp.com/

answered Sep 27, 2013 at 5:57

Aravind

1,5492 gold badges12 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Manish Sharma · Accepted Answer · 2013-09-27 05:08:56Z

1

use this,

public string GetJson(DataTable dt)
{
    System.Web.Script.Serialization.JavaScriptSerializer serializer = new 

    System.Web.Script.Serialization.JavaScriptSerializer();
    List<Dictionary<string, object>> rows = new List<Dictionary<string, object>>();
    Dictionary<string, object> row = null;

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

or using JSON.NET.

string json = JsonConvert.SerializeObject(table, new Serialization.DataTableConverter());
var o = JsonConvert.DeserializeObject<DataTable>(json, new Serialization.DataTableConverter());

edited Sep 27, 2013 at 5:08

answered Sep 27, 2013 at 5:00

Manish Sharma

2,4562 gold badges18 silver badges33 bronze badges

1 Comment

user1253073 Over a year ago

Your method is adding a the column names to the final string. Also there is missing the last row.

Nirmal · Accepted Answer · 2013-09-27 05:29:35Z

0

Would it help you convince your bosses to install a library if it's Microsoft's AJAX extensions for .NET 2.0?

Included in them is System.Web.Script.Serialization.JavascriptSerializer, which is used in Step 4 of the last link in your post.

answered Sep 27, 2013 at 5:29

Nirmal

9344 silver badges9 bronze badges

Collectives™ on Stack Overflow

Create Json in C# from DataTable

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related