how to access and display an output parameter

  • Thread starter Thread starter DC Gringo
  • Start date Start date
D

DC Gringo

I would like to know how to set an output parameter to a variable and output
it on a web form:

This didn't work:
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@gcLatest", System.Data.SqlDbType.Int,
4, System.Data.ParameterDirection.Output, False, CType(0, Byte), CType(0,
Byte), "", System.Data.DataRowVersion.Current, ???THEVARIABLE???))

<% = THEVARIABLE %>
 
SqlSelectCommand.Parameters.Add("@gsLatest", SqlDbType.Int, 4).Direction =
ParameterDirection.Output
....
SqlSelectCommand.ExecuteNonQuery()
....
Dim i As Integer = CInt(SqlSelectCommand.Parameters("@gsLatest").Value)

Greg
 
DC Gringo said:
I would like to know how to set an output parameter to a variable and
output it on a web form:

This didn't work:
Me.SqlSelectCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@gcLatest",
System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Output,
False, CType(0, Byte), CType(0, Byte), "",
System.Data.DataRowVersion.Current, ???THEVARIABLE???))

<% = THEVARIABLE %>
Click to expand...

To access an output parameter:

Dim myOutPar As string =
Me.SqlSelectCommadn1.Parameters("@gcLates").Value.ToString()

Than you can use your variable as you like, for example in a Label:

Me.myLabel.Text = myOutPar
 
Back
Top