Answers

• allan Posts: 63,353Questions: 1Answers: 10,444 Site admin

  May 2016

  You could try using MomentJS - you'll need to use a renderer. Or, convert it on the server-side before it is being sent to DataTables.

  Allan
• Watchara Posts: 30Questions: 5Answers: 1

  May 2016

  Thanks a lot
  Mr. Allan.

  and I try to follow by the example of datatables pattern from url

  https://editor.datatables.net/examples/advanced/multiItem.html

  but it's not working. no data render on screen.

  what's wrong with me?
• allan Posts: 63,353Questions: 1Answers: 10,444 Site admin

  May 2016

  I'm not sure why it isn't working. Can you give me a link to the page so I can take a look and see why it isn't please.

  Allan
• Watchara Posts: 30Questions: 5Answers: 1

  July 2016 edited July 2016

  <script>
          $(function () {
              var dataTable = $("table#dados1").dataTable({
                  "sPaginationType": "full_numbers",
                  "aoColumns": [
                      { "mDataProp": "IPAddress" },
                      { "mDataProp": "Type" },
                      { "mDataProp": "ModelName" },
                      { "mDataProp": "BrandName" },
                      { "mDataProp": "DateCreate" },
                      { "mDataProp": "MachineName" },
                  ]
              });
  
              $("button.busca").click(function () {
  
                  $.post("/Dashboard/GetDados", { profissao: $("#ddlProfissao").val() }, function (json) {
  
                      dataTable.fnClearTable();
                      dataTable.fnAddData(json);
                  }, 'json');
  
              });
  
              //busca inicial
              $("button.busca").click();
  
          });
      </script>
  

  ---

  Here is my code. How to convert DateTime Format at { "mDataProp": "DateCreate" }

  Edited by Allan - Syntax highlighting. Details on how to highlight code using markdown can be found in this guide.
• allan Posts: 63,353Questions: 1Answers: 10,444 Site admin

  July 2016

  Thanks for the code, however I don't see the issue from that I'm afraid. Can you give me a link to a page showing the issue, as I requested above, so I can offer some assistance.

  Allan
• Watchara Posts: 30Questions: 5Answers: 1

  July 2016

  Here is my result DateTime shown /Date(1433869200000)/. you can see as a picture

  Capture.JPG 72.3K
• allan Posts: 63,353Questions: 1Answers: 10,444 Site admin

  July 2016

  That's a .NET datetime object as a string. You have two options:

  • Convert it to be a readable format on the server-side (what I would recommend)
  • Convert it to be a readable format on the client-side using a renderer.

  Allan
• Watchara Posts: 30Questions: 5Answers: 1

  July 2016

  Thank you, Allan

  I can adapt it with function and now I need to be put edit button to my datatables

  How to do? in the same code on above.
• allan Posts: 63,353Questions: 1Answers: 10,444 Site admin

  July 2016 edited July 2016

  Editor is the officially supported method for editing DataTables. If you use editor, I would suggest using its GetFormatter and SetFormatter for date time fields. The .NET package includes examples of that.

  Allan
• Watchara Posts: 30Questions: 5Answers: 1

  July 2016 edited July 2016

  your suggestion page is 404 page not found.

  I need to create datatables like attached picture.

  how to change my code?

  datatable-edit-pdf.JPG 95.7K
• allan Posts: 63,353Questions: 1Answers: 10,444 Site admin

  July 2016

  Sorry - I've corrected the link now - it just had a trailing ).

  Allan
• Rasika Posts: 2Questions: 0Answers: 0

  October 2016

  Hello
• Rasika Posts: 2Questions: 0Answers: 0

  October 2016

  I want to convert this date format /Date(1433869200000)/
• allan Posts: 63,353Questions: 1Answers: 10,444 Site admin

  October 2016

  Per my post above:

  That's a .NET datetime object as a string. You have two options:

  • Convert it to be a readable format on the server-side (what I would recommend)
  • Convert it to be a readable format on the client-side using a renderer.