C#事物的簡單例子（轉)

標籤：

                          DataTable   dt   =   new   DataTable();                             System.Data.SqlClient.SqlConnection   cnn   =   new   System.Data.SqlClient.SqlConnection("連接字串");                            System.Data.SqlClient.SqlCommand   cm   =   new   System.Data.SqlClient.SqlCommand();                            cm.Connection   =   cnn;                            cnn.Open();                            System.Data.SqlClient.SqlTransaction   trans   =   cnn.BeginTransaction();                            try                            {                                    foreach(DataRow   dr   in   dt.Rows)                                    {                                            cm.CommandText   =   "update   [表]   set   [數量]   =   @amount   where   productID   =   @productID";                                            cm.Parameters.Add("@amount",SqlDbType.Int);                                            cm.Parameters["@amount"].Value   =   Convert.ToInt32(dr["amount"]);                                            cm.Parameters.Add("@productID",SqlDbType.VarChar);                                            cm.Parameters["@productID"].Value   =   dr["productID"].ToString();                                            cm.ExecuteNonQuery();                                    }                                    trans.Commit();                            }                            catch                            {                                    trans.Rollback();                            }                            finally                            {                                    cnn.Close();                                    trans.Dispose();                                    cnn.Dispose();                            }  

簡單例子

 

C#事物的簡單例子（轉)