Item(Int32) Property

In This Topic

Gets or sets the OracleParameter at the specified index.

Syntax

Visual Basic
C#

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

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

Parameters

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

Property Value

The OracleParameter at the specified index.

Example

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

csharp

public void CreateOracleParamColl(OracleCommand myCommand) {
  OracleParameterCollection myParamCollection = myCommand.Parameters;
  myParamCollection.Add("DeptNo", OracleDbType.Integer);
  myParamCollection.Add("DName", OracleDbType.VarChar);
  myParamCollection.Add("Loc", OracleDbType.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 CreateOracleParamColl(myCommand As OracleCommand)
  Dim myParamCollection As OracleParameterCollection = myCommand.Parameters
  myParamCollection.Add("DeptNo", OracleDbType.Integer)
  myParamCollection.Add("DName", OracleDbType.VarChar)
  myParamCollection.Add("Loc", OracleDbType.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

OracleParameterCollection Class
OracleParameterCollection Members
Overload List

Send Feedback