protected void cmbAnio_SelectedIndexChanged(object sender, EventArgs e)
    {
        dalTablero.SatisfaccionEncuestas _dal = new dalTablero.SatisfaccionEncuestas();

        this.cmbMes.DataSource = _dal.Listar_Meses(this.cmbAnio.SelectedValue);
        this.cmbMes.DataValueField = "CODIGO";
        this.cmbMes.DataTextField = "MES";
        this.cmbMes.DataBind();

        _dal = null;
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!(Page.IsPostBack))
        {
            dalTablero.SatisfaccionEncuestas _dal = new dalTablero.SatisfaccionEncuestas();

            this.cmbAnio.DataSource = _dal.Listar_Anios();
            this.cmbAnio.DataTextField = "ANIO";
            this.cmbAnio.DataBind();

            this.cmbAnio.SelectedValue = Convert.ToString(DateTime.Now.Year);

            this.cmbMes.DataSource = _dal.Listar_Meses(this.cmbAnio.SelectedValue);
            this.cmbMes.DataValueField = "CODIGO";
            this.cmbMes.DataTextField = "MES";
            this.cmbMes.DataBind();

            this.cmbMes.SelectedValue = Convert.ToString(DateTime.Now.Month);

            this.cmbTip.DataSource = _dal.Listar_Tipos();
            this.cmbTip.DataTextField = "TIPO";
            this.cmbTip.DataBind();

            this.cmbGru.DataSource = _dal.Listar_Grupos();
            this.cmbGru.DataTextField = "GRUPO";
            this.cmbGru.DataBind();

            this.cmbAre.DataSource = _dal.Listar_Areas();
            this.cmbAre.DataTextField = "AREA";
            this.cmbAre.DataBind();

            this.cmbAre.Items.Insert(0, new ListItem("[TODOS]", ""));
            this.cmbGru.Items.Insert(0, new ListItem("[TODOS]", ""));
            this.cmbTip.Items.Insert(0, new ListItem("[TODOS]", ""));

            _dal = null;
        }
    }