asked on
'Sql Command
mSqlCommand = New SqlCommand
mSqlCommand.Connection = YourConnection
mSqlCommand.CommandTimeout = iTimeout
mSqlCommand.CommandText = yourSP
mSqlCommand.CommandType = CommandType.StoredProcedure
Dim paramArr As SqlParameter() = { _
New SqlParameter("@ParameterInput", SqlDbType.VarChar, 2), _
New SqlParameter("@ParameterOutput1", SqlDbType.VarChar, 4), _
New SqlParameter("@ParameterOutput2", SqlDbType.VarChar)
}
param(0).Value = yourInputValue
param(1).Direction = ParameterDirection.Output
param(2).Direction = ParameterDirection.Output
'Add Parameters
For Each param As SqlParameter In paramArr
mSqlCommand.Parameters.Add(param)
Next
'Exec NonQuery
mSqlCommand.ExecuteNonQuery()
OutputValue1 = Convert.ToString(mSqlCommand.Parameters"("@ParameterOutput1).Value)
OutputValue2 = Convert.ToString(mSqlCommand.Parameters"("@ParameterOutput2).Value)
The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications
TRUSTED BY
After executing evaluate that parameter value.