SqlRowUpdatingEventArgs Classe

Definizione

Fornisce dati per l'evento RowUpdating.Provides data for the RowUpdating event.

public ref class SqlRowUpdatingEventArgs sealed : System::Data::Common::RowUpdatingEventArgs
public sealed class SqlRowUpdatingEventArgs : System.Data.Common.RowUpdatingEventArgs
type SqlRowUpdatingEventArgs = class
    inherit RowUpdatingEventArgs
Public NotInheritable Class SqlRowUpdatingEventArgs
Inherits RowUpdatingEventArgs
Ereditarietà
SqlRowUpdatingEventArgs

Esempio

Nell'esempio seguente viene illustrato come utilizzare gli RowUpdating eventi e RowUpdated .The following example shows how to use both the RowUpdating and RowUpdated events.

L' RowUpdating evento restituisce l'output seguente:The RowUpdating event returns this output:

argomenti dell'evento: (Command = System. Data. SqlClient. SqlCommand commandType = 2 status = 0)event args: (command=System.Data.SqlClient.SQLCommand commandType=2 status=0)

L' RowUpdated evento restituisce l'output seguente:The RowUpdated event returns this output:

argomenti dell'evento: (Command = System. Data. SqlClient. SqlCommand commandType = 2 recordsAffected = 1 Row = System. Data. DataRow [37] status = 0)event args: (command=System.Data.SqlClient.SQLCommand commandType=2 recordsAffected=1 row=System.Data.DataRow[37] status=0)

// handler for RowUpdating event
private static void OnRowUpdating(object sender, SqlRowUpdatingEventArgs e)
{
    PrintEventArgs(e);
}

//Handler for RowUpdated event.
private static void OnRowUpdated(object sender, SqlRowUpdatedEventArgs e)
{
    PrintEventArgs(e);
}

public static int Main()
{
    const string CONNECTION_STRING = "Persist Security Info=False;Integrated Security=SSPI;database=northwind;server=mySQLServer";
    const string SELECT_ALL = "select * from Products";

    //Create DataAdapter.
    SqlDataAdapter rAdapter    = new SqlDataAdapter(SELECT_ALL, CONNECTION_STRING);

    //Create and fill DataSet (Select only first 5 rows.).
    DataSet rDataSet = new DataSet();
    rAdapter.Fill(rDataSet, 0, 5, "Table");

    //Modify DataSet.
    DataTable rTable = rDataSet.Tables["Table"];
    rTable.Rows[0][1] = "new product";

    //Add handlers.
    rAdapter.RowUpdating += new SqlRowUpdatingEventHandler( OnRowUpdating );
    rAdapter.RowUpdated += new SqlRowUpdatedEventHandler( OnRowUpdated );

    //Update--this operation fires two events (RowUpdating and RowUpdated) for each changed row.
    rAdapter.Update(rDataSet, "Table");

    //Remove handlers.
    rAdapter.RowUpdating -= new SqlRowUpdatingEventHandler( OnRowUpdating );
    rAdapter.RowUpdated -= new SqlRowUpdatedEventHandler( OnRowUpdated );
    return 0;
}

private static void PrintEventArgs(SqlRowUpdatingEventArgs args)
{
    Console.WriteLine("OnRowUpdating");
    Console.WriteLine("  event args: ("+
        " command=" + args.Command +
        " commandType=" + args.StatementType +
        " status=" + args.Status + ")");
}

private static void PrintEventArgs(SqlRowUpdatedEventArgs args)
{
    Console.WriteLine("OnRowUpdated");
    Console.WriteLine("  event args: ("+
        " command=" + args.Command +
        " commandType=" + args.StatementType +
        " recordsAffected=" + args.RecordsAffected +
        " status=" + args.Status + ")");
}
'Handler for RowUpdating event.
Private Shared Sub OnRowUpdating(sender As Object, e As SqlRowUpdatingEventArgs)
    PrintEventArgs(e)
End Sub 

'Handler for RowUpdated event.
Private Shared Sub OnRowUpdated(sender As Object, e As SqlRowUpdatedEventArgs)
    PrintEventArgs(e)
End Sub 

'Entry point which delegates to C-style main Private Function.
Public Overloads Shared Sub Main()
    System.Environment.ExitCode = Main(System.Environment.GetCommandLineArgs())
End Sub

Overloads Public Shared Function Main(args() As String) As Integer
    Const CONNECTION_STRING As String = "Persist Security Info=False;Integrated Security=SSPI;database=northwind;server=mySQLServer"
    Const SELECT_ALL As String = "select * from Products"
    
    'Create DataAdapter.
    Dim rAdapter As New SqlDataAdapter(SELECT_ALL, CONNECTION_STRING)
    
    'Create and fill DataSet (Select only first 5 rows.).
    Dim rDataSet As New DataSet()
    rAdapter.Fill(rDataSet, 0, 5, "Table")
    
    'Modify DataSet.
    Dim rTable As DataTable = rDataSet.Tables("Table")
    rTable.Rows(0)(1) = "new product"
    
    'Add handlers.
    AddHandler rAdapter.RowUpdating, AddressOf OnRowUpdating
    AddHandler rAdapter.RowUpdated, AddressOf OnRowUpdated
    
    'Update--this operation fires two events (RowUpdating and RowUpdated) for each changed row. 
    rAdapter.Update(rDataSet, "Table")
    
    'Remove handlers.
    RemoveHandler rAdapter.RowUpdating, AddressOf OnRowUpdating
    RemoveHandler rAdapter.RowUpdated, AddressOf OnRowUpdated
    Return 0
