Пример #1
0
        public virtual int UpdateTable(DataTable rdatTable, NpgsqlCommand SelectCommand)
        {
            NpgsqlDataAdapter    adapter = null;
            NpgsqlCommandBuilder builder = null;

            try
            {
                if ((rdatTable == null) || (SelectCommand == null))
                {
                    return(0);
                }
                if (this._sqlTran != null)
                {
                    SelectCommand.Transaction = this._sqlTran;
                }
                adapter = new NpgsqlDataAdapter(SelectCommand);
                builder = new NpgsqlCommandBuilder(adapter);
                return(adapter.Update(rdatTable));
            }
            catch (Exception ex)
            {
                this._InnerException = ex;
                throw ex;
            }
            finally
            {
                if (builder != null)
                {
                    builder.Dispose();
                }
                if (adapter != null)
                {
                    adapter.Dispose();
                }
                builder = null;
                adapter = null;
            }
        }