private void poblarControles()
        {
            // Actualizar ComboBox
            comboAdress.DataSource    = null;
            comboAdress.ValueMember   = "Idadress";
            comboAdress.DisplayMember = "address";
            comboAdress.DataSource    = ConsultarAddress.getLista();

            cmbuser.DataSource    = null;
            cmbuser.ValueMember   = "userid";
            cmbuser.DisplayMember = "username";
            cmbuser.DataSource    = ConsultarAppuser.getLista();

            comboBox1.DataSource    = null;
            comboBox1.ValueMember   = "userid";
            comboBox1.DisplayMember = "username";
            comboBox1.DataSource    = ConsultarAppuser.getLista();

            combouserdirrecion.DataSource    = null;
            combouserdirrecion.ValueMember   = "userid";
            combouserdirrecion.DisplayMember = "username";
            combouserdirrecion.DataSource    = ConsultarAppuser.getLista();

            combonegocio.DataSource    = null;
            combonegocio.ValueMember   = "idBusiness";
            combonegocio.DisplayMember = "name";
            combonegocio.DataSource    = ConsultarNegocio.getLista();
        }
        private void actualizarControles()
        {
            // Realizar consulta a la base de datos
            List <Appuser> lista = ConsultarAppuser.getLista();

            // Tabla (data grid view)
            dgvEmpleados.DataSource = null;
            dgvEmpleados.DataSource = lista;
            List <Address> list = ConsultarAddress.getLista();

            datagrid.DataSource = null;
            datagrid.DataSource = list;

            List <Negocio> listaa = ConsultarNegocio.getLista();

            datanegocio.DataSource = null;
            datanegocio.DataSource = listaa;

            List <Producto> ayuda = ConsultarProducto.getLista();

            dataproducto.DataSource = null;
            dataproducto.DataSource = ayuda;

            List <Orden> helpme = ConsultarOrden.getLista();

            dateOrden.DataSource = null;
            dateOrden.DataSource = helpme;

            // Menu desplegable (combo box)
            cmbuser.DataSource    = null;
            cmbuser.ValueMember   = "userid";
            cmbuser.DisplayMember = "username";
            cmbuser.DataSource    = ConsultarAppuser.getLista();

            comboBox1.DataSource    = null;
            comboBox1.ValueMember   = "userid";
            comboBox1.DisplayMember = "username";
            comboBox1.DataSource    = ConsultarAppuser.getLista();



            // Grafico con estadisticas
            poblarGrafico();
        }