My ajax call is not going to server side. Here is my code:
function InsertData() {
debugger;
var email = $("#txtemail").val();
var pass = $("#txtpass").val();
var firstName = $("#txtfirstName").val();
var lastName = $("#txtlastName").val();
var userData = "{'email':'" + email + "','pass':'" + pass + "'firstName':'" + firstName + "','lastName':'" + lastName + "'}";
$.ajax({
type: "POST",
url: "Home.aspx/ExecuteInsert",
data: userData,
contentType: "application/json;charset=utf-8",
dataType: "json",
success: function (msg) {
alert(msg);
},
error: function (x, e) {
alert("The call to the server side failed. " + x.responseText);
}
});
}
C#
[WebMethod]
public static void ExecuteInsert(string email, string pass, string firstName, string lastName)
{
string connStr = @"Data Source=userinfo; Database= MYWEB;User ID=myweb;Password=***********";
using (SqlConnection connect = new SqlConnection(connStr))
{
using (SqlCommand command = new SqlCommand("web_proc_testweb_demo" , connect))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(@email, SqlDbType.VarChar).Value = pass;
command.Parameters.Add(@pass, SqlDbType.VarChar).Value = firstName;
command.Parameters.Add(@firstName, SqlDbType.VarChar).Value = lastName;
command.Parameters.Add(@lastName, SqlDbType.VarChar).Value = email;
command.ExecuteNonQuery();
}
}
}
Instead of going to the server side this error is raised:
The call to the server side failed. {“Message”:"Invalid object passed}