Output from stored proc to web page C#

[AGus01]

Hi I wish to return the Output from a Delete stored Proc to a web page and I am new to ASP.NET 2.0 and c#. The SP runs fine I just cannot get the return value of the Ouput parameter the moment. The method SqlDataSource3_Deleted is triggered however it always returns the Default value of the DeleteParameter and not the actual value returned.

     <asp:GridView ID="GridView1"  DataSourceID="SqlDataSource3" AutoGenerateDeleteButton="true" AlternatingRowStyle-BackColor="Aqua" HeaderStyle-BackColor="AntiqueWhite" 
          runat="server" DataKeyNames="DummyID" Width="375px" AutoGenerateColumns="true" AllowPaging="true" AllowSorting="true">
      </asp:GridView>
      <asp:SqlDataSource ID="SqlDataSource3" runat="server" SelectCommandType="StoredProcedure"   
      SelectCommand="up_admDistiDetails"  DeleteCommandType="StoredProcedure" DeleteCommand="up_admDeleteIndividualResellerfromDisti" ConnectionString="<%$ ConnectionStrings:ZebSorTestWeb %>">
          <SelectParameters>
               <asp:SessionParameter Direction="Input" Type="String" Name="InputTable" SessionField="strInputTable"/>
          </SelectParameters>
          <DeleteParameters>
                <asp:Parameter Name="DummyID" Type="Int32" />
               <asp:Parameter Name="MSG" Direction="Output" Type="String" DefaultValue="ThisIsATest"/> 
          </DeleteParameters>
      </asp:SqlDataSource>

In the code behind:

namespace ZebraSORAdminPages
{
    public partial class WebForm1 : System.Web.UI.Page
    {

        

        protected void Page_Load(object sender, EventArgs e)
        {
                string inputTable = Session["strInputTable"].ToString();
                string resellerDate = Session["strInputDate"].ToString();

                SqlDataSource3.Deleted += new SqlDataSourceStatusEventHandler(SqlDataSource3_Deleted);
                
            }
            
        
        void SqlDataSource3_Deleted(object sender, SqlDataSourceStatusEventArgs e)
        {
            string MSG = e.Command.Parameters["@MSG"].Value.ToString();
            DeleteMSG.Text = MSG;
        }

    } 
}

 

[jbenson001]

What is the code in your SP?

 

[AGus01]

Here is a simplified version of the Stored Proc. I can run the sp from SQL Management Studio and it works fine returning an output parameter everytime.

ALTER PROCEDURE [dbo].[up_admDeleteIndividualResellerfromDisti] 
	
	@DummyID int,
	@MSG varchar(255) OUTPUT
AS
BEGIN
	
	SET NOCOUNT ON;
	BEGIN

	DELETE FROM TblNAME Where DummyID = @DummyID
		
	IF @@ROWCOUNT > 0
	BEGIN
		SET @MSG = 'Delete was Successfull!'
	END
	ELSE
	BEGIN
		SET @MSG = 'Delete Failed!'
	END
	
	
END

 

[jbenson001]

This looks like it should work, although I don't use the datasource objects. There could be something different you need to do with them. I will see if I can whip up a quick example and test your code.

 

[AGus01]

Hi how did you get on? Has anyone else used the datasource objects in this way?

ta Angus