Пример #1
0
        public void listReservation()
        {
            Emprinte[] emprintes = MainUI.sbo.listReservation();

            DataTable dt = new DataTable();

            for (int i = 1; i < 5; i++)
            {
                dt.Columns.Add("" + i + "");
            }

            for (int i = 0; i < emprintes.Length; i++)
            {
                DataRow  row = dt.NewRow();
                Emprinte e   = emprintes[i];
                row["1"] = e.NumeroEmprinte;
                row["2"] = e.DateReservation;
                row["3"] = e.NomUtilisateurEmprenteur;
                row["4"] = e.CodeOuvrague;

                dt.Rows.Add(row);
            }


            BindingSource bs = new BindingSource();

            bs.DataSource = dt;
            GridReservation.DataSource = bs;
        }
        private static Emprinte[] listReservationExpirer()
        {
            RequeteOuvragueExe roe = new RequeteOuvragueExe();
            IDataReader        idr = roe.listReservationExpirer();

            List <Emprinte> listEmprente = new List <Emprinte>();

            while (idr.Read())
            {
                Emprinte e = new Emprinte();

                e.NumeroEmprinte           = Convert.ToString(idr.GetInt64(0));
                e.CodeOuvrague             = idr.GetString(1);
                e.NomUtilisateurEmprenteur = idr.GetString(2);

                listEmprente.Add(e);
            }
            return(listEmprente.ToArray());
        }
Пример #3
0
        public void listReservation()
        {
            String nomU;

            if (Acceuil.estEnseignant)
            {
                nomU = Acceuil.CompteEnseigant.Nom_utilisteur;
            }
            else
            {
                nomU = Acceuil.compteEtudiant.Nom_utilisteur;
            }

            Emprinte[] emprintes = Acceuil.sco.mesReservation(nomU);

            DataTable dt = new DataTable();

            for (int i = 1; i < 5; i++)
            {
                dt.Columns.Add("" + i + "");
            }

            for (int i = 0; i < emprintes.Length; i++)
            {
                DataRow  row = dt.NewRow();
                Emprinte e   = emprintes[i];
                row["1"] = e.NumeroEmprinte;
                row["2"] = e.DateReservation;
                row["3"] = e.NomUtilisateurEmprenteur;
                row["4"] = e.CodeOuvrague;

                dt.Rows.Add(row);
            }


            BindingSource bs = new BindingSource();

            bs.DataSource = dt;
            GridReservation.DataSource = bs;
        }