Posted on: 4/11/2014 10:44:53 PM | Views : 554

I am passing the author's name to a stored procedure via a sqldatasource.  When I run the debugger, I verify the correct parameters are being passed.  There are no errors on the page.  But, the stored procedure is not running from the call from the webpage.  Here is the code, code behind, and sqldatasource:
 
protected void btnAddAuthors_Click(object sender, EventArgs e) { lblAuthorName.Text = lbAuthorList.SelectedItem.ToString(); if (lblAuthorName.Text == "Unknown") { sqlInsertAuthors.InsertParameters.Clear(); sqlInsertAuthors.InsertParameters.Add("RequestID", DbType.Int32, Request.QueryString["Requestid"]); sqlInsertAuthors.InsertParameters.Add("AuthorID", DbType.Int32, AuthorID.ToString()); } protected void authorList_SelectedIndexChanged(object sender, EventArgs e) { lblAuthorName.Text= lbAuthorList.Sele ...

Go to the complete details ...