SqlCeCommand.CreateParameter Method

Creates a new instance of a SqlCeParameter object.

Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)

public SqlCeParameter CreateParameter ()
public SqlCeParameter CreateParameter ()
public function CreateParameter () : SqlCeParameter

Return Value

A SqlCeParameter object.

The CreateParameter method is a strongly-typed version of CreateParameter.

The following example creates a SqlCeCommand and uses the CreateParameter property to create parameters.

SqlCeConnection conn = null;
SqlCeDataReader rdr = null;

try
{
    conn = new SqlCeConnection(connStr);
    conn.Open();

    SqlCeCommand cmd = new SqlCeCommand("SELECT * FROM myTable", conn);
    cmd.Connection.Open();

    rdr = cmd.ExecuteReader();

    while (rdr.Read())
    {
        Console.WriteLine(rdr.GetString(0));
    

finally
{
    rdr.Close();
    conn.Close();


  • Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see .

Windows CE, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows XP Professional x64 Edition, Windows XP SP2

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.

.NET Compact Framework

Supported in: 2.0, 1.0

Community Additions

ADD
Show: