SQL Server - Devolver Datos a un programa externo

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[sp_GlassCalulator_FX300PW]

	@Width DECIMAL (18,5),

	@Height DECIMAL (18,5),

	@ConfigId VARCHAR(10)

AS

BEGIN

DECLARE @figure int;

DECLARE @dbase decimal(18,4);

DECLARE @dleft  decimal(18,4);

begin try

	 SET @figure = 0;

	 SET @dbase = 0;

	 SET @dleft = 0;

	 if (@ConfigId = 'FX300PX')

	 begin

		set @figure = 0;

		SET @dbase = @Width - 2.5 + 0.125

		SET @dleft = @Height -2.5 + 0.125

	 end

 end try

 begin catch

 end catch

 END

DataSet ds = new DataSet();

SqlParameter[] parameters = new SqlParameter[]

{

	new SqlParameter("@Width", width),

	new SqlParameter("@Height", height),

	new SqlParameter("@ConfigId", configId),

};

using (SqlConnection conn = new SqlConnection("ConenctionString"))

{

	using (SqlCommand cmd = new SqlCommand("sp_GlassCalulator_FX300PW", conn))

	{

		cmd.CommandType = CommandType.StoredProcedure;

		cmd.Parameters.AddRange(parameters);

		conn.Open();

		using (SqlDataAdapter da = new SqlDataAdapter(cmd))

		{

			da.Fill(ds);

		}

	}

}