OracleRowUpdatedEventArgs クラスとは何？わかりやすく解説 Weblio辞書

.NET Framework クラスライブラリリファレンス

索引トップ用語の索引ランキング

OracleRowUpdatedEventArgs クラス

RowUpdated イベントのデータを提供します。このクラスは継承できません。

名前空間: System.Data.OracleClient
アセンブリ: System.Data.OracleClient (system.data.oracleclient.dll 内)
構文

Visual Basic (宣言)

Public NotInheritable Class
 OracleRowUpdatedEventArgs
    Inherits RowUpdatedEventArgs

Visual Basic (使用法)

Dim instance As OracleRowUpdatedEventArgs

public sealed class OracleRowUpdatedEventArgs
 : RowUpdatedEventArgs

C++

public ref class OracleRowUpdatedEventArgs
 sealed : public RowUpdatedEventArgs

public final class OracleRowUpdatedEventArgs
 extends RowUpdatedEventArgs

JScript

public final class OracleRowUpdatedEventArgs
 extends RowUpdatedEventArgs

解説

RowUpdated イベントは、行に対する Update が完了したときに発生します。

Update を使用すると、データ行が更新されるたびに 2 つのイベントが発生します。次の順序で処理が実行されます。

DataRow 内の値が、パラメータ値に移動されます。
OnRowUpdating イベントが発生します。
コマンドが実行されます。
コマンドが FirstReturnedRecord に設定されている場合は、最初に返された結果が DataRow に格納されます。
出力パラメータがある場合は、それが DataRow に格納されます。
OnRowUpdated イベントが発生します。
AcceptChanges が呼び出されます。

使用例

RowUpdating イベントと RowUpdated イベントを使用する方法を次の例に示します。

RowUpdating イベントは、次の出力を返します。

Event Arguments: (command=OracleCommand commandType=2status=0)

RowUpdated イベントは、次の出力を返します。

Event Arguments: (command= OracleCommend commandType=2 recordsAffected=1 row=System.Data.DataRow[37] status=0)

Visual Basic

    'Handler for RowUpdating event.
    Private Shared Sub OnRowUpdating(sender
 As Object, e As OracleRowUpdatingEventArgs)
        PrintEventArgs(e)
    End Sub 'OnRowUpdating

    'Handler for RowUpdated event.
    Private Shared Sub OnRowUpdated(sender
 As Object, e As OracleRowUpdatedEventArgs)
        PrintEventArgs(e)
    End Sub 'OnRowUpdated
    
    '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
 = "Data Source=Oracle8i;Integrated Security=yes"
        Const SELECT_ALL As String
 = "SELECT * FROM Scott.Emp"
        
        'Create DataAdapter.
        Dim rAdapter As New
 OracleDataAdapter(SELECT_ALL, CONNECTION_STRING)
        Dim cb As OracleCommandBuilder = New
 OracleCommandBuilder(rAdapter)
        
        '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) = "DYZY"
        
        '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 'Main
    
    
    Overloads Private Shared
 Sub PrintEventArgs(args As OracleRowUpdatingEventArgs)
        Console.WriteLine("OnRowUpdating")
        Console.WriteLine("  event args: (" &
 " command=" & args.Command.CommandText &
 _
                        " commandType=" & args.StatementType
 & " status=" & args.Status & ")")
    End Sub 'PrintEventArgs
    
    
    Overloads Private Shared
 Sub PrintEventArgs(args As OracleRowUpdatedEventArgs)
        Console.WriteLine("OnRowUpdated")
        Console.WriteLine("  event args: (" &
 " command=" & args.Command.CommandText &
 _
                        " commandType=" & args.StatementType
 & " recordsAffected=" & _
                        args.RecordsAffected & " status="
 & args.Status & ")")
    End Sub 'PrintEventArgs
End Class 'Form1

// handler for RowUpdating event
 private static void OnRowUpdating(object
 sender, OracleRowUpdatingEventArgs e) {
    PrintEventArgs(e);
 }
 
 //Handler for RowUpdated event.
 private static void OnRowUpdated(object
 sender, OracleRowUpdatedEventArgs e) {
    PrintEventArgs(e);
 }
 
 public static int Main(String[]
 args) {
    const string CONNECTION_STRING = "Data
 Source=Oracle8i;Integrated Security=yes";
    const string SELECT_ALL = "SELECT
 * FROM Scott.Emp";
 
    //Create DataAdapter.
    OracleDataAdapter rAdapter = new OracleDataAdapter(SELECT_ALL,
 CONNECTION_STRING);
    OracleCommandBuilder cb = new OracleCommandBuilder(rAdapter);
 
    //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] = "DYZY";
 
    //Add handlers.
    rAdapter.RowUpdating += new OracleRowUpdatingEventHandler(
 OnRowUpdating );
    rAdapter.RowUpdated += new OracleRowUpdatedEventHandler( OnRowUpdated
 );
 
    //Update--this operation fires two events (RowUpdating and RowUpdated)
 for each changed row. 
    rAdapter.Update(rDataSet, "Table");
 
    //Remove handlers.
    rAdapter.RowUpdating -= new OracleRowUpdatingEventHandler(
 OnRowUpdating );
    rAdapter.RowUpdated -= new OracleRowUpdatedEventHandler( OnRowUpdated
 );
    return 0;
 }
 
 private static void PrintEventArgs(OracleRowUpdatingEventArgs
 args) {
    Console.WriteLine("OnRowUpdating");
    Console.WriteLine("  event args: ("+
           " command=" + args.Command + 
           " commandType=" + args.StatementType + 
           " status=" + args.Status + ")");
 }
 
 private static void PrintEventArgs(OracleRowUpdatedEventArgs
 args) {
    Console.WriteLine("OnRowUpdated");
    Console.WriteLine( "  event args: ("+
           " command=" + args.Command +
           " commandType=" + args.StatementType + 
           " recordsAffected=" + args.RecordsAffected + 
           " status=" + args.Status + ")" );
 }