Item(String) Property

In This Topic

Gets or sets the PgSqlParameter with the specified name.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Shadows Property Item( _
   ByVal parameterName As String _
) As PgSqlParameter

public new PgSqlParameter Item( 
   string parameterName
) {get; set;}

Parameters

parameterName: The name of the parameter to retrieve.

Property Value

The PgSqlParameter with the specified name.

Example

The following example searches for a PgSqlParameter with a given ParameterName within a PgSqlParameterCollection. If the parameter exists, the example displays the name and index of the parameter. If the parameter does not exist, the example displays an error. This example assumes that a PgSqlParameterCollection has already been created.

csharp

public void SearchPgSqlParams() {
  // ...
  // create PgSqlParameterCollection myParameters
  // ...
  if (!myParameters.Contains("DName"))
    MessageBox.Show("ERROR: no such parameter in the collection");
  else
    MessageBox.Show("Name: " + myParameters["DName"].ToString() +
      "Index: " + myParameters.IndexOf("DName").ToString());
}

Visual Basic

Public Sub SearchPgSqlParams()
  ' ...
  ' create PgSqlParameterCollection myParameters
  ' ...
  If Not myParameters.Contains("DName") Then
    MessageBox.Show("ERROR: no such parameter in the collection")
  Else
    MessageBox.Show("Name: "  & myParameters("DName").ToString()  & _
      "Index: "  & myParameters.IndexOf("DName").ToString())
  End If
End Sub

Reference

PgSqlParameterCollection Class
PgSqlParameterCollection Members
Overload List

Send Feedback