Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROCEDURE [dbo].[RMVerifyUser]
- @UserName as varchar(40)
- ,@Password as binary(42) OUTPUT
- ,@ClerkID as uniqueidentifier OUTPUT
- AS
- SELECT @ClerkID = IDClerk
- ,@Password = (CONVERT(binary(8), ClkPassCode, 0)) // ClkPassCode is varchar(50) in the table.
- FROM tblClerkInfo
- WHERE ClkName = @UserName
- AND ISNULL(Canceled, 0) = 0
- RETURN
- private string retrievePassword(object userName)
- {
- string strPassword = "";
- //uidClerkID = new Guid();
- connect.Open();
- try
- {
- SqlCommand command = new SqlCommand("RMVerifyUser");
- command.Connection = connect;
- command.CommandType = CommandType.StoredProcedure
- SqlParameter retUserName = new SqlParameter("@UserName", userName); // userName is passed in from another method.
- retUserName.ParameterName = "@UserName";
- retUserName.Value = userName;
- command.Parameters.Add(retUserName);
- SqlParameter retPassword = new SqlParameter("@Password", strPassword); // I suspect the error is occurring somewhere in the declaration/definition of this parameter.
- retPassword.ParameterName = "@Password";
- retPassword.Direction = ParameterDirection.Output;
- retPassword.DbType.Equals(DbType.String);
- retPassword.Size = 50;
- retPassword.Value = strPassword;
- command.Parameters.Add(retPassword); // ClkPassCode is nvarchar(50) in the data table.
- SqlParameter retUserID = new SqlParameter("@ClerkId", uidClerkID); // uidClerkID is a property in a separate class, but I also tried - uidClerkID = new Guid() - in this method. Same error thrown.
- retUserID.ParameterName = "@ClerkId";
- retUserID.Direction = ParameterDirection.Output;
- retUserID.Value = uidClerkID;
- command.Parameters.Add(retUserID);
- command.ExecuteNonQuery();
- uidClerkID = Guid.Parse(retUserID.Value.ToString());
- if (strPassword == DBNull.Value.ToString())
- {
- ReferenceEquals(strPassword, null);
- }
- else
- {
- strPassword = retPassword.Value.ToString();
- return strPassword;
- }
- }
- catch (Exception ex)
- ...
Add Comment
Please, Sign In to add comment