0

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()
                        );
                }
            }
PaulR
  • 23
  • 1
  • 7

0 Answers0