dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteParameter Class
Members Example

In This Topic
    SQLiteParameter Class
    In This Topic
    Represents a parameter to a SQLiteCommand, and optionally, its mapping to System.Data.DataSet columns.
    Syntax
    Remarks

    Parameter names are not case-sensitive.

    Refer to article Using Parameters in dotConnect for SQLite to obtain detailed information on the matter together with some advanced examples.

    Example
    The following example creates multiple instances of SQLiteParameter through the SQLiteParameterCollection within the SQLiteDataAdapter. These parameters are used to select data from SQLite and place the data in the System.Data.DataSet. This example assumes that a System.Data.DataSet and a SQLiteDataAdapter have already been created with the appropriate schema, commands, and connection.
    public void AddSQLiteParameters()
    {
      // ...
      // create myDataSet and myDataAdapter
      // ...
      myDataAdapter.SelectCommand.Parameters.Add("DName", SQLiteType.Text, 15).Value = "DEVELOPMENT";
      myDataAdapter.SelectCommand.Parameters.Add("DeptNo", SQLiteType.Int32).Value = 50;
      myDataAdapter.Fill(myDataSet);
    }
    Public Sub AddSQLiteParameters()
      ' ...
      ' create myDataSet and myDataAdapter
      ' ...
      myDataAdapter.SelectCommand.Parameters.Add("DName", SQLiteType.Text, 15).Value = "DEVELOPMENT"
      myDataAdapter.SelectCommand.Parameters.Add("DeptNo", SQLiteType.Int32).Value = 50
      myDataAdapter.Fill(myDataSet)
    End Sub
    Inheritance Hierarchy

    System.Object
       System.MarshalByRefObject
          System.Data.Common.DbParameter
             Devart.Common.DbParameterBase
                Devart.Data.SQLite.SQLiteParameter

    See Also