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


C# SqlRowUpdatingEventArgs类代码示例

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


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

示例1: OnRowUpdating

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


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