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


C# SqlDataAdapter.RowUpdated事件代码示例

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


在下文中一共展示了SqlDataAdapter.RowUpdated事件的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的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 connectionString = 
                 "Integrated Security=SSPI;database=Northwind;server=MSSQL1";
       const string queryString = "SELECT * FROM Products";

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

示例2: Main

//引入命名空间
using System;
using System.Data;
using System.Data.SqlClient;

   class SqlDemo {
      static void Main(){
         string connString = "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI";

         SqlConnection cn = new SqlConnection(connString);
         try
         {
            cn.Open();
            SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Employee", cn);
     
            SqlCommandBuilder cb = new SqlCommandBuilder(da);

            DataSet ds = new DataSet();
            da.Fill(ds, 0, 1, "Employee");

            da.RowUpdating += new SqlRowUpdatingEventHandler(OnRowUpdating);
            da.RowUpdated += new SqlRowUpdatedEventHandler(OnRowUpdated);

            DataTable dt = ds.Tables["Employee"];
            dt.Rows[0][1] = "T";

            da.Update(ds, "Employee");

            da.RowUpdating -= new SqlRowUpdatingEventHandler(OnRowUpdating);
            da.RowUpdated -= new SqlRowUpdatedEventHandler(OnRowUpdated);
 
         } catch (SqlException ex) {
            Console.WriteLine(ex.Message);
         }
         finally
         {
            cn.Close();
         }

      }


      static void OnRowUpdating(object sender, SqlRowUpdatingEventArgs e) 
      {
         Console.WriteLine("OnRowUpdating event");
         if (e.Status != UpdateStatus.Continue) 
            Console.WriteLine("RowStatus = " + e.Status.ToString());
      } 

      static void OnRowUpdated(object sender, SqlRowUpdatedEventArgs e) 
      {
         Console.WriteLine("OnRowUpdating event");
         if (e.Status != UpdateStatus.Continue) 
            Console.WriteLine("RowStatus = " + e.Status.ToString());
      }
  }
开发者ID:C#程序员,项目名称:System.Data.SqlClient,代码行数:56,代码来源:SqlDataAdapter.RowUpdated


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