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

[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 GetAftaValidate User(string parmUserID, string
parmUserPasswor d)

{


string connectionStrin g = this.devConnect ionString;

DataSet myDS;


// Populate our DataSet

myDS = SqlHelper.Execu teDataset(conne ctionString,

CommandType.Sto redProcedure,

"p_ValidateUser Parms",

new SqlParameter("@ pEmail",64),

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



// Return results

return myDS;

}


--
Jim Douglas

[Chris Dunaway]

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

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.