check user name with jquery not hitting method

aditya immadi

hiall,

i wrote this for checking use name avialbiityy .the name with alert is pop up but the method in my controller not hitting any leads

function check() {

var Name = $("#checkid").val();

alert(Name);

$.ajax({

type: "POST",

url: "home/checkname/",

data: '{ UserName: Name }',

contentType: "application/json; charset=utf-8",

dataType: "json",

success: OnSuccess,

failure: function (response) {

alert(Name);

}

});

}

and in my controller

[AllowAnonymous]

public string checkname(string UserName)

{

SqlConnection con = new SqlConnection(s);

SqlCommand cmd = new SqlCommand("select UserName From tbl_Login where UserName=@Name", con);

cmd.Parameters.AddWithValue("@Name", UserName);

con.Open();

SqlDataReader d = cmd.ExecuteReader();

if (d.HasRows)

{

return "fine";

}

else

{

return "****";

}

Thanks and Regard

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Palaniappan10y ago
URL must be wrong. Check it properly.
functioncheck(){
varName=$("#checkid").val();
alert(Name);
$.ajax({
type:"POST",
url:"home/checkname/",
data:'{UserName:Name}',
contentType:"application/json;charset=utf-8",
dataType:"json",
success:OnSuccess,
failure:function(response){
alert(Name);
}
});
}
0
Rajeesh Menoth10y ago
Hi,

First check your url in ajax and another use data: "{ UserName: '" + Name + "' }" Instead of data: '{ UserName: Name }'
0
Ramesh Palaniappan10y ago
1. [WebMethod(EnableSession=true)]
2. publicstringcheckname(stringUserName)
3. {
4. SqlConnectioncon=newSqlConnection(s);
5. SqlCommandcmd=newSqlCommand("selectUserNameFromtbl_LoginwhereUserName=@Name",con);
6. cmd.Parameters.AddWithValue("@Name",UserName);
7. con.Open();
8. SqlDataReaderd=cmd.ExecuteReader();
9. if(d.HasRows)
10. {
11. return"fine";
12. }
13. else
14. {
15. return"****";
16. }
17. }
0

Bikesh Srivastava10y ago

Simply you can use remote validation in MVC.

I have written article on that./

http://www.c-sharpcorner.com/article/remote-validation-in-mvc-5-to-check-if-username-and-email-id-exists/

aditya immadi10y ago

no sir still not working..and i inspect the age there is no errors..

Manas Mohapatra10y ago

Try with below code:

function check() {
var Name = $("#checkid").val();
var jsonData = { "UserName": $("#checkid").val() };
alert(Name);
$.ajax({
type: "POST",
url: "home/checkname/",
data: JSON.stringify(jsonData),
contentType: "application/json; charset=utf-8",
dataType: "json",
success: OnSuccess,
failure: function (response) {
alert(Name);
}
});
}

Controller Action

[AllowAnonymous]
[HttpPost]
public string checkname(string UserName)
{
}

Note: Still you are getting please enable developer tool in your browser and then share the error details.

aditya immadi10y ago

i cant find any bug(as per my knowledge) in that code.can you please refer that code once again .i cross checked everything .

Thanks and Regards

Salman Beg10y ago

then i think in the ajax called you used thisurl: "home/checkname/" and that's not calling properly.

Please check it at your end.

thanks.

aditya immadi10y ago

i tried that on sir,but it is not hitting.i cross check every spell check and id check .i dont understand what where i ve done wrong

Salman Beg10y ago

Hi.

Goto your Controller and write like this,

[HttpPost]

[AllowAnonymous]

public string checkname(string UserName)

{

}

Thanks.

Rajeesh Menoth10y ago

Hi,

Add [HttpPost] in your code.

Try this code :

[AllowAnonymous]
[HttpPost]
public string checkname(string UserName)
{
SqlConnection con = new SqlConnection(s);
SqlCommand cmd = new SqlCommand("select UserName From tbl_Login where UserName=@Name", con);
cmd.Parameters.AddWithValue("@Name", UserName);
con.Open();
SqlDataReader d = cmd.ExecuteReader();
if (d.HasRows)
{
return "fine";
}
else
{
return "****";
}
}

Reference :

http://www.davidhayden.me/blog/asp.net-mvc-4-allowanonymous-attribute-and-authorize-attribute