Add(String,UniDbType,Int32,String) Method

In This Topic

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

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function Add( _
   ByVal parameterName As String, _
   ByVal dbType As UniDbType, _
   ByVal size As Integer, _
   ByVal sourceColumn As String _
) As UniParameter

public UniParameter Add( 
   string parameterName,
   UniDbType dbType,
   int size,
   string sourceColumn
)

Parameters

parameterName: The name of the parameter.
dbType
size: The width of the column.
sourceColumn: The name of the source 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, "DeptNo");
}

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, "DeptNo")
End Sub

Reference

UniParameterCollection Class
UniParameterCollection Members
Overload List

Send Feedback