Item(String) Property

In This Topic

Gets or sets the SQLiteParameter with the specified name.

Syntax

Visual Basic
C#

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

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

Parameters

parameterName: The name of the parameter to retrieve.

Property Value

The SQLiteParameter with the specified name.

Example

The following example searches for a SQLiteParameter with a given ParameterName within a SQLiteParameterCollection. 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 SQLiteParameterCollection has already been created.

csharp

public void SearchSQLiteParams() {
  // ...
  // create SQLiteParameterCollection 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 SearchSQLiteParams()
  ' ...
  ' create SQLiteParameterCollection 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

SQLiteParameterCollection Class
SQLiteParameterCollection Members
Overload List

Send Feedback