public DataSet ExecuteDbDataSet(DbCommand scdCommand) { DbConnection Conn = Conexao.abrirConexao(ConnectionStringName); scdCommand.Connection = Conn; DbDataAdapter daAdapter = Conexao.obterDataAdapter(scdCommand.Connection); try { DataSet dsDados = new DataSet(); daAdapter.SelectCommand = scdCommand; daAdapter.Fill(dsDados); daAdapter = null; return(dsDados); } catch (Exception ex) { throw ex; } finally { daAdapter.Dispose(); Conexao.fecharConexao(scdCommand.Connection); scdCommand.Dispose(); } }
public DataSet ExecuteDbDataSet(DbCommand scdCommand) { DbConnection Conn = Conexao.abrirConexao(); scdCommand.Connection = Conn; DbDataAdapter daAdapter = Conexao.obterDataAdapter(scdCommand.Connection); try { DataSet dsDados = new DataSet(); daAdapter.SelectCommand = scdCommand; daAdapter.Fill(dsDados); daAdapter = null; return(dsDados); } catch (Exception ex) { int numeroErro = LogEventError.Write(ex.Message); throw new Exception("Ocorreu um erro ao tentar acessar o Banco de Dados. Err.ID " + numeroErro); } finally { daAdapter.Dispose(); Conexao.fecharConexao(scdCommand.Connection); scdCommand.Dispose(); } }
public DataTable ExecuteDbDataTable(DbCommand scdCommand, DbConnection Conn) { scdCommand.Connection = Conn; DbDataAdapter daAdapter = Conexao.obterDataAdapter(scdCommand.Connection); try { DataTable dtTable = new DataTable(); daAdapter.SelectCommand = scdCommand; daAdapter.Fill(dtTable); return(dtTable); } catch (Exception ex) { int numeroErro = LogEventError.Write(ex.Message); throw new Exception("Ocorreu um erro ao tentar acessar o Banco de Dados. Err.ID " + numeroErro); } finally { daAdapter.Dispose(); scdCommand.Dispose(); } }
public DataTable ExecuteDbDataTable(DbCommand scdCommand, DbConnection Conn) { scdCommand.Connection = Conn; DbDataAdapter daAdapter = Conexao.obterDataAdapter(scdCommand.Connection); try { DataTable dtTable = new DataTable(); daAdapter.SelectCommand = scdCommand; daAdapter.Fill(dtTable); return(dtTable); } catch (Exception ex) { throw ex; } finally { daAdapter.Dispose(); scdCommand.Dispose(); } }