protected void btnAffecter_Click(object sender, EventArgs e)
        {
            AstreeDonnees     ad        = new AstreeDonnees();
            affecterDB        aff       = new affecterDB();
            List <affecterDB> lstAffect = ad.GetAffecter();
            affecterDB        z         = new affecterDB();

            if (txtcode.Text != "")
            {
                List <affecterDB> lstAff = new List <affecterDB>();
                foreach (ListItem x in lstChoisies.Items)
                {
                    aff = new affecterDB();
                    aff.codePermission = Convert.ToInt16(x.Value);
                    aff.codeProfil     = Convert.ToInt16(txtcode.Text);
                    z = lstAffect.Where(w => (w.codeProfil == aff.codeProfil) && (w.codePermission == aff.codePermission)).FirstOrDefault();

                    if (z == null)
                    {
                        lstAff.Add(aff);
                    }
                }
                if (lstAff.Count > 0)
                {
                    ad.InsertAffecter(lstAff);
                    txtcode.Text    = "";
                    txtlibelle.Text = "";
                }
            }
        }
        protected void OnRowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                string   codeProfil   = gv_Profil.DataKeys[e.Row.RowIndex].Value.ToString();
                GridView gvPermission = e.Row.FindControl("gvPermission") as GridView;//Recherche gridview

                AstreeDonnees     a            = new AstreeDonnees();
                List <affecterDB> lsPermission = a.GetAffecter().Where(w => w.codeProfil == Convert.ToInt32(codeProfil)).ToList();

                gvPermission.DataSource = lsPermission;
                gvPermission.DataBind();
            }
        }