proprietes d un profile asp net SqlProvider profile

Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
 
<profile defaultProvider="SqlProvider" enabled="true">
            <providers>
                <clear />
                <add name="SqlProvider"
                  type="System.Web.Profile.SqlProfileProvider"
                  connectionStringName="DBprofileConStr"
                  applicationName="ADP.FichesTravaux"
                  description="SqlProfileProvider for ADP.FichesTravaux" />
            </providers>
            <properties>
                <add name="UO_Name" type="System.String" provider="SqlProvider"
                    serializeAs="String"
                     allowAnonymous="true"
                     defaultValue="default property value"
                     readOnly="false"  />         
                </properties>
        </profile>
 
 
en ecriture
/on cree son profil
                ProfileBase prof = ProfileBase.Create(userName, true);
 
                //on ajoute les UO a ses proprietes
                string properties = string.Empty;
                foreach (string UOName in UONames)
                    properties += string.Format("{0},",UOName);
 
                prof.SetPropertyValue(Constant.PROFILE_PROPERTIE_NAME, properties);
                prof.Save();
 
en lecture
 
SettingsContext profileContext = new SettingsContext();
                profileContext.Add("UserName", userName);
                profileContext.Add("IsAuthenticated", true);
 
                //on recupere les proprietes du profil
                SettingsPropertyValueCollection pvalues = provider.GetPropertyValues(profileContext, ProfileBase.Properties);