dotConnect Universal Documentation
Devart.Data.Universal Namespace / UniParameterCollection Class / Add Method / Add(String,UniDbType,Int32) Method
The name of the parameter.
The width of the column.
Example

In This Topic
    Add(String,UniDbType,Int32) Method
    In This Topic
    Adds a UniParameter to the UniParameterCollection given the the parameter name, data type, and column width.
    Syntax
    'Declaration
     
    Public Overloads Function Add( _
       ByVal parameterName As String, _
       ByVal dbType As UniDbType, _
       ByVal size As Integer _
    ) As UniParameter
    public UniParameter Add( 
       string parameterName,
       UniDbType dbType,
       int size
    )

    Parameters

    parameterName
    The name of the parameter.
    dbType
    size
    The width of the column.

    Return Value

    The new UniParameter object.
    Example
    The following example creates a UniParameterCollection, adds instances of UniParameter to the collection, and returns a reference to the new UniParameter.
    public void CreateUniParamColl(UniConnection myConn) {
      UniCommand myCommand = new UniCommand("SELECT * FROM Test.Dept WHERE DeptNo = :DeptNo", myConn);
      UniParameterCollection myParamCollection = myCommand.Parameters;
      UniParameter myNewParameter = myParamCollection.Add("DeptNo", UniDbType.Integer, 40);
    }
    Public Sub CreateUniParamColl(myConn As UniConnection)
      Dim myCommand As UniCommand = New UniCommand("SELECT * FROM Test.Dept WHERE DeptNo = :DeptNo", myConn)
      Dim myParamCollection As UniParameterCollection = myCommand.Parameters
      Dim myNewParameter As UniParameter = myParamCollection.Add("DeptNo", UniDbType.Integer, 40)
    End Sub
    See Also