Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>OK, the code bits contained in your question are absolutely insufficient to draw any conclusions. So let's do a full example.</p> <p>Model:</p> <pre><code>public class MyViewModel { public string Foo { get; set; } } </code></pre> <p>Controller:</p> <pre><code>public class HomeController : Controller { public ActionResult Index() { return View(new MyViewModel()); } [HttpPost] public ActionResult Index(MyViewModel model) { // TODO : process the model ... return Json(new { Result = "Success" }); } } </code></pre> <p>View:</p> <pre><code>&lt;% using (Html.BeginForm(null, null, FormMethod.Post, new { id = "myForm" })) { %&gt; &lt;%= Html.LabelFor(x =&gt; x.Foo) %&gt; &lt;%= Html.EditorFor(x =&gt; x.Foo) %&gt; &lt;input type="submit" value="Save" /&gt; &lt;% } %&gt; </code></pre> <p>External javascript to unobtrusively AJAXify the form:</p> <pre><code>$(function () { $('#myForm').submit(function () { $.ajax({ url: this.action, type: this.method, data: $(this).serialize(), success: function (data) { var message = data.Result; $('#Result').html(message); } }); return false; }); }); </code></pre> <p>Things to notice:</p> <ul> <li>I am attaching the <code>.submit</code> event to the if of the form (<code>#myForm</code>), whereas in your example you are using <code>#BtnName</code> which looks a strangely suspicious name for a form. Unfortunately you haven't shown your markup so we don't know what it actually represents</li> <li>I am no longer hardcoding the url of the form (<code>Home/Index</code>) but relying on the one generated by the <code>Html.BeginForm</code>. There are two benefits of this: 1. youcan now put your javascript into a separate file => you are no longer mixing markup and script and your HTML pages now become smaller and faster to load (the external static javascript files are cached) and 2. when you deploy your application on some other server or you decide to change your routes it will still work without any modification on your js.</li> <li>I am no longer using <code>contentType: 'application/json'</code> because when you use <code>$(this).serialize()</code> this doesn't serialize the form into JSON. It serializes it into a <code>application/x-www-form-urlencoded</code> style. So you are basically introducing a contradiction: you are telling the server that you will send a JSON request but in practice you don't.</li> <li>I have removed the <code>async: false</code> attribute as this does a synchronous request and freezes the browser during its execution. It is no longer AJAX. So unless you want this, don't use it.</li> <li>I have removed the <code>dataType: 'json'</code> parameter as jQuery is intelligent enough to deduce this from the actual response <code>Content-Type</code> header and automatically parse the returned JSON and pass it to the success callback as a javascript object that you could directly use.</li> </ul>
    singulars
    1. This table or related slice is empty.
    1. POHow to return JSON Result in MVC2 at Post
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USDarin Dimitrov
    1. USDarin Dimitrov
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to return JSON Result in MVC2 at Post
      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. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COdoes this apply to .post() aswell? and how would somebody to handle errors, like all results that get back is success (at least what i have experienced sometimes), because in the controller i have to make a return right, lets say the model is not valid, what do i return then?
      singulars
      1. PO
      1. USDejan.S
    2. CO@Dejan.S, there are many ways and no single answer. All will depend on your exact scenario and what you are trying to achieve. One way would be to put this form into a partial and have the controller action return this partial in case of validation error (so that fields that have errors could be highlighted in red) and in case of success return JSON. Then in the AJAX success callback you could check whether the returned result is a JSON object and if not inject the new partial into the DOM so that errors could be shown. There are other more RESTful ways using response HTTP status codes.
      singulars
      1. PO
      1. USDarin Dimitrov
    3. COi got a scenario but i dont got the code right here, ill make a new question and maybe you will answer it :), but i got what you mean with the partial, that was one of my thoughts. thanks for the reply
      singulars
      1. PO
      1. USDejan.S
 

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