3
Reply

get the output parameters of stored procedure using methods

hadoop hadoop

hadoop hadoop

Jul 7 2015 11:15 AM
433
I've many stored procedures in my project. Stored procedures are for selecting data, updating data , inserting data etc. Some of the stored procedures have output parameters too.
For eg.
CREATE PROCEDURE [dbo].[proc_sales_profiling]
@p_SalesPerson varchar(50),
@p_SalesTarget money OUTPUT
AS
SET NOCOUNT ON;
SELECT @p_SalesTarget = SalesTarget, @p_SalesProfile = SalesProfile
FROM Sales.SalesPerson
WHERE LastName = @p_SalesPerson;
 
Now how to write C# method to execute such procedures having multiple input parameters and output parameters. Also how to implement such methods in other methods in Data Access Layer. 

Answers (3)