AddSPParameter(String,SPParamDataTypes,SPParamDirections,String,String) Method
- Last UpdatedNov 06, 2025
- 1 minute read
Add a Stored Procedure Parameter to the previously added SP name. This overload allows the data type, direction, size and value of the SP parameter to be specified with enums to specify the data type and direction.
'Declaration
Public Overloads Sub AddSPParameter( _
ByVal paramName As String, _
ByVal dataType As SPParamDataTypes, _
ByVal direction As SPParamDirections, _
ByVal size As String, _
ByVal paramValue As String _
)
'Usage
Dim instance As XMLSPBuilder
Dim paramName As String
Dim dataType As SPParamDataTypes
Dim direction As SPParamDirections
Dim size As String
Dim paramValue As String
instance.AddSPParameter(paramName, dataType, direction, size, paramValue)
public void AddSPParameter(
string paramName,
SPParamDataTypes dataType,
SPParamDirections direction,
string size,
string paramValue
)
Parameters
- paramName
- The name of the new SP parameter as a string
- dataType
- The data type of the new SP parameter as a SPParamDataTypes enum
- direction
- The direction of the new SP parameter as a SPParamDirections enum
- size
- The size of the new SP parameter as a string
- paramValue
- The value of the new SP parameter as a string