Item(Int32) Property

In This Topic

Gets or sets the PgSqlParameter at the specified index.

Syntax

Visual Basic
C#

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

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

Parameters

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

Property Value

The PgSqlParameter at the specified index.

Example

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

csharp

public void CreatePgSqlParamColl(PgSqlCommand pgCommand) {
  PgSqlParameterCollection myParamCollection = pgCommand.Parameters;
  myParamCollection.Add("DeptNo", PgSqlType.Integer);
  myParamCollection.Add("DName", PgSqlType.VarChar);
  myParamCollection.Add("Loc", PgSqlType.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 CreatePgSqlParamColl(pgCommand As PgSqlCommand)
  Dim myParamCollection As PgSqlParameterCollection = pgCommand.Parameters
  myParamCollection.Add("DeptNo", PgSqlType.Integer)
  myParamCollection.Add("DName", PgSqlType.VarChar)
  myParamCollection.Add("Loc", PgSqlType.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

PgSqlParameterCollection Class
PgSqlParameterCollection Members
Overload List

Send Feedback