DataReader

        /// <summary>
        /// Realiza uma Consulta no Banco de Dados
        /// </summary>
        /// <param name="sSql">Query a ser executada.</param>
        /// <returns>DataTable com o resultado da Consulta.</returns>
        public System.Data.DataTable GetDataTable(string sSql)
        {
            try
            {
                Open(); // Método que abre a conexão
                if (objConn.State == ConnectionState.Open)
                {
                    DataTable objDataTable = new DataTable();
                    SqlDataAdapter objDataAdapter = new SqlDataAdapter();
                    objDataAdapter.SelectCommand = new SqlCommand(sSql, objConn);
                    objDataAdapter.Fill(objDataTable);
                    Close();
                    return objDataTable;
                }

                else
                {
                    return null;
                }
            }
            catch (Exception ex)
            {
                if (objConn != null)
                {
                    if (objConn.State == ConnectionState.Open)
                    {
                        Close();
                    }
                }
                throw new Exception("Sql: Erro ao obter DataTable." + "Erro: " + ex.Message);
            }
        }