use the following stored procedure to get the UserID. If there is a matching Password and user name then UserId > 0 if not then UserID = 0

CREATE PROCEDURE dbo.spValidateUser(

@MyUserName varchar(50),
@MyPasswordID varchar(50)
)

AS

SELECT UserID FROM UserAccounts
WHERE UserName = @MyUserName
AND PasswordID = @MyPasswordID
GO

And the code is:

SqlCommand mySelect = new SqlCommand("spValidateUser", sqlConnection1);
sqlDataAdapter1.SelectCommand = mySelect;
mySelect.CommandType = CommandType.StoredProcedure;
SqlParameter myParameter = null;

SqlParameter myParameter1 = myParameter1;
//Set parameters for stored procedure

myParameter = mySelect.Parameters.Add("@MyUserName", SqlDbType.VarChar, 50);
myParameter.Value = txtUserName;
myParameter = mySelect.Parameters.Add("@MyPasswordID", SqlDbType.VarChar, 50);
myParameter.Value = txtPassword;

sqlConnection1.Open();

//Get the value
int returnValue = (int) mySelect.ExecuteScalar();
string strA;
//Convert from int to string
strA = Convert.ToString(returnValue);
lblMessage.Text = Convert.ToString(returnValue);

I get the following message:

Exception Details: System.InvalidCastException: Object must implement IConvertible.

Source Error:


Line 186:
Line 187: //Get the value
Line 188: int returnValue = (int) mySelect.ExecuteScalar();
Line 189: string strA;
Line 190: //Convert from int to string


Could you please tell me what im doing wrong???

Regards,

Nick