my sp working fine in sql but when i m calling it my c# it allways returing 0 .
please help me.
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
[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;
}