StoredProcedureParameter Constructor (StoredProcedure, String, DataType)

Initializes a new instance of the StoredProcedureParameter class for the specified stored procedure and with the specified name and data type.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public Sub New ( _
    storedProcedure As StoredProcedure, _
    name As String, _
    dataType As DataType _
)
'Usage
Dim storedProcedure As StoredProcedure 
Dim name As String 
Dim dataType As DataType 

Dim instance As New StoredProcedureParameter(storedProcedure, _
    name, dataType)

public StoredProcedureParameter(
    StoredProcedure storedProcedure,
    string name,
    DataType dataType
)

public:
StoredProcedureParameter(
    StoredProcedure^ storedProcedure, 
    String^ name, 
    DataType^ dataType
)

new : 
        storedProcedure:StoredProcedure * 
        name:string * 
        dataType:DataType -> StoredProcedureParameter

public function StoredProcedureParameter(
    storedProcedure : StoredProcedure, 
    name : String, 
    dataType : DataType
)

Parameters

• storedProcedure
  Type: Microsoft.SqlServer.Management.Smo.StoredProcedure
  A StoredProcedure object value that specifies the stored procedure on which the parameter is defined.

• name
  Type: System.String
  A String value that specifies the name of the stored procedure parameter.

• dataType
  Type: Microsoft.SqlServer.Management.Smo.DataType
  A DataType system object value that specifies the data type of the stored procedure parameter.

Examples

Creating, Altering, and Removing Stored Procedures

See Also

Reference

StoredProcedureParameter Class

StoredProcedureParameter Overload

Microsoft.SqlServer.Management.Smo Namespace