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