|
Subject:
|
Stored procedure IConvertible
|
|
Posted By:
|
nk15
|
Post Date:
|
10/30/2004 7:07:12 AM
|
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
|
|
