how to retrieve out parameter of a stored procedure in aspx page

Question

1.00/5 (1 vote)

See more:

hello sir.
i have a stored procedure which returns string as a out parameter. that string is
print 'Records are successfully inserted'
i want to print this message on a label in aspx page.
how to do this. any body plz help me.
thanking you.

Posted 29-Dec-10 17:38pm

sathish.jampala

Add a Solution

2 solutions

Solution 1

hi See this link
http://www.daniweb.com/forums/thread106200.html

http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson07.aspx

Posted 29-Dec-10 17:46pm

priyapavithra

Comments

Sandeep Mewara 30-Dec-10 0:38am

Ok, I was about to write why the downvote. I can see now, why it was. Question asked for parameter return value from stored procedure to code and not code to SP.

Yet, I am compensating as you are new and trying to help. Keep going. :)

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Avachat Nikhil · Accepted Answer · 2010-12-29T17:49:00

Solution 2

Hi Sathish,
below are steps to retrieve value from outputparameter.

1. set direction of commandparameter to output.
2. execute command
3. label.text = commandparameter.value.toString().

Posted 29-Dec-10 17:49pm

Avachat Nikhil

Comments

sathish.jampala 29-Dec-10 23:57pm

thankyou sir.

sathish.jampala 30-Dec-10 14:18pm

hello sir. i tried what ever u say.
but dataset is displaying empty