Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
why ExecuteScalar allways returing 0 ?
rajeev kumar
Jun 30 2017 5:44 AM
194
Reply
hello sir,
my sp working fine in sql but when i m calling it my c# it allways returing 0 .
please help me.
here is my sql sp
CREATE PROCEDURE test
@Email as varchar(50),
@Passwords as varchar(50)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @Exists INT
IF EXISTS(SELECT UserID,Email,Passwords,f_name,l_name FROM tbl_Register WHERE Email=@Email AND Passwords=@Passwords)
BEGIN
SET @Exists = 0
END
ELSE
BEGIN
SET @Exists = 1
END
RETURN @Exists
END
and here is my c# methods
[WebMethod]
[ScriptMethod(UseHttpGet = false, ResponseFormat = ResponseFormat.Json)]
public string User_login(usrlogin ulog) // user login functions
{
int Exists= 0;
SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["con"].ToString());
SqlCommand com = new SqlCommand("test", con);
com.CommandType = CommandType.StoredProcedure;
SqlParameter p1 = new SqlParameter("Email", ulog.Email);
SqlParameter p2 = new SqlParameter("Passwords", ulog.Passwords);
com.Parameters.Add(p1);
com.Parameters.Add(p2);
con.Open();
Exists = Convert.ToInt32(com.ExecuteScalar());
string IsValidate = string.Empty;
switch (Exists)
{
case 1:
IsValidate = "go";
break;
case 0:
IsValidate = "iup";
break;
}
return IsValidate;
}
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
How to create dynamic word document in .Net Core (MVC)
How can we work in .Net Windows application with mariadb .?