Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
get the output parameters of stored procedure using methods
hadoop hadoop
Jul 7 2015 11:15 AM
433
Reply
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.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
C# String Replace , to "," for .csv output
setup .exe file start