TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
hadoop hadoop
NA
159
50.3k
get the output parameters of stored procedure using methods
Jul 7 2015 11:15 AM
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.
Reply
Answers (
3
)
C# String Replace , to "," for .csv output
How to diplaying only time in DateTimePicker from Database