sql - 必须声明标量变量“@PaperID”

Question

 <asp:SqlDataSource runat="server" ID="sdsFormViewPaper"
        ConnectionString="<%$ConnectionStrings:CPMS%>"
        OldValuesParameterFormatString="original_{0}" 
        OnInserted="sdsFormViewPaper_Inserted"
        SelectCommand="SELECT *
                         FROM Paper, Author
                        WHERE Paper.AuthorID = Author.AuthorID
                        ORDER BY PaperID;"
        InsertCommand="INSERT
                         INTO Paper
                            (
                              Active,
                              FilenameOriginal,
                              Filename,
                              Title,
                              Certification,
                              NotesToReviewers,
                              AnalysisOfAlgorithms,
                              Applications,
                              Architecture,
                              ArtificialIntelligence,
                              ComputerEngineering,
                              Curriculum,
                              DataStructures,
                              Databases,
                              DistanceLearning,
                              DistributedSystems,
                              EthicalSocietalIssues,
                              FirstYearComputing,
                              GenderIssues,
                              GrantWriting,
                              GraphicsImageProcessing,
                              HumanComputerInteraction,
                              LaboratoryEnvironments,
                              Literacy,
                              MathematicsInComputing,
                              Multimedia,
                              NetworkingDataCommunications,
                              NonMajorCourses,
                              ObjectOrientedIssues,
                              OperatingSystems,
                              ParallelProcessing,
                              Pedagogy,
                              ProgrammingLanguages,
                              Research,
                              Security,
                              SoftwareEngineering,
                              SystemsAnalysisAndDesign,
                              UsingTechnologyInTheClassroom,
                              WebAndInternetProgramming,
                              Other,
                              OtherDescription
                            )
                       VALUES
                            (
                              @Active,
                              @FilenameOriginal,
                              @Filename,
                              @Title,
                              @Certification,
                              @NotesToReviewers,
                              @AnalysisOfAlgorithms,
                              @Applications,
                              @Architecture,
                              @ArtificialIntelligence,
                              @ComputerEngineering,
                              @Curriculum,
                              @DataStructures,
                              @Databases,
                              @DistanceLearning,
                              @DistributedSystems,
                              @EthicalSocietalIssues,
                              @FirstYearComputing,
                              @GenderIssues,
                              @GrantWriting,
                              @GraphicsImageProcessing,
                              @HumanComputerInteraction,
                              @LaboratoryEnvironments,
                              @Literacy,
                              @MathematicsInComputing,
                              @Multimedia,
                              @NetworkingDataCommunications,
                              @NonMajorCourses,
                              @ObjectOrientedIssues,
                              @OperatingSystems,
                              @ParallelProcessing,
                              @Pedagogy,
                              @ProgrammingLanguages,
                              @Research,
                              @Security,
                              @SoftwareEngineering,
                              @SystemsAnalysisAndDesign,
                              @UsingTechnologyInTheClassroom,
                              @WebAndInternetProgramming,
                              @Other,
                              @OtherDescription
                            );
                       SELECT @PaperID = SCOPE_IDENTITY();"
        UpdateCommand="UPDATE Paper
                          SET Active = @Active,
                              FilenameOriginal = @FilenameOriginal,
                              Filename = @Filename,
                              Title = @Title,
                              Certification = @Certification,
                              NotesToReviewers = @NotesToReviewers,
                              AnalysisOfAlgorithms = @AnalysisOfAlgorithms,
                              Applications = @Applications,
                              Architecture = @Architecture,
                              ArtificialIntelligence = @ArtificialIntelligence,
                              ComputerEngineering = @ComputerEngineering,
                              Curriculum = @Curriculum,
                              DataStructures = @DataStructures,
                              Databases = @Databases,
                              DistanceLearning = @DistanceLearning,
                              DistributedSystems = @DistributedSystems,
                              EthicalSocietalIssues = @EthicalSocietalIssues,
                              FirstYearComputing = @FirstYearComputing,
                              GenderIssues = @GenderIssues,
                              GrantWriting = @GrantWriting,
                              GraphicsImageProcessing = @GraphicsImageProcessing,
                              HumanComputerInteraction = @HumanComputerInteraction,
                              LaboratoryEnvironments = @LaboratoryEnvironments,
                              Literacy = @Literacy,
                              MathematicsInComputing = @MathematicsInComputing,
                              Multimedia = @Multimedia,
                              NetworkingDataCommunications = @NetworkingDataCommunications,
                              NonMajorCourses = @NonMajorCourses,
                              ObjectOrientedIssues = @ObjectOrientedIssues,
                              OperatingSystems = @OperatingSystems,
                              ParallelProcessing = @ParallelProcessing,
                              Pedagogy  = @Pedagogy,
                              ProgrammingLanguages = @ProgrammingLanguages,
                              Research = @Research,
                              Security = @Security,
                              SoftwareEngineering = @SoftwareEngineering,
                              SystemsAnalysisAndDesign  = @SystemsAnalysisAndDesign,
                              UsingTechnologyInTheClassroom = @UsingTechnologyInTheClassroom,
                              WebAndInternetProgramming = @WebAndInternetProgramming,
                              OtherDescription = @OtherDescription,
                              Other = @Other
                        WHERE PaperID = @original_PaperID;"
        DeleteCommand="DELETE
                         FROM Paper
                        WHERE PaperID = @original_PaperID;">

必须声明标量变量“@PaperID”。说明：执行当前 Web 请求期间发生未处理的异常。请查看堆栈跟踪以获取有关错误及其源自代码的位置的更多信息。

异常详细信息：System.Data.SqlClient.SqlException：必须声明标量变量“@PaperID”。

源错误：

在执行当前 Web 请求期间生成了未处理的异常。可以使用下面的异常堆栈跟踪来识别有关异常起源和位置的信息。

堆栈跟踪：

[SqlException (0x80131904): 必须声明标量变量“@PaperID”。]
System.Data.SqlClient.SqlConnection.OnError(SqlException 异常，

标签： sqlasp.netsql-server

Answer 1

在 InsertCommand 中添加以下行：

Declare @PaperID INT -- adding this would resolve your exception

SELECT @PaperID = SCOPE_IDENTITY();