Add(String,MySqlType) Method

In This Topic

Adds a MySqlParameter to the MySqlParameterCollection given the parameter name and data type.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function Add( _
   ByVal parameterName As String, _
   ByVal type As MySqlType _
) As MySqlParameter

public MySqlParameter Add( 
   string parameterName,
   MySqlType type
)

Parameters

parameterName: The name of the parameter.
type: One of the MySqlType values.

Return Value

The new MySqlParameter object.

Example

The following example creates a MySqlParameterCollection, adds instances of MySqlParameter to the collection, and returns a reference to the new MySqlParameter.

csharp

public void CreateMySqlParamColl(MySqlConnection myConn) {
  MySqlCommand myCommand = new MySqlCommand("SELECT * FROM Test.Dept WHERE DeptNo = :DeptNo", myConn);
  MySqlParameterCollection myParamCollection = myCommand.Parameters;
  object myParm = new MySqlParameter("DeptNo", MySqlType.Int);
  int pIndex = myParamCollection.Add(myParm);
}

Visual Basic

Public Sub CreateMySqlParamColl(myConn As MySqlConnection)
  Dim myCommand As MySqlCommand = New MySqlCommand("SELECT * FROM Test.Dept WHERE DeptNo = :DeptNo", myConn)
  Dim myParamCollection As MySqlParameterCollection = myCommand.Parameters
  Dim myParm As Object = New MySqlParameter("DeptNo", MySqlType.Int)
  Dim pIndex As Integer = myParamCollection.Add(myParm)
End Sub

Reference

MySqlParameterCollection Class
MySqlParameterCollection Members
Overload List

Send Feedback