Ad:

C# Discussion Thread
Unsolved
Views: 4156

Nov 15th, 2008

getting value of return value of stored procedure to code behined,with patterns prace

Expand Post »

getting value of return value of stored procedure to code behined,with MicroSoft Patterns and Practices.

Hi all,

I am using Microsoft Patterns and Practices to make a database connection to my application. I am able to get the value of the OUT parameter of the stored procedure to code behind. But not able to find the way how to get the return value of a stored procedure to code behind.

Can anyone plz let me know the way....! The example code snippet is really appriciable.....!

Thanks & Regards,
(Naveen Kumar M)

naveen_arc

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

3 posts
since Nov 2008

Permalink

Nov 15th, 2008

Re: getting value of return value of stored procedure to code behined,with patterns prace

Why you don' use an UDF user defined function instead of a stored procedure

Jugortha

Reputation Points: 11

Solved Threads: 16

Junior Poster

Offline

172 posts
since Oct 2007

Permalink

Nov 16th, 2008

Re: getting value of return value of stored procedure to code behined,with patterns prace

Click to Expand / Collapse Quote originally posted by Jugortha ...

Why you don' use an UDF user defined function instead of a stored procedure

Hi,

Thanx for the reply and actually that is the clients requirement. if not i could have gone for OUT parameter.

As this is the client's requirement i could not change. So, please let me know the way.

Thanks & Regards,
(Naveen Kumar M)

naveen_arc

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

3 posts
since Nov 2008

Permalink

Nov 16th, 2008

Re: getting value of return value of stored procedure to code behined,with patterns prace

Try this link

http://www.sqlteam.com/article/store...returning-data

I think you have to mark the desired value to return with the OUTPUT keyword

Jugortha

Reputation Points: 11

Solved Threads: 16

Junior Poster

Offline

172 posts
since Oct 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in C# Forum Timeline: any idea how to assign values to specific variables

Next Thread in C# Forum Timeline: Access to a master form, from a component class

DaniWeb Message

Cancel Changes

User Name
Password