Trying to figure out how to resolve this error? The bolded part is where the error shows in the browser message.
I have that parameter in the stored procedure and I see it here so what am I missing?
Create procedure [Web].[usp_GetVideoSelections] (
@UserID varchar(20)
)
AS
Select
UserID, CameraName
from
Web.VideoPortalSelections
where UserID = @UserID
using (DatabaseConnection db = Shared.GetDatabaseConnection())
{
using (StoredProcedure usp = new StoredProcedure(Shared.ProjectName, "Web.usp_GetVideoSelections"))
{
usp.Parameters["@UserID"] = UserID;
usp.Parameters["@CameraName"] = CameraName;
**using (SqlDataReader reader = usp.ReadData(db))**
do
{
while (reader.Read())
LoadVideoSelections(reader["CAMERANAME"].ToString().Trim());
}
while (reader.NextResult()
);
}
}