>Hi John,
>
>My page tries to get profile information and here is what I see in the stack info:
>
>> App_SubCode_Providers.w6sws4ti.dll!Microsoft.Samples.SqlTableProfileProvider.GetProfileDataFromTable(System.Configuration.SettingsPropertyCollection properties = {System.Configuration.SettingsPropertyCollection}, System.Configuration.SettingsPropertyValueCollection svc = {System.Configuration.SettingsPropertyValueCollection}, string username = "agreen", System.Data.SqlClient.SqlConnection conn = {System.Data.SqlClient.SqlConnection}) Line 232 + 0x22 bytes C#
> App_SubCode_Providers.w6sws4ti.dll!Microsoft.Samples.SqlTableProfileProvider.GetPropertyValues(System.Configuration.SettingsContext context = Count = 2, System.Configuration.SettingsPropertyCollection collection = {System.Configuration.SettingsPropertyCollection}) Line 272 + 0x14 bytes C#
> [External Code]
> App_Code.8_hs3bpu.dll!ProfileCommon.SiteID.get() Line 30 + 0xd bytes C#
> App_Web_qzmcp6zp.dll!AddUsers_Default.GetSiteUsers() Line 179 + 0x29 bytes C#
> App_Web_qzmcp6zp.dll!AddUsers_Default.PopRoles() Line 91 + 0x13 bytes C#
> App_Web_qzmcp6zp.dll!AddUsers_Default.Page_Load(object sender = {ASP.addusers_default_aspx}, System.EventArgs e = {System.EventArgs}) Line 31 + 0x7 bytes C#
> [External Code] >
>GetSiteUsers method has the following code:
>
>
>private MembershipUserCollection GetSiteUsers()
> {
> MembershipUserCollection siteMembers = new MembershipUserCollection();
> MembershipUserCollection Members = Membership.GetAllUsers();
>
> foreach (MembershipUser CurrUser in Members)
> {
> if (Profile.GetProfile(CurrUser.UserName).SiteID == Profile.SiteID &&
> !Roles.IsUserInRole(CurrUser.UserName, "MasterAdmin"))
> {
> siteMembers.Add(CurrUser);
> }
> }
> return siteMembers;
> }>
>What I don't understand is why private void GetProfileDataFromTable(SettingsPropertyCollection properties, SettingsPropertyValueCollection svc, string username, SqlConnection conn) method tries to update last activity date?
>
>If we're only trying to access the data, why do we need to update the information?
Is the purpose of GetProfileDataFromTable to get the users info when he logs in, or to get it to display it to other users or admins?
If it's for log in, then updating the access date makes sense, if not then it doesn't.
