dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteParameterCollection Class / Item Property
Example

In This Topic
    Item Property (SQLiteParameterCollection)
    In This Topic
    Gets or sets the SQLiteParameter at the specified index.
    Overload List
    OverloadDescription
    Gets or sets the SQLiteParameter at the specified index.  
    Gets or sets the SQLiteParameter with the specified name.  
    Example
    The following example creates a SQLiteParameterCollection, adds instances of SQLiteParameter to the collection, displays the names of its SQLiteParameter objects, and then clears the collection.
    public void CreateSQLiteParamColl(SQLiteCommand sqCommand) {
      SQLiteParameterCollection myParamCollection = sqCommand.Parameters;
      myParamCollection.Add("DeptNo", SQLiteType.Int32);
      myParamCollection.Add("DName", SQLiteType.Text);
      myParamCollection.Add("Loc", SQLiteType.Text);
      string myParamNames = "";
      for (int i=0; i < myParamCollection.Count; i++)
        myParamNames += myParamCollection[i].ToString() + "\n";
      MessageBox.Show(myParamNames);
      myParamCollection.Clear();
    }
    Public Sub CreateSQLiteParamColl(sqCommand As SQLiteCommand)
      Dim myParamCollection As SQLiteParameterCollection = sqCommand.Parameters
      myParamCollection.Add("DeptNo", SQLiteType.Int32)
      myParamCollection.Add("DName", SQLiteType.Text)
      myParamCollection.Add("Loc", SQLiteType.Text)
      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
    See Also