Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

While Converting DataTable to Json , datetime is getting with "\/Date(1722796200000)\/" format

While Converting the DataTable to Json File, the field with DateTime is converting to a */Date(1722796200000)/*? there is any solution to convert the method to a real datetime or json datetime format "2024-08-05T00:00:00"

Structure of DataTable

DataTable dt = new DataTable();
dt.TableName = "TestJson";
dt.Columns.Add("No", typeof(short));
dt.Columns.Add("CDate", typeof(DateTime));


Datatable Format
No Date
1 05/08/2024 00:00:00
2 06/08/2024 00:00:00 
Code to add Data to DataTable 

dt.Rows.Add(1, Convert.ToDateTime(txtODate.Text));

Convertion process

string JsonData= DataTableToJSONWithJavaScriptSerializer(Dt);

public string DataTableToJSONWithJavaScriptSerializer(DataTable table)
{
    List<Dictionary<string, object>> rows = new List<Dictionary<string, object>>();
    Dictionary<string, object> row;
    foreach (DataRow dr in table.Rows)
    {
        row = new Dictionary<string, object>();
        foreach (DataColumn col in table.Columns)
        {
            row.Add(col.ColumnName, dr[col]);
        }
        rows.Add(row);
    }
    System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
    
    return serializer.Serialize(rows);

}

The Result Am getting

[{"No":1,"CDate":"/Date(1722796200000)/"}]

While due to this , when saving to SQL Server it is showing

"Conversion failed when converting date and/or time from character string"

Tags:

3

Answers


  1. Chosen as BEST ANSWER
    0

    By using the following syntax to solve the issue.

      Select DATEADD(SECOND, (CAST(SUBSTRING(CDate, CHARINDEX('(', CDate) + 1, CHARINDEX(')', CDate) - CHARINDEX('(', CDate) - 1) AS BIGINT)) / 1000, '1970-01-01 00:00:00')

  2. 0

    This is the default behavior of JavaScriptSerializer according to the documentation.

    Date object, represented in JSON as "/Date(number of ticks)/".

    If you want the date to be serialized in ISO8601 format, you should use the Newtonsoft.Json library:

    using Newtonsoft.Json;

...

return JsonConvert.SerializeObject(rows);

    Or using System.Text.Json library:

    using System.Text.Json;

...

return JsonSerializer.Serialize(rows);
    Login or Signup to reply.
  3. 0 
    using Newtonsoft.Json;
using Newtonsoft.Json.Converters;
using System;
using System.Data;

public class Program
{
    public static void Main()
    {
        DataTable dt = new DataTable();
        dt.Columns.Add("Date", typeof(DateTime));
        dt.Rows.Add(DateTime.Now);

        // Convert DataTable to JSON with custom date format
        string json = ConvertDataTableToJson(dt);
        Console.WriteLine(json);
    }

    public static string ConvertDataTableToJson(DataTable dataTable)
    {
        // Create settings with a enter code herecustom date format
        var settings = new JsonSerializerSettings
        {
            DateFormatString = "yyyy-MM-ddTHH:mm:ssZ" // ISO 8601 format
        };

        // Serialize DataTable to JSON
        string json = JsonConvert.SerializeObject(dataTable, settings);
        return json;
    }
}
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search