Solved

return stored procedure output value in vb.net

Posted on 2009-05-06
1
799 Views
Last Modified: 2013-11-26
I have seen the examples on returning parameters in stored  procedures that use the OUTPUT value.  I am unclear on the syntax however for returning the actual varchar value that is returned by the stored procedure.  It seems the examples return a value of 0 or 1.  How can I call the stored procedure with it's three paramaters and return the varchar value that is returned when the stored procedure is ran into a variable?  I thought using the executescalar method would accomplish this but it does not seem to be working.  Does anyone have any sample code I can look at?  Please advise.
0
Comment
Question by:v4seasons
1 Comment
 
LVL 4

Accepted Solution

by:
cauos earned 250 total points
ID: 24312080
this code snippet below show how to create a stored procedure and call it from asp.net page
Sql Stored Procedure
Create PROCEDURE [dbo].[RS_TestGetUserName] 
 
@UserID int,
@username nvarchar(50) output
AS
begin
select @username = user_username from users where userid=@Userid
end
-------------------
VB.net code calling the stored procedure 
Dim constr As String = ConfigurationManager.ConnectionStrings("ConnStr").ConnectionString
            Dim con As New SqlConnection(constr)
            Dim cmd As New SqlCommand("RS_TestGetUserName", con)
            cmd.CommandType = Data.CommandType.StoredProcedure
            cmd.Parameters.AddWithValue("@UserID", 38107)
            cmd.Parameters.Add("@username", Data.SqlDbType.NVarChar, 50)
            cmd.Parameters("@username").Direction = Data.ParameterDirection.Output
            con.Open()
 
            cmd.ExecuteNonQuery()
            Dim username As String = cmd.Parameters("@username").Value.ToString()
            con.Close()

Open in new window

0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question