/*Metodos que manejan los criterios*/ public void CargarCriterios() { try { OracleConnection conn = con.crearConexion(); OracleCommand cmd = null; if (conn != null) { string sql = "SELECT crit_codigo, crit_nombre, crit_tipo FROM criterios WHERE crit_estado= 'ACTIVO' order by crit_codigo"; cmd = new OracleCommand(sql, conn); cmd.CommandType = CommandType.Text; using (OracleDataReader reader = cmd.ExecuteReader()) { DataTable dataTable = new DataTable(); dataTable.Load(reader); GVcriterios.DataSource = dataTable; } GVcriterios.DataBind(); } conn.Close(); }catch (Exception ex) { Linfo.Text = "Error al cargar la lista: " + ex.Message; } }