Html failed to display data properly other than string data type

Question

0.00/5 (No votes)

See more:

Hi, I have some values return from my controller written in C#. I have debug the codes and all data returned is ok. But when I try to display the data in HTML, the data appears weird for all those which are not in String data type.
For example, if I have date time which is in 2016-09-27 then it would display as /Date(123456789)/.
Below are my script in javascript format:

JavaScript

PullRecordsForEfficiencyTable: function(firstName, customerId){
    firstName = firstName;
    customerId = customerId;

    $.ajax({
        contentType: "application/json; charset=utf-8",
        dataType: "json",
        type: "POST",
        url: "/Customer/LoadRecordsForEfficiencyTable",
        data: JSON.stringify({
              firstName :firstName;
              customerId : customerId;

        }),
        success: function (data) {
            document.getElementById('dvFirstName').innerHTML = data.data[0].Name;
            document.getElementById('dvStartDate').innerHTML = data.data[0].StartDate;
        },
        fail: function (jqXHR, textStatus, errorThrown) {
            alert(errorThrown);
        },
        error: function (jqXHR, textStatus, errorThrown) {
            alert(errorThrown);
        }

    });
},

The "FirName" appear perfectly but for "StartDate", it would be displayed as /Date(123456789)/.
Any ideas?

What I have tried:

1. Tried to search online but without getting any clues.

Posted 26-Sep-16 23:59pm

Jamie888

Updated 27-Sep-16 0:04am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Karthik_Mahalingam · Accepted Answer · 2016-09-27T00:04:00

Solution 1

try this

JavaScript

function formatDate(date) {
         var d = new Date(date),
             month = '' + (d.getMonth() + 1),
             day = '' + d.getDate(),
             year = d.getFullYear();

         if (month.length < 2) month = '0' + month;
         if (day.length < 2) day = '0' + day;

         return [year, month, day].join('-');
     }

JavaScript

document.getElementById('dvStartDate').innerHTML = formatDate(new Date(parseInt(data.data[0].StartDate.substr(6))));

Posted 27-Sep-16 0:04am

Karthik_Mahalingam

Comments

Jamie888 27-Sep-16 6:24am

Sir, may I know what is the substr(6) for?

Karthik_Mahalingam 27-Sep-16 6:37am

to remove /Date(

Jamie888 27-Sep-16 6:40am

I have check online, does javascript would display any datetime as /Date(123456789)/ if we do not change its value as suggested by sir on above?

Karthik_Mahalingam 27-Sep-16 6:46am

if the ajax json is passed as datetime object, it will be displayed like this only.

Jamie888 27-Sep-16 6:49am

I have modified your script into:
return [month, day, year].join('/') + " " + [hour, minute, seconds].join(':');

How can I add "AM" or "PM" into it?

Karthik_Mahalingam 27-Sep-16 7:02am

var dt = [month, day, year].join('/') + " " + [hour, minute, seconds].join(':');
var ampm = d.getHours() >= 12 ? 'pm' : 'am';
return dt + ' ' + ampm

Jamie888 27-Sep-16 7:00am

Sir, does this affect other data type also. For example double or integer? This is due to I have value returned from controller(double data type) with value 0.5 but displayed as "undefined" in HTML.

Karthik_Mahalingam 27-Sep-16 7:03am

this code is only for date column. not to all others properties.

Jamie888 27-Sep-16 7:08am

I have a value which is in double data type in controller(for example 0.5) but when it is being displayed in HTML, it changed to "undefined". I have tried to debug it but I cant find any clue on it as on the final line of codes in controller(C#), it is still 0.5 but changed to "undefined" when it arrive in HTML.

Karthik_Mahalingam 27-Sep-16 7:11am

make sure that the property name is same.

Jamie888 27-Sep-16 7:13am

Sorry sir, its my own mistake. It was due to typo that caused this problem. Sorry for any inconvenience caused.

Karthik_Mahalingam 27-Sep-16 7:14am

hmm, cool,
if your issue is fixed, pls close this post.

Jamie888 27-Sep-16 7:16am

Thank you very much sir. Really appreciate it. Thank you.

Karthik_Mahalingam 27-Sep-16 7:17am

welcome jaime ~~lannister~~ ;)