Get The OUTPUT Paramete Value from SP
Using Dot Net using asp.net. This code can be used to get the data from
database using Out parameter
Imports System.Data
Imports System.Data.SqlClient
Partial Class SP
Inherits System.Web.UI.Page
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As
System.EventArgs)
Handles Button1.Click
Try
Dim Con As New SqlConnection
Con.ConnectionString =
"Password=RR;Persist Security Info=True;
User ID=RR;Initial Catalog=RR;Data Source=RR"
Con.Open()
Dim INparam, OutPram As New
SqlParameter
INparam.Direction =
ParameterDirection.Input
INparam.SqlDbType = SqlDbType.Int
INparam.ParameterName =
"@ID"
INparam.Size = 20
INparam.Value = Textbox1.text
OutPram.Direction =
ParameterDirection.Output
OutPram.SqlDbType = DbType.String
OutPram.ParameterName =
"@Name"
OutPram.Size = 200
Dim com As New SqlCommand
com.Connection = Con
com.CommandType =
CommandType.StoredProcedure
com.CommandText =
"spGetOutput"
com.Parameters.Add(INparam)
com.Parameters.Add(OutPram)
com.ExecuteNonQuery()
Label1.Text = OutPram.Value()
Catch ex As Exception
End Try
End Sub
End Class
