• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 811
  • Last Modified:

return stored procedure output value in vb.net

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
v4seasons
Asked:
v4seasons
1 Solution
 
cauosCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now