Databases
StackOverflow2013
Postsdbo
POJQuery passing NULL value to Controller
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POJQuery passing NULL value to Controller
    primarykey
    data
    text
    <p>I am trying to check if an email exists in a DB using JQuery. Currently, I am sending the email through an <code>$ajax</code> request:</p> <pre><code>$(".newsletter form").submit(function (event) { event.preventDefault(); var postData = JSON.stringify($(this).serialize()); var status = $(".newsletter p"); status.removeClass('shake'); $.ajax({ type: "POST", contentType: "application/json;charset=utf-8", url: "/Home/AddEmail", data: JSON.stringify(postData), dataType: "json", success: function(data) { if (data == "success") status.html("Thanks for your interest! We will let you know.").slideDown(); else if (data == "subscribed") status.toggleClass('shake').html("This email is already subscribed.").slideDown(); else if (data == "invalid") status.toggleClass('shake').html("This email is invalid.").slideDown(); else if (data == "noValue") status.toggleClass('shake').html("No email specified.").slideDown(); else status.toggleClass('shake').html("Oops, something went wrong!").slideDown(); }, error: function () { status.toggleClass('shake').html("Oops, something went wrong!").slideDown(); } }); }); </code></pre> <p>And my controller gets it by:</p> <pre><code>[HttpPost] public JsonResult AddEmail(EmailA email) { string returnMessage = "success"; if (string.IsNullOrEmpty(email.ToString())) { return Json("noValue"); } try { SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ICECONNSTRING"].ConnectionString); sqlConn.Open(); string sSQL = "SELECT COUNT(em_email) FROM v2_email WHERE em_email = @email"; SqlCommand sqlCommand = new SqlCommand(sSQL, sqlConn) { CommandType = CommandType.Text }; sqlCommand.Parameters.Add(new SqlParameter("@email", SqlDbType.NVarChar, 50)).Value = email; int count = (int)sqlCommand.ExecuteScalar(); if (count == 0) { return Json("subscribed"); } } catch (Exception es) { Console.Write(es.Message); return Json("error"); } return Json(returnMessage); } [Serializable] public class EmailA { public string email { get; set; } } </code></pre> <p>But the value for <code>email</code> is ALWAYS null. Can someone point out where I'm going wrong? I'm new to MVC</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. UStereško
    1. USTheGeekZn
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COwhy `JSON.stringify` twice? and what `inputs` your `form` contains? also there's no need to use `serialize` here.
      singulars
      1. POJQuery passing NULL value to Controller
      1. UShaim770
    2. COThe `JSON.stringify` was just to force the data (thought it may help). I'm using a template which I HAVE to stick to. When I place `alert(postData)` I get `"email=whatever"`
      singulars
      1. POJQuery passing NULL value to Controller
      1. USTheGeekZn
 

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