Can Anybody Tell Me Why The Following Stored Procedure Is Not Inserting Into My Database Table?....

ALTER PROCEDURE AddListAndReturnNewIDValue (

@EditorId int,@CategoryID int,

@ListTitle nvarchar(50),@Blurb nvarchar(250),

@FileName nvarchar(50),@ByLine nvarchar(50),

@HTMLCopy nvarchar(MAX),@MainStory bit,

@MainStoryImageFile nvarchar(50),@Publish bit,

@PublishDate smalldatetime,

@ListId int OUTPUT

)

AS

-- Insert the record into the database

INSERT INTO shortlist (EditorId,CategoryID,ListTitle,Blurb,FileName,ByLine,HTMLCopy,MainStory,MainStoryImageFile,Publish,PublishDate)

VALUES (@EditorID,@CategoryID,@ListTitle,@Blurb, @FileName, @ByLine, @HTMLCopy, @MainStory, @MainStoryImageFile,@Publish,@PublishDate)

-- Read the just-inserted ProductID into @NewProductID

SET @ListId = SCOPE_IDENTITY()

 

here is the sqlDataSource

<asp:SqlDataSource

id="srcShortList"

ConnectionString="<%$ ConnectionStrings:ShortList %>"

SelectCommand="SELECT Id,EditorId,CategoryID,ListTitle,Blurb,FileName, ByLine, HTMLCopy, MainStory, MainStoryImageFile, Publish,PublishDate,Date,Deleted FROM shortlist"

InsertCommand="AddProductAndReturnNewProductIDValue"SelectCommandType="StoredProcedure"

UpdateCommand="UPDATE shortlist SET CategoryID=@CategoryID,ListTitle=@ListTitle,Blurb=@Blurb,ByLine=@ByLine,HTMLCopy=@HTMLCopy,MainStory=@MainStory,Publish=@Publish,PublishDate=@PublishDate WHERE Id=@Id"

Runat="server" >

<SelectParameters>

<asp:QueryStringParameter

Name="Id"

QueryStringField="Id" />

</SelectParameters>

 

</asp:SqlDataSource>