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; } }