Item(Int32) Property

In This Topic

Gets or sets the MySqlParameter at the specified index.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Shadows Property Item( _
   ByVal index As Integer _
) As MySqlParameter

public new MySqlParameter Item( 
   int index
) {get; set;}

Parameters

index: The zero-based index of the parameter to retrieve.

Property Value

The MySqlParameter at the specified index.

Example

The following example creates a MySqlParameterCollection, adds instances of MySqlParameter to the collection, displays the names of its MySqlParameter objects, and then clears the collection.

csharp

public void CreateMySqlParamColl(MySqlCommand myCommand) {
  MySqlParameterCollection myParamCollection = myCommand.Parameters;
  myParamCollection.Add("DeptNo", MySqlType.Integer);
  myParamCollection.Add("DName", MySqlType.VarChar);
  myParamCollection.Add("Loc", MySqlType.VarChar);
  string myParamNames = "";
  for (int i=0; i < myParamCollection.Count; i++)
    myParamNames += myParamCollection[i].ToString() + "\n";
  MessageBox.Show(myParamNames);
  myParamCollection.Clear();
}

Visual Basic

Public Sub CreateMySqlParamColl(myCommand As MySqlCommand)
  Dim myParamCollection As MySqlParameterCollection = myCommand.Parameters
  myParamCollection.Add("DeptNo", MySqlType.Integer)
  myParamCollection.Add("DName", MySqlType.VarChar)
  myParamCollection.Add("Loc", MySqlType.VarChar)
  Dim myParamNames As String = ""
  Dim i As Integer
  For i = 0 To myParamCollection.Count - 1
    myParamNames += myParamCollection(i).ToString() + ControlChars.Cr
  Next i
  MessageBox.Show(myParamNames)
  myParamCollection.Clear()
End Sub

Reference

MySqlParameterCollection Class
MySqlParameterCollection Members
Overload List

Send Feedback