dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteParameterCollection Class / Add Method / Add(String,SQLiteType) Method
The name of the parameter.
One of the SQLiteType values.
Example

In This Topic
    Add(String,SQLiteType) Method
    In This Topic
    Adds a SQLiteParameter to the SQLiteParameterCollection given the parameter name and data type.
    Syntax
    'Declaration
     
    Public Overloads Function Add( _
       ByVal parameterName As String, _
       ByVal type As SQLiteType _
    ) As SQLiteParameter
    public SQLiteParameter Add( 
       string parameterName,
       SQLiteType type
    )

    Parameters

    parameterName
    The name of the parameter.
    type
    One of the SQLiteType values.

    Return Value

    The new SQLiteParameter object.
    Example
    The following example creates a SQLiteParameterCollection, adds instances of SQLiteParameter to the collection, and returns a reference to the new SQLiteParameter.
    public void CreateSQLiteParamColl(SQLiteConnection myConn) {
      SQLiteCommand sqCommand = new SQLiteCommand("SELECT * FROM Dept WHERE DeptNo = :DeptNo", myConn);
      SQLiteParameterCollection myParamCollection = sqCommand.Parameters;
      object myParm = new SQLiteParameter("DeptNo", SQLiteType.Int32);
      int pIndex = myParamCollection.Add(myParm);
    }
    Public Sub CreateSQLiteParamColl(myConn As SQLiteConnection)
      Dim sqCommand As SQLiteCommand = New SQLiteCommand("SELECT * FROM Dept WHERE DeptNo = :DeptNo", myConn)
      Dim myParamCollection As SQLiteParameterCollection = sqCommand.Parameters
      Dim myParm As Object = New SQLiteParameter("DeptNo", SQLiteType.Int32)
      Dim pIndex As Integer = myParamCollection.Add(myParm)
    End Sub
    See Also