protected void UserProfileDataSource_Inserting(object sender, SqlDataSourceCommandEventArgs e)
        {
            int              visibleindex = MainGridView.FocusedRowIndex;
            ASPxGridView     sousgrid     = MainGridView.FindDetailRowTemplateControl(visibleindex, "ThemeGridSite") as ASPxGridView;
            ASPxCheckBoxList listTiers    = sousgrid.FindEditFormTemplateControl("chkListTiers") as ASPxCheckBoxList;
            string           ListTiers    = "";

            foreach (string val in listTiers.SelectedValues)
            {
                ListTiers += val + ";";
            }

            ASPxCheckBoxList listJour = sousgrid.FindEditFormTemplateControl("chkListJourn") as ASPxCheckBoxList;
            string           ListJour = "";

            foreach (string val in listJour.SelectedValues)
            {
                ListJour += val + ";";
            }

            ASPxCheckBoxList listaffichmontant = sousgrid.FindEditFormTemplateControl("ASPxCheckAfficherMontant") as ASPxCheckBoxList;
            string           affichmontant     = "0";

            foreach (string val in listaffichmontant.SelectedValues)
            {
                affichmontant = val;
            }

            ASPxCheckBoxList listaccederdate = sousgrid.FindEditFormTemplateControl("ASPxCheckAccederDate") as ASPxCheckBoxList;
            string           accederdate     = "0";

            foreach (string val in listaccederdate.SelectedValues)
            {
                accederdate = val;
            }

            //ASPxCheckBoxList listDoc = sousgrid.FindEditFormTemplateControl("chkListDoc") as ASPxCheckBoxList;
            //string ListDoc = "";
            //foreach (string val in listDoc.SelectedValues)
            //{
            //    ListDoc += val + ";";
            //}

            e.Command.Parameters[2].Value = ListJour;
            e.Command.Parameters[3].Value = ListTiers;

            e.Command.Parameters[5].Value = affichmontant;
            e.Command.Parameters[6].Value = accederdate;
            //e.Command.Parameters[4].Value = ListDoc;
        }