Error Information:
A parameter with name '@RETURN_VALUE' is not contained by this Parameters collection.
my Code:
Code: Select all
Dim myConn As UniConnection = New UniConnection("Provider=SQL Server;User Id=sa;Password=hhzstsll;Data Source=IBM008;Database=pubs")
myConn.Open()
Dim includeReturnValueParameter As Boolean = False
Dim spName As String = "byroyalty"
Dim cmd As UniCommand = New UniCommand(spName, myConn)
Dim discoveredParameters() As UniParameter
cmd.CommandType = CommandType.StoredProcedure
UniCommandBuilder.DeriveParameters(cmd)
If Not includeReturnValueParameter Then
cmd.Parameters.RemoveAt(0)
End If
discoveredParameters = New UniParameter(cmd.Parameters.Count - 1) {}
cmd.Parameters.CopyTo(discoveredParameters, 0)
MS SQL Server 2005 DB:pubs
VS2010 10.0.3.3019.1 RTMRel
[/quote]