SqlCeCommand Constructor (String, SqlCeConnection, SqlCeTransaction)

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 (dans system.data.sqlserverce.dll)

Syntaxe

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

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

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

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

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

Paramètres

• commandText
  Texte de la requête.

• connection

• transaction
  Transaction dans laquelle SqlCeCommand s'exécute.

Remarques

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

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

Exemple

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();
}

Plateformes

Plateformes de développement

Windows Vista, Windows Mobile 5.0, Windows XP Professional with Service Pack 2 (SP2), Windows Server 2003, Windows Mobile 2003 for Pocket PC, Windows CE 5.0
Informations sur la version
.NET Framework et NET Compact Framework
Pris en charge dans 3.5
.NET Framework
Pris en charge dans 3.0
.NET Compact Framework et .Net Framework
Pris en charge dans 2.0

Voir aussi

Référence

SqlCeCommand Class
SqlCeCommand Members
System.Data.SqlServerCe Namespace