public C_t_specialites Lire_ID(int IDSpe)
        {
            CreerCommande("Selectionnert_specialites_ID");
            Commande.Parameters.AddWithValue("@IDSpe", IDSpe);
            Commande.Connection.Open();
            SqlDataReader   dr  = Commande.ExecuteReader();
            C_t_specialites res = new C_t_specialites();

            while (dr.Read())
            {
                res.IDSpe  = int.Parse(dr["IDSpe"].ToString());
                res.NomSpe = dr["NomSpe"].ToString();
            }
            dr.Close();
            Commande.Connection.Close();
            return(res);
        }
        public List <C_t_specialites> Lire(string Index)
        {
            CreerCommande("Selectionnert_specialites");
            Commande.Parameters.AddWithValue("@Index", Index);
            Commande.Connection.Open();
            SqlDataReader          dr  = Commande.ExecuteReader();
            List <C_t_specialites> res = new List <C_t_specialites>();

            while (dr.Read())
            {
                C_t_specialites tmp = new C_t_specialites();
                tmp.IDSpe  = int.Parse(dr["IDSpe"].ToString());
                tmp.NomSpe = dr["NomSpe"].ToString();
                res.Add(tmp);
            }
            dr.Close();
            Commande.Connection.Close();
            return(res);
        }