Item(Int32) Property

In This Topic

Gets or sets the DB2Parameter at the specified index.

Syntax

Visual Basic
C#

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

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

Parameters

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

Property Value

The DB2Parameter at the specified index.

Example

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

csharp

public void CreateDB2ParamColl(DB2Command db2Command) {
  DB2ParameterCollection myParamCollection = db2Command.Parameters;
  myParamCollection.Add("DeptNo", DB2Type.Integer);
  myParamCollection.Add("DName", DB2Type.VarChar);
  myParamCollection.Add("Loc", DB2Type.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 CreateDB2ParamColl(db2Command As DB2Command)
  Dim myParamCollection As DB2ParameterCollection = db2Command.Parameters
  myParamCollection.Add("DeptNo", DB2Type.Integer)
  myParamCollection.Add("DName", DB2Type.VarChar)
  myParamCollection.Add("Loc", DB2Type.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

DB2ParameterCollection Class
DB2ParameterCollection Members
Overload List

Send Feedback