private void ResultadoConsulta() { Linfo.Text = ""; try{ OracleConnection conn = con.crearConexion(); OracleCommand cmd = null; if (conn != null) { string sql = " SELECT e.CRIT_CODIGO ,c.CRIT_NOMBRE, c.CRIT_TIPO FROM CRITERIOS c, EVALUA_CRITERIOS e , ESTUDIANTE u WHERE e.CRIT_CODIGO = c.CRIT_CODIGO and U.Prop_Codigo = E.Ppro_Codigo and E.Ppro_Codigo = '" + Codigop.Value + "' ORDER BY e.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; int cantfilas = Convert.ToInt32(dataTable.Rows.Count.ToString()); } GVcriterios.DataBind(); } conn.Close(); } catch (Exception ex) { Linfo.Text = "Error al cargar la lista: " + ex.Message; } }
/*Metodos que realizan la consulta con el modificar e inhabilitar*/ private void ResultadoConsulta() { try{ OracleConnection conn = con.crearConexion(); OracleCommand cmd = null; if (conn != null) { string sql = "SELECT CRIT_CODIGO, CRIT_NOMBRE, CRIT_TIPO,CRIT_ESTADO FROM CRITERIOS 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; int cantfilas = Convert.ToInt32(dataTable.Rows.Count.ToString()); Linfo.Text = "Cantidad de filas encontradas: " + cantfilas; } GVcriterios.DataBind(); } conn.Close(); }catch (Exception ex) { Linfo.Text = "Error al cargar la lista: " + ex.Message; } }
/*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; } }