Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Microsoft use <a href="http://msdn.microsoft.com/en-us/library/system.web.script.serialization.javascriptserializer.aspx" rel="nofollow noreferrer">JavaScriptSerializer</a> to serialize/desirealize the ASP.NET MVC data. If use <code>/Date(utcDate)/</code> format for the <code>Date</code> data type. Try to use</p> <pre><code>'"\\/Date(' + myStory.Deadline.getTime() + ')\\/"' </code></pre> <p>or </p> <pre><code>var d = myStory.Deadline; var dateForMS = '"\\/Date(' + Date.UTC (d.getUTCFullYear(), d.getUTCMonth(), d.getUTCDate(), d.getUTCHours(), d.getUTCMinutes(), d.getUTCSeconds(), d.getUTCMilliseconds()) + ')\\/"' </code></pre> <p>You can also just use <code>Sys.Serialization.JavaScriptSerializer</code> from <code>MicrosoftAjax.js</code> to serialize <code>Deadline</code> or any other <code>Date</code> type.</p> <p><strong>UPDATED</strong>: Probably you should use <code>'\/Date('</code> and <code>')\/'</code> instead of <code>'"\\/Date('</code> and <code>')\\/"'</code>. All depends on where you will insert the string.</p> <p><strong>UPDATED 2</strong>: Now I have it! ASP.NET MVC is used mostly for the posting Form fields per Ajax. On the server side will be just used <code>Parse</code> method for every type to convert the posted parameter to the type. So one can use any string format which are supported by <a href="http://msdn.microsoft.com/en-us/library/1k1skd40.aspx#remarksToggle" rel="nofollow noreferrer">DateTime.Parse</a>. For example you can use ISO 8601 format like '2010-08-29T13:15:00.0000000Z'. To do this in modern browsers (firefox, chrome) one can use <code>toISOString()</code> function. To be more independend one can implement data conversion like described in <a href="http://williamsportwebdeveloper.com/cgi/wp/?p=503" rel="nofollow noreferrer">http://williamsportwebdeveloper.com/cgi/wp/?p=503</a>:</p> <pre><code>var d = new Date($('#story-deadline').val()) //var d = new Date(); // get the date. Here we use just Now. var dAsISOString; if ($.isFunction(d.toISOString)) { //alert("internal toISOString are used!"); dAsISOString = d.toISOString(); } else { dAsISOString = d.getUTCFullYear() + '-' + padzero(d.getUTCMonth() + 1) + '-' + padzero(d.getUTCDate()) + 'T' + padzero(d.getUTCHours()) + ':' + padzero(d.getUTCMinutes()) + ':' + padzero(d.getUTCSeconds())+'.'+ pad2zeros(d.getUTCMilliseconds()) + 'Z'; } var myStory = { Summary: 'Test description', Size: 8, Dedline: dAsISOString }; $.ajax({ url: '/Project/1/AddStory', data: { Summary: myStory.Summary, Size: myStory.Size, Dedline: myStory.Dedline }, dataType: 'json', // ... }); </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POJSON Date parameter passed to MVC Action is always null
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USOleg
    1. USOleg
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POJSON Date parameter passed to MVC Action is always null
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI've tried both your original formatting suggestion and the updated one and both are still arriving as null. They are being posted correctly, though: Deadline "/Date(1283169600000)/"
      singulars
      1. PO
      1. USPhil.Wheeler
    2. COIt seems that one should test the problem with the source code of MVC (see http://weblogs.asp.net/jacqueseloff/archive/2010/04/20/mvc-2-source-code-released-to-microsoft-reference-server.aspx and http://aspnet.codeplex.com/releases/view/41742). If you will have any results let me know.
      singulars
      1. PO
      1. USOleg
    3. COit works for me only in case I manually serialize data as json. **data: JSON.stringify(params),**
      singulars
      1. PO
      1. USvsapiha
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload