public Filiere get_filiere(string name)
        {
            SqlDataReader rdr       = null;
            SqlConnection con       = new SqlConnection(@"Data Source=KH_B\SQLEXPRESS;Initial Catalog=db_stage;Integrated Security=True");
            string        selectSql = "SELECT * from filieres WHERE name = '" + name + "'";
            SqlCommand    cmd       = new SqlCommand(selectSql, con);

            try
            {
                con.Open();
                rdr = cmd.ExecuteReader();
                while (rdr.Read())
                {
                    filiere = new Filiere((string)rdr["name"], (string)rdr["num_module"],
                                          (string)rdr["nom_module"], (string)rdr["nbr_horaire"], (string)rdr["details"],
                                          (string)rdr["debouches"], (string)rdr["conditions"], (string)rdr["profile_de_formation"]);
                }
            }
            finally
            {
                if (rdr != null)
                {
                    rdr.Close();
                }

                if (con != null)
                {
                    con.Close();
                }
            }
            return(filiere);
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            Filiere filiere = (Filiere)Session["Filiere"];

            title.Text      = filiere.name;
            info.Text       = filiere.details;
            profil.Text     = filiere.profile_de_formation;
            conditions.Text = filiere.conditions;
            debouche.Text   = filiere.debouches;
        }