Expand|Select|Wrap|Line Numbers
- PROCEDURE validlogin
- @uname nchar(30),
- @pass nchar(100),
- @valid int OUTPUT
- AS
- IF EXISTS(SELECT * FROM Users WHERE User_name = @uname AND Password = @pass)
- SELECT @valid = 1
- ELSE
- SELECT @valid = 0
- RETURN @valid
Expand|Select|Wrap|Line Numbers
- private bool UserAuthenticate(string uname, string pass)
- {
- int validateresult;
- string hashedpwd = EncodePassword(pass);
- //query the username and password
- sqlSelectCommand1.CommandType = CommandType.StoredProcedure;
- sqlSelectCommand1.CommandText = "validlogin";
- sqlSelectCommand1.Parameters.Add(new SqlParameter("@uname", SqlDbType.NChar, 30));
- sqlSelectCommand1.Parameters["@uname"].Value = uname;
- sqlSelectCommand1.Parameters.Add(new SqlParameter("@pass", SqlDbType.NChar, 30));
- sqlSelectCommand1.Parameters["@pass"].Value = hashedpwd;
- sqlSelectCommand1.Parameters.Add(new SqlParameter("@valid", SqlDbType.NChar, 30));
- sqlSelectCommand1.Parameters["@valid"].Direction = ParameterDirection.Output;
- //sqlDataAdapter1.SelectCommand = sqlSelectCommand1;
- sqlConnection1.Open();
- validateresult = Convert.ToInt32(sqlSelectCommand1.ExecuteScalar());
- sqlConnection1.Close();
- if (validateresult == 1)
- {
- return true;
- }
- else
- {
- return false;
- }
- }