Code
  public bool Update(string sqlstr, DataSet updateDs, string tableName)
        {
            updateDs.EnforceConstraints = false;
            if (Information.IsNothing(this.dataAdapter))
            {
                this.InitConnect();
            }
            this.custCB = new OracleCommandBuilder(this.dataAdapter);
            OracleDataAdapter dataAdapter = this.dataAdapter;
            try
            {
                dataAdapter.SelectCommand.Connection.Open();
                dataAdapter.SelectCommand.CommandText = sqlstr;
                this.myTrans = dataAdapter.SelectCommand.Connection.BeginTransaction();
                dataAdapter.SelectCommand.Transaction = this.myTrans;
                DataSet changes = updateDs.GetChanges();
                if (changes==null)
                {
                    return true;
                }
                if (changes.Tables.Contains(tableName))
                {
                    dataAdapter.Update(changes, tableName);
                    changes.Merge(updateDs);
                    updateDs.AcceptChanges();
                    this.myTrans.Commit();
                }
            }
            catch (Exception exception1)
            {
                this.myTrans.Rollback();
                throw new ZHException(exception1);
            }
            finally
            {
                if (!Information.IsNothing(dataAdapter.SelectCommand.Connection))
                {
                    dataAdapter.SelectCommand.Connection.Close();
                }
                if (!Information.IsNothing(this.custCB))
                {
                    this.custCB.Dispose();
                }
            }
            dataAdapter = null;
            return true;
        }