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

In This Topic
Add(String,UniDbType) Method
In This Topic
Adds a UniParameter to the UniParameterCollection given the parameter name and data type.
Syntax
'Declaration
 
Public Overloads Function Add( _
   ByVal parameterName As String, _
   ByVal type As UniDbType _
) As UniParameter
 

Parameters

parameterName
The name of the parameter.
type
One of the UniDbType values.

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() {
  UniCommand myCommand = new UniCommand("SELECT * FROM Test.Dept WHERE DeptNo = :DeptNo", myConn);
  UniParameterCollection myParamCollection = myCommand.Parameters;
  object myParm = new UniParameter("DeptNo", UniDbType.Integer);
  int pIndex = myParamCollection.Add(myParm);
}
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 myParm As Object = New UniParameter("DeptNo", UniDbType.Integer)
  Dim pIndex As Integer = myParamCollection.Add(myParm)
End Sub
See Also