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