SqlRowUpdatedEventArgs Kelas

Definisi

Ruang nama:

Microsoft.Data.SqlClient

Rakitan:

Microsoft.Data.SqlClient.dll

Paket:

Microsoft.Data.SqlClient v5.2.0

Menyediakan data untuk peristiwa tersebut RowUpdated .

public ref class SqlRowUpdatedEventArgs sealed : System::Data::Common::RowUpdatedEventArgs

public sealed class SqlRowUpdatedEventArgs : System.Data.Common.RowUpdatedEventArgs

type SqlRowUpdatedEventArgs = class
    inherit RowUpdatedEventArgs

Public NotInheritable Class SqlRowUpdatedEventArgs
Inherits RowUpdatedEventArgs

Warisan

RowUpdatedEventArgs

SqlRowUpdatedEventArgs

Contoh

Contoh berikut menunjukkan cara menggunakan RowUpdating peristiwa dan RowUpdated .

Peristiwa RowUpdating mengembalikan output ini:

Argumen Peristiwa: (command=Microsoft.Data.SqlClient.SqlCommand commandType=2 status=0)

Peristiwa RowUpdated mengembalikan output ini:

Argumen Peristiwa: (command=Microsoft.Data.SqlClient.SqlCommand commandType=2 recordsAffected=1 row=System.Data.DataRow[37] status=0)

using Microsoft.Data.SqlClient;
using System.Xml;
using System.Data.Common;
using System.Windows.Forms;

public class Form1 : Form
{
    private DataSet DataSet1;
    private DataGrid dataGrid1;

    // 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 connectionString =
                  "Integrated Security=SSPI;database=Northwind;server=MSSQL1";
        const string queryString = "SELECT * FROMProducts";

        // create DataAdapter
        SqlDataAdapter adapter = new SqlDataAdapter(queryString, connectionString);
        SqlCommandBuilder builder = new SqlCommandBuilder(adapter);

        // Create and fill DataSet (select only first 5 rows)
        DataSet dataSet = new DataSet();
        adapter.Fill(dataSet, 0, 5, "Table");

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

        // add handlers
        adapter.RowUpdating += new SqlRowUpdatingEventHandler(OnRowUpdating);
        adapter.RowUpdated += new SqlRowUpdatedEventHandler(OnRowUpdated);

        // update, this operation fires two events 
        // (RowUpdating/RowUpdated) per changed row 
        adapter.Update(dataSet, "Table");

        // remove handlers
        adapter.RowUpdating -= new SqlRowUpdatingEventHandler(OnRowUpdating);
        adapter.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 + ")");
    }
}

Keterangan

Peristiwa RowUpdated dinaikkan ketika baris Update ke selesai.

Saat menggunakan Update, ada dua peristiwa yang terjadi untuk setiap baris data yang diperbarui. Urutan eksekusi adalah sebagai berikut:

1. Nilai dalam DataRow dipindahkan ke nilai parameter.

2. Acara OnRowUpdating dinaikkan.

3. Perintah dijalankan.

4. Jika perintah diatur ke FirstReturnedRecord, dan hasil pertama yang dikembalikan ditempatkan di DataRow.

5. Jika ada parameter output, parameter tersebut ditempatkan di DataRow.

6. Acara OnRowUpdated dinaikkan.

7. AcceptChanges dipanggil.

Konstruktor

SqlRowUpdatedEventArgs(DataRow, IDbCommand, StatementType, DataTableMapping)

Menginisialisasi instans baru kelas SqlRowUpdatedEventArgs.

Properti

Command

Mendapatkan atau mengatur yang SqlCommand dijalankan saat Update(DataSet) dipanggil.