Populating Labels From A Query

 

I have a page that is part of a 5 page wizard.  The wizard gathers data for a claim filter.  The second page is laid out with four labels at the top

Filter Name:  <filterName>     -- filterName_L
Filter Description: <filterDescription>    -- filterDescription_L
Filter Data Source: <filterDataSource>    -- filterDataSource_L
Filter Purpose: <filterPurpose>     -- filterPurpose_L

--
I have written an sp to populate these four label.Text values. I want to populate them on page load. 

Two questions. How do I get four output values out of the sp?  Is there a better way to do this than an sp?

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

 


-- =============================================
-- Author:  <Author,,Name>
-- ALTER  date: <ALTER  Date,,>
-- Description: <Description,,>
-- =============================================
ALTER   PROCEDURE [dbo].[a_spNewFilter_Step1_Summary]
 -- Add the parameters for the stored procedure here
 @filterID int ,

 @filtername varchar(100) OUTPUT,
 @filterdescription varchar(250) OUTPUT,
 @filterOwnerID int OUTPUT,
 @filterDataSourceID INT OUTPUT,
 @filterPurposeID int OUTPUT

AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
SET NOCOUNT ON;

--DECLARE @FilterID int

--SET @filterID = 14

SELECT 
 filterIsComplete,
 filterCreateDate,
 filterStep1Complete,
 filterName,
 filterDescription,
 das.AuditorFirstName + ' ' + das.AuditorLastName as FilterOwner,
 dfds.filterDataSource,
 dfp.filterPurpose
FROM a_factSamplingFilter_2 fsf
INNER JOIN dbo.a_dimFilterDataSource dfds
ON dfds.filterDataSourceID = fsf.filterDataSourceID
INNER JOIN dbo.a_dimAuditStaff das
ON das.AuditorID = fsf.filterOwnerID
INNER JOIN dbo.a_dimfilterPurpose dfp
ON dfp.filterPurposeID = fsf.filterPurposeID
WHERE filterID = @filterID
GROUP BY
 filterIsComplete,
 filterCreateDate,
 filterStep1Complete,
 filterName,
 filterDescription,
 das.AuditorFirstName,
 das.AuditorLastName,
 dfds.filterDataSource,
 dfp.filterPurpose

 

END

 

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO


----


protected void Page_Load(object sender, EventArgs e)
    {

        int filterID = int.Parse(Request.QueryString["filterID"]);  /// grab the filterID from the URL query string

        string connectionString = WebConfigurationManager.ConnectionStrings["DDT"].ConnectionString;
        SqlConnection con = new SqlConnection(connectionString);

        SqlCommand cmd = new SqlCommand("a_spNewFilter_Step1_Summary", con); // get the values from filter setup step1
        cmd.CommandType = CommandType.StoredProcedure;

        cmd.Parameters.Add(new SqlParameter("@FilterID", SqlDbType.Int)); // using the filterID created in step1
        cmd.Parameters["@FilterID"].Value = filterID;

        cmd.Parameters.Add(new SqlParameter("@FilterName", SqlDbType.VarChar, 100));
        cmd.Parameters["@FilterName"].Direction = FilterName_TB.Text;

        cmd.Parameters.Add(new SqlParameter("@FilterDescription", SqlDbType.VarChar, 255));
        cmd.Parameters["@FilterDescription"].Direction = ParameterDirection.Output;

        cmd.Parameters.Add(new SqlParameter("@FilterOwner", SqlDbType.VarChar,50));
        cmd.Parameters["@FilterOwner"].Direction = ParameterDirection.Output;

        cmd.Parameters.Add(new SqlParameter("@FilterDataSource", SqlDbType.VarChar,50));
        cmd.Parameters["@FilterDataSource"].Direction = ParameterDirection.Output;

        cmd.Parameters.Add(new SqlParameter("@FilterPurpose", SqlDbType.VarChar,100));
        cmd.Parameters["@FilterPurpose"].Direction = ParameterDirection.Output;

        con.Open();

        try
        {
            cmd.ExecuteNonQuery();
        }
        finally
        {
            con.Close();
        }

        ///get name, description, owner, datasource, purpose

 

    }