End Function 

Overloads Private Shared Sub PrintEventArgs(args As SqlRowUpdatingEventArgs)
    Console.WriteLine("OnRowUpdating")
    Console.WriteLine("  event args: (" & _
                    " command=" & _
                    args.Command.CommandText & _
                    " commandType=" & _
                    args.StatementType & _
                    " status=" & _
                    args.Status & _
                    ")")
End Sub 


Overloads Private Shared Sub PrintEventArgs(args As SqlRowUpdatedEventArgs)
    Console.WriteLine("OnRowUpdated")
    Console.WriteLine("  event args: (" & _
                    " command=" & _
                    args.Command.CommandText & _
                    " commandType=" & _
                    args.StatementType & _
                    " recordsAffected=" & _
                    args.RecordsAffected & _
                    " status=" & _
                    args.Status & _
                    ")")
End Sub 

Commenti

L' RowUpdating evento viene generato prima di un oggetto Update in una riga.The RowUpdating event is raised before an Update to a row.

Quando si utilizza Update , sono presenti due eventi che si verificano per ogni riga di dati aggiornata.When you are using Update, there are two events that occur for each data row updated. L'ordine di esecuzione è il seguente:The order of execution is as follows:

  1. I valori in DataRow vengono spostati nei valori dei parametri.The values in the DataRow are moved to the parameter values.

  2. Viene generato l'evento OnRowUpdating.The OnRowUpdating event is raised.

  3. Il comando viene eseguito.The command executes.

  4. Se il comando è impostato su FirstReturnedRecord e il primo risultato restituito viene inserito nell'oggetto DataRow .If the command is set to FirstReturnedRecord, and the first returned result is placed in the DataRow.

  5. Se sono presenti parametri di output, vengono inseriti in DataRow .If there are output parameters, they are placed in the DataRow.

  6. Viene generato l'evento OnRowUpdated.The OnRowUpdated event is raised.

  7. Viene chiamato AcceptChanges.AcceptChanges is called.

Costruttori

SqlRowUpdatingEventArgs(DataRow, IDbCommand, StatementType, DataTableMapping)

Inizializza una nuova istanza della classe SqlRowUpdatingEventArgs.Initializes a new instance of the SqlRowUpdatingEventArgs class.

Proprietà

BaseCommand

Ottiene o imposta l'oggetto IDbCommand per un'istanza di questa classe.Gets or sets the IDbCommand object for an instance of this class.

(Ereditato da RowUpdatingEventArgs)
Command

Ottiene o imposta l'oggetto SqlCommand da eseguire quando si esegue il metodo Update(DataSet).Gets or sets the SqlCommand to execute when performing the Update(DataSet).

Errors

Ottiene tutti gli errori generati dal provider di dati .NET al momento dell'esecuzione del metodo Command.Gets any errors generated by the .NET data provider when the Command executes.

(Ereditato da RowUpdatingEventArgs)
Row

Ottiene la classe DataRow che viene inviata al server quale parte di un'operazione insert, update o delete.Gets the DataRow that will be sent to the server as part of an insert, update, or delete operation.

(Ereditato da RowUpdatingEventArgs)
StatementType

Ottiene il tipo di istruzione SQL da eseguire.Gets the type of SQL statement to execute.

(Ereditato da RowUpdatingEventArgs)
Status

Ottiene o imposta l'enumerazione UpdateStatus della proprietà Command.Gets or sets the UpdateStatus of the Command property.

(Ereditato da RowUpdatingEventArgs)
TableMapping

Ottiene l'oggetto DataTableMapping da inviare attraverso il metodo Update(DataSet).Gets the DataTableMapping to send through the Update(DataSet).

(Ereditato da RowUpdatingEventArgs)

Metodi

Equals(Object)

Determina se l'oggetto specificato è uguale all'oggetto corrente.Determines whether the specified object is equal to the current object.

(Ereditato da Object)
GetHashCode()

Funge da funzione hash predefinita.Serves as the default hash function.

(Ereditato da Object)
GetType()

Ottiene l'oggetto Type dell'istanza corrente.Gets the Type of the current instance.

(Ereditato da Object)
MemberwiseClone()

Crea una copia superficiale dell'oggetto Object corrente.Creates a shallow copy of the current Object.

(Ereditato da Object)
ToString()

Restituisce una stringa che rappresenta l'oggetto corrente.Returns a string that represents the current object.

(Ereditato da Object)

Si applica a