protected void Button1_Click(object sender, EventArgs e)
    {
        ds_test ds_dnn = new ds_test();
        ds_test.aspnet_UsersRow aspuser = ds_dnn.aspnet_Users.Newaspnet_UsersRow();
        ds_test.aspnet_ApplicationsRow apli=ds_dnn.aspnet_Applications.Newaspnet_ApplicationsRow();
       ds_test.UsersRow u = ds_dnn.Users.NewUsersRow();
       ds_test.aspnet_MembershipRow asp = ds_dnn.aspnet_Membership.Newaspnet_MembershipRow();
    ds_enregistrement_candidat ds = new ds_enregistrement_candidat();
    ds_enregistrement_candidat.CandidatRow r = ds.Candidat.NewCandidatRow();
    ds_enregistrement_candidat.SituationActuelleRow s = ds.SituationActuelle.NewSituationActuelleRow();
    ds_enregistrement_candidat.formationRow f = ds.formation.NewformationRow();
    ds_enregistrement_candidat.formationCandidatRow fc = ds.formationCandidat.NewformationCandidatRow(); 
    ds_enregistrement_candidat.ExperienceRow ex = ds.Experience.NewExperienceRow();
   u.Username = txt_email.Text;
   u.LastName = txt_nom.Text;
   u.IsSuperUser = false;
   u.Email = txt_email.Text;
   u.DisplayName = txt_prenom.Text;
   u.FirstName = txt_prenom.Text;
   u.UpdatePassword = false;
   asp.Email = txt_email.Text;
   asp.Password = mdp1.Text; 
        asp.Passwordformat = 2;
        asp.PasswordSalt = mdp2.Text;
        asp.IsApproved=true;
        asp.IsLockedOut = false;
        asp.CreateDate = DateTime.Now;
        asp.LastLoginDate = DateTime.Now;
        asp.LastLockoutDate = DateTime.Now;
        asp.LastPasswordChangedDate = DateTime.Now;
        asp.FailedPasswordAnswerAttemptCount=0;
        asp.FailedPasswordAttemptWindowStart = DateTime.Now;
        asp.FailedPasswordAnswerAttemptCount =0;
        asp.FailedPasswordAnswerAttemptWindowStart = DateTime.Now;
        string monGuidStr ="5fa67d63-e30f-4b1e-b7eb-e9a204eba969";
        Guid g = new Guid(monGuidStr);
        asp.ApplicationId = g;
        
       int idc = r.idcandidat;
      
       Guid id = Guid.NewGuid();
       asp.UserId = id;
       //aspuser.UserId = asp.UserId;
        int ids;
        ids = s.idSituation;
        int idf = f.idformation;
        fc.idformation = idf;
        fc.idcandidat = idc;
        r.nom = txt_nom.Text;
        r.prenom = txt_prenom.Text;
        r.ville = txt_ville.Text;
      
        r.emailLogin = txt_email.Text;
        r.mdp = mdp1.Text;
        r._date = txt_date.Text;
 
        r.idSituation = ids;
 
        ds.Candidat.AddCandidatRow(r);
       ds_enregistrement_candidatTableAdapters.CandidatTableAdapter ta = new ds_enregistrement_candidatTableAdapters.CandidatTableAdapter();
        ta.Update(ds.Candidat);
 
        ds_dnn.Users.AddUsersRow(u);
        ds_testTableAdapters.UsersTableAdapter tu = new ds_testTableAdapters.UsersTableAdapter();
        tu.Update(ds_dnn.Users);
 
        ds_dnn.aspnet_Membership.Addaspnet_MembershipRow(asp);
        ds_testTableAdapters.aspnet_MembershipTableAdapter tasp = new ds_testTableAdapters.aspnet_MembershipTableAdapter();
        tasp.Update(ds_dnn.aspnet_Membership);
    }