Represents a parameter to a
SQLiteCommand, and optionally, its mapping to
System.Data.DataSet columns.
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