Constructeur SqlCeCommand (String, SqlCeConnection, SqlCeTransaction)

  • Article

Initialise une nouvelle instance de la classe SqlCeCommand avec le texte de la requête, SqlCeConnection et SqlCeTransaction.

Espace de noms :  System.Data.SqlServerCe
Assembly :  System.Data.SqlServerCe (en System.Data.SqlServerCe.dll)

Syntaxe

'Déclaration
Public Sub New ( _
    commandText As String, _
    connection As SqlCeConnection, _
    transaction As SqlCeTransaction _
)
'Utilisation
Dim commandText As String
Dim connection As SqlCeConnection
Dim transaction As SqlCeTransaction

Dim instance As New SqlCeCommand(commandText, _
    connection, transaction)

public SqlCeCommand(
    string commandText,
    SqlCeConnection connection,
    SqlCeTransaction transaction
)

public:
SqlCeCommand(
    String^ commandText, 
    SqlCeConnection^ connection, 
    SqlCeTransaction^ transaction
)

new : 
        commandText:string * 
        connection:SqlCeConnection * 
        transaction:SqlCeTransaction -> SqlCeCommand

public function SqlCeCommand(
    commandText : String, 
    connection : SqlCeConnection, 
    transaction : SqlCeTransaction
)

Paramètres

Notes

Le tableau suivant indique les valeurs de propriété initiales d'une instance de SqlCeCommand.

Propriétés

Valeur initiale

CommandText

cmdText

CommandType

Texte

Connection

Nouveau SqlCeConnection qui est la valeur du paramètre connection.

Vous pouvez modifier la valeur de ces paramètres en définissant la propriété associée.

Exemples

L'exemple suivant crée un SqlCeCommand et définit certaines de ses propriétés.

        Dim cmdText As String = "INSERT INTO FactSalesQuota " & _
                "(EmployeeKey, TimeKey, SalesAmountQuota) " & _
                "VALUES (2, 1158, 150000.00)"

        Dim conn As New SqlCeConnection("Data Source = AdventureWorks.sdf;")
        conn.Open()

        ' Start a local transaction; SQL Mobile supports the following 
        ' isolation levels: ReadCommitted, RepeatableRead, Serializable
        '
        Dim tx As SqlCeTransaction = conn.BeginTransaction(IsolationLevel.ReadCommitted)

        ' By default, commands run in auto-commit mode; 
        '
        Dim cmd As New SqlCeCommand(cmdText, conn, tx)

        Try
            cmd.ExecuteNonQuery()

            ' Commit the changes to disk if everything above succeeded;
            ' Use Deferred mode for optimal performance; the changes will 
            ' be flashed to disk within the timespan specified in the 
            ' ConnectionString 'FLUSH INTERVAL' property; 
            '
            tx.Commit(CommitMode.Deferred)

            ' Alternatively, you could use:
            ' tx.Commit(CommitMode.Immediate);
            '
            ' or use default (Deferred) commit mode:
            ' tx.Commit()

        Catch e As Exception
            ' Handle errors here
            '
            tx.Rollback()
        Finally
            conn.Close()
        End Try

     string cmdText = "INSERT INTO FactSalesQuota " +
            "(EmployeeKey, TimeKey, SalesAmountQuota) " +
            "VALUES (2, 1158, 150000.00)";

        SqlCeConnection conn = new SqlCeConnection("Data Source = AdventureWorks.sdf;");
        conn.Open();

        // Start a local transaction; SQL Mobile supports the following 
        // isolation levels: ReadCommitted, RepeatableRead, Serializable
        //
        SqlCeTransaction tx = conn.BeginTransaction(IsolationLevel.ReadCommitted);

        SqlCeCommand cmd = new SqlCeCommand(cmdText, conn, tx);

        try
        {
            cmd.ExecuteNonQuery();


            // Commit the changes to disk if everything above succeeded;
            // Use Deferred mode for optimal performance; the changes will 
            // be flushed to disk within the timespan specified in the 
            // ConnectionString 'FLUSH INTERVAL' property; 
            //
            tx.Commit(CommitMode.Deferred);

            // Alternatively, you could use:
            // tx.Commit(CommitMode.Immediate);
            //
            // or use default (Deferred) commit mode:
            // tx.Commit()
        }
        catch (Exception)
        {
            // Handle errors here
            //
            tx.Rollback();
        }
        finally
        {
            conn.Close();
        }

Voir aussi

Référence

SqlCeCommand Classe

Surcharge SqlCeCommand

Espace de noms System.Data.SqlServerCe