Stored Procedure Works But Nothing Returned?

Hello,





I have the following stored prod in SQL server:





CREATE PROC spValidateUserIdAndPassword





@UserIdvarchar(50),


@Passwordvarchar(50)


AS


SELECT tblAdvertisers.UserID, tblAdvertisers.Password


FROM tblAdvertisers


WHERE ((tblAdvertisers.UserID = @UserId) AND (tblAdvertisers.Password = @Password))








I can run it in Query Analyzer and it returns one record as it should. I want it in ASP.NET to return the amount of rows that are effected, e.g that the login is correct.





The code I have is:








public bool ValidateUserIdAndPassword(string userId, string password)


{


sqlCommand.CommandType = CommandType.StoredProcedure;


//the name of the stored procedure


sqlCommand.CommandText = "spValidateUserIdAndPassword";





SqlParameter myParam;





//add the param's to the SP





//userId information for the user


myParam = new SqlParameter("@UserId", SqlDbType.VarChar, 50);


myParam.Value = CStr(userId);


sqlCommand.Parameters.Add(myParam);





//password information for the user


myParam = new SqlParameter("@Password", SqlDbType.VarChar, 50);


myParam.Value = CStr(password);


sqlCommand.Parameters.Add(myParam);





try


{


int rows = sqlCommand.ExecuteNonQuery();





if(rows == 1)


return true;


else


return false;





}


catch(System.Exception er)


{


//for design time error checking


return false;


}











This returns -1...





Please help me





Kind Regards








KitkatRobins :-)