当前位置: 首页>>代码示例>>C#>>正文


C# OracleRowUpdatingEventArgs类代码示例

本文整理汇总了C#中System.Data.OracleClient.OracleRowUpdatingEventArgs的典型用法代码示例。如果您正苦于以下问题:C# OracleRowUpdatingEventArgs类的具体用法?C# OracleRowUpdatingEventArgs怎么用?C# OracleRowUpdatingEventArgs使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。


OracleRowUpdatingEventArgs类属于System.Data.OracleClient命名空间,在下文中一共展示了OracleRowUpdatingEventArgs类的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。

示例1: OnRowUpdating

// 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);

       //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 + ")");
   }
开发者ID:.NET开发者,项目名称:System.Data.OracleClient,代码行数:59,代码来源:OracleRowUpdatingEventArgs


注:本文中的System.Data.OracleClient.OracleRowUpdatingEventArgs类示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。