asked on 5/16/2011

Accessing Stored Procedure Return Value From .NET

Can somone explain to me the simplest most effective way of accessing the return value from a stored procedure using .Net(vb)?

I want to display it in a label on a page

Return @@identity

ASP.NET Microsoft SQL Server Microsoft SQL Server 2008

Last Comment

5/25/2011

ASKER CERTIFIED SOLUTION

Dirk Haest

5/16/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Imran Javed Zia

5/16/2011

Hi,
You can use following:
SqlCommand cmd = new SqlCommand();
//please command Initialization

object val = cmd.ExecuteScalar();
if (val != null && val != DBNull.Value)
lbl.Text = val.ToString();

or

SqlCommand cmd = new SqlCommand();
//please command Initialization

object val = cmd.ExecuteScalar();
if (val != null && val != DBNull.Value)
return val.ToString();
else
return string.Empty;

Thanks

Alpesh Patel

5/16/2011

Hi,
You can use following:

If inserting a new row then use Scope_Identity()

SqlCommand cmd = new SqlCommand();
            object val = cmd.ExecuteScalar();
            if (val != null && val != DBNull.Value)
                lbl.Text = val.ToString();

or

SqlCommand cmd = new SqlCommand();
            //please command Initialization

            object val = cmd.ExecuteScalar();
            if (val != null && val != DBNull.Value)
                return  val.ToString();
            else
                return string.Empty;

Open in new window

Anthony Perkins

5/16/2011

edjones1,

Since you just need to get the RETURN parameter, you cannot use the ExecuteScalar method, go with the ExecuteNonQuery method instead as suggested by Dhaest (no points please).

5/25/2011

ASKER

The link was really helpful, thanks