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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ReportViewer: A data source instance has not been supplied for the data source 0
What's wrong with the SqlParameter? 5
Program crashing on conversion error 1
Why is this not this cmd.Parameters.AddWithValue working 3
Populating a gridview (.net 2.0) using objectdatasource 3
System.ApplicationError in Data access class 6
most puzzle question 1 about sqlparameters.My question is following the ///.thank you. 2
Update & Insert in ADO.NET 1

Back
Top