What's Wrong With This Code.........

  • Thread starter Thread starter Jim Douglas
  • Start date Start date
J

Jim Douglas

All of a sudden I can't get this to work? I am connecting to the database
and executing the storedProcedure but have no results returned. If I execute
from SQLServer query tool it returns results fine? I am using the Microsoft
DataAccess Block V1.









public DataSet GetAftaValidateUser(string parmUserID, string
parmUserPassword)

{


string connectionString = this.devConnectionString;

DataSet myDS;


// Populate our DataSet

myDS = SqlHelper.ExecuteDataset(connectionString,

CommandType.StoredProcedure,

"p_ValidateUserParms",

new SqlParameter("@pEmail",64),

new SqlParameter("@pPassword",16));



// Return results

return myDS;

}
 
Where do you set the values of the parameters? Is 64 your Email and 16
your password? It seems that you should have the email address and
password instead of 64 and 16.
 
Back
Top