Convert datatable to JSON in C#

by

This code snippet from Convert Datatable to JSON String in C#, VB.NET might help you.
It uses System.Web.Script.Serialization.JavaScriptSerializer to serialize the contents to JSON format:

public string ConvertDataTabletoString()
{
    DataTable dt = new DataTable();
    using (SqlConnection con = new SqlConnection("Data Source=SureshDasari;Initial Catalog=master;Integrated Security=true"))
    {
        using (SqlCommand cmd = new SqlCommand("select title=City,lat=latitude,lng=longitude,description from LocationDetails", con))
        {
            con.Open();
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            da.Fill(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;
            foreach (DataRow dr in dt.Rows)
            {
                row = new Dictionary<string, object>();
                foreach (DataColumn col in dt.Columns)
                {
                    row.Add(col.ColumnName, dr[col]);
                }
                rows.Add(row);
            }
            return serializer.Serialize(rows);
        }
    }
}

More Related Contents:

  1. Convert JSON to DataTable
  2. How to convert datatable to json string using json.net?
  3. DataTable to JSON [duplicate]
  4. Convert DataTable to JSON with key per row
  5. parse JSON using json.net c# [closed]
  6. Parse value from http web response stream
  7. Inner join of DataTables in C#
  8. How do I convert a dictionary to a JSON String in C#?
  9. Circular reference detected exception while serializing object to JSON
  10. Deserialize json array stream one item at a time
  11. How to select min and max values of a column in a datatable?
  12. Posting JSON Data to ASP.NET MVC
  13. How to create a DataTable in C# and how to add rows?
  14. How to flatten an ExpandoObject returned via JsonResult in asp.net mvc?
  15. How do I enumerate through a JObject?
  16. caliburn.micro serialization issue when implementing PropertyChangedBase
  17. JSON.net serialize directly from oledbconnection
  18. how to convert NameValueCollection to JSON string?
  19. multiple JsonProperty Name assigned to single property
  20. Can I LINQ a JSON?
  21. JSON deserialization – Map array indices to properties with JSON.NET
  22. Best way to check if a Data Table has a null value in it
  23. Get Cell Value from a DataTable in C#
  24. json net leading zeros (disable base-cast)
  25. How to deserialize a property with a dash (“-”) in its name with NewtonSoft JsonConvert?
  26. Serializing/Deserializing Dictionary of objects with JSON.NET
  27. Parsing field name with a colon in JSON
  28. Formatting DateTime in ASP.NET Core 3.0 using System.Text.Json
  29. Generate JSON object with NewtonSoft in a single line
  30. Convert DataTable to Generic List in C#

Leave a Comment