public void UpdateContactTableByDataSet(DataSet ds, string strTblName)

         {

             try

             {

                 SqlDataAdapter myAdapter = new SqlDataAdapter();

                 SqlConnection conn = new SqlConnection("connection string");

                 SqlCommand myCommand = new SqlCommand("select * from strTblName", conn);

                 myAdapter.SelectCommand = myCommand;

                 SqlCommandBuilder myCommandBuilder = new SqlCommandBuilder(myAdapter);

                 conn.Open();

                 SqlTransaction myTrans = conn.BeginTransaction();

                 myCommand.Transaction = myTrans;

                 try

                 {

                     myAdapter.Update(ds, strTblName);

                     myTrans.Commit();

                 }

                 catch (Exception e)

                 {

                     try

                     {

                         myTrans.Rollback();//回滚并取消数据库的更新

                     }

                     catch (SqlException ex)

                     {

                         if (myTrans.Connection != null)

                         {

                             Console.WriteLine("回滚失败! 异常类型: " + ex.GetType());

                         }

                     }

                 }

                 finally

                 {

                     conn.Close();

                 }

             }

             catch (Exception ex)

             {

                 throw ex;

             }

         }