dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteCommand Class / CreateParameter Method
Example

On this page
    CreateParameter Method (SQLiteCommand)
    On this page
    Creates a new instance of a SQLiteParameter object.
    Creates a new instance of a SQLiteParameter object.
    Syntax
    'Declaration
     
    Public Shadows Function CreateParameter() As SQLiteParameter
    public new SQLiteParameter CreateParameter()

    Return Value

    A SQLiteParameter object.
    Remarks
    This method is a strongly-typed version of System.Data.IDbCommand.CreateParameter. See SQLiteParameter to find out more ways to create a parameter.
    Example
    This sample shows how to create a parameter using CreateParameter function.
    Public void CreateParam(SQLiteConnection sqLiteConnection)
    {
      SQLiteCommand sqLiteCommand = new SQLiteCommand("SELECT * FROM Dept WHERE DeptNo=:Deptno",sqLiteConnection);
      SQLiteParameter myParam = sqLiteCommand.CreateParameter();
      myParam.SQLiteType = Devart.Data.SQLite.SQLiteType.Int32;
      myParam.Value = 10;
      myParam.ParameterName = "Deptno";
      sqLiteCommand.Parameters.Add(myParam);
      sqLiteConnection.Open();
      SQLiteDataReader sqLiteReader = null; 
      try
      {
        sqLiteReader = sqLiteCommand.ExecuteReader(); 
        while (sqLiteReader.Read())
        {
          Console.WriteLine(sqLiteReader.GetInt32(0) + ", " + sqLiteReader.GetString(1) + ", " + sqLiteReader.GetString(2));
        }
      }
      finally
      {
        sqLiteReader.Close();
        sqLiteConnection.Close();
      }
    }
    Public Sub CreateParam(ByVal sqLiteConnection As SQLiteConnection)
      Dim sqLiteCommand As New SQLiteCommand("SELECT * FROM Dept WHERE DeptNo=:Deptno", sqLiteConnection)
      Dim myParam As SQLiteParameter = sqLiteCommand.CreateParameter()
      myParam.SQLiteType = Devart.Data.SQLite.SQLiteType.Int32
      myParam.Value = 10
      myParam.ParameterName = "Deptno"
      sqLiteCommand.Parameters.Add(myParam)
      sqLiteConnection.Open()
      Dim sqLiteReader As SQLiteDataReader = Nothing
      Try
        sqLiteReader = sqLiteCommand.ExecuteReader()
        While sqLiteReader.Read()
          Console.WriteLine(sqLiteReader.GetInt32(0).ToString() + ", " _
            + sqLiteReader.GetString(1) + ", " _
            + sqLiteReader.GetString(2))
        End While
      Finally
        sqLiteReader.Close()
        sqLiteConnection.Close()
      End Try
    End Sub
    See Also