c# - 过程或函数“usp_GetVideoSelections”需要参数“@UserID”，但未提供该参数

Question

试图弄清楚如何解决这个错误？粗体部分是错误在浏览器消息中显示的位置。

我在存储过程中有那个参数，我在这里看到了，所以我错过了什么？

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()
                        );
                }
            }

标签： c#sqlasp.netsql-serverstored-procedures