|
Subject:
|
Could not find stored procedure 'sp_Polls_GetCurre
|
|
Posted By:
|
jblp
|
Post Date:
|
9/18/2003 1:14:59 AM
|
Could not find stored procedure 'sp_Polls_GetCurrentQuestionID'.
Where should this file be?
I cant seem to find it in the project.
vb.net 2003
System.Data.SqlClient.SqlException: Could not find stored procedure 'sp_Polls_GetCurrentQuestionID'.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
any ideas?
thanks in advance.
~J
|
|
Reply By:
|
developerz
|
Reply Date:
|
9/18/2003 6:10:28 AM
|
In the C# version it is in the Polls.Data project - in the Question.cs file found in this code:
public int GetCurrentID()
{
int numAffected;
// create the parameters
SqlParameter[] parameters = { new SqlParameter("@QuestionID", SqlDbType.Int, 4) };
parameters[0].Direction = ParameterDirection.Output;
// run the procedure
RunProcedure("sp_Polls_GetCurrentQuestionID", parameters, out numAffected);
return (int)parameters[0].Value;
}
|
