Add(String,UniDbType,Int32) Method

On this page

Adds a UniParameter to the UniParameterCollection given the the parameter name, data type, and column width.

Syntax

Visual Basic
C#


'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.

csharp


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 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);
}

Visual Basic


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

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

Reference

UniParameterCollection Class
UniParameterCollection Members
Overload List

Send Feedback