Add a subroutine called Ddl1_SelectedIndexChanged to handle the in .NET framework

Encoding GS1 - 12 in .NET framework Add a subroutine called Ddl1_SelectedIndexChanged to handle the

The routine calls the ShowProfileData() method, passing it the user s choice to view profiles of authenticated users, anonymous users, or both Here s what it looks like:

Protected Sub Ddl1_SelectedIndexChanged _ (ByVal sender As Object, ByVal e As SystemEventArgs) ShowProfileData _ (CType(Ddl1SelectedValue, _ ProfileAuthenticationOption)) End Sub

Figure 2-7 shows a sample result Profiles for authenticated users include the username rather than a generated identifier It may be hard to see in Figure 2-7, but notice that IsAnonymous is false (that is, unchecked) for users who have logged in

There are two key parts to the ShowProfileData() The first gets a reference to the current provider by passing the name of the provider (AspNet SqlProfileProvider) to the Profile object s Providers collection The Providers collection contains all providers registered in the configuration file

Provider = ProfileProviders _ ( AspNetSqlProfileProvider )

The second key part to the routine is the GetAllProfiles() function Here, you pass an authentication option, page-index and size values, and a reference to an integer variable (totalRecords ) The function returns a Profile InfoCollection that you can consume directly as a GridView control s data source The function fills the variable (which you pass by reference) with the number of records

GridView1DataSource = ProviderGetAllProfiles _ (PFO, pageIndex, pageSize, totalRecords)

When you allow anonymous profiles for a busy site, the database can expand rapidly Many visitors might not return for months if ever but their

profiles remain If users delete their cookies, the profile becomes an orphan record Fortunately, you don t need to be a SQL guru to maintain the profiles database and get rid of inactive profiles

Without reading users minds, it s hard to know when their profiles become inactive You can t say whether they intend to come back It s also a question of degree If someone hasn t visited your pages in 30 days, does that mean you have to make that profile inactive The cut-off point amounts to a judgment call ASPNET provides a DeleteInactiveProfiles() method that strips unwanted profiles from the database You have to tell the method which profiles you want to delete authenticated, anonymous, or all and set a date before which the system should consider the profile inactive For demonstration purposes, this section removes anonymous profiles that haven t been used (let s say) in a whole day

1 Add an ASPNET page called deleteprofilesaspx to your project 2 Add a Label control called Label1 and a Button control called

The markup looks like the following:

<asp:label id= Label1 runat= server > Click to delete records </asp:label> <br /> <asp:button id= Button1 runat= server onclick= Button1_Click text= Delete Profiles />

4 Add the following code as the event handler:

Protected Sub Button1_Click _ (ByVal sender As Object, _ ByVal e As SystemEventArgs) Dim Provider As SqlProfileProvider Dim dtInactiveSince As DateTime Dim retValue As Integer dtInactiveSince = DateAdd _ (DateIntervalDay, -1, Now) Provider = ProfileProviders _ ( AspNetSqlProfileProvider )

retValue = ProviderDeleteInactiveProfiles _ (ProfileAuthenticationOptionAnonymous, _ dtInactiveSince) Label1Text = Deleted & _ retValueToString & records End Sub

The routine deletes anonymous profiles that are more than a day old The label shows the number of records deleted The variable dtInactiveSince holds a calculated date In this case, we determine the date using the DateAdd() function The date is one day (-1) before right now (Now) Next, we get an instance of the Provider object by referencing our registered provider, AspNetSqlProfileProvider The DeleteInactiveProfiles() function returns the number of records deleted We display the returned value in Label1 To delete only authenticated profiles, pass the following:

ProfileAuthenticationOptionAuthenticated to DeleteInactiveProfiles()

You can remove specific profiles using the DeleteProfiles() method The first version of the method takes a ProfileInfoCollection object That s fine if you re deleting a large number of profiles because it deletes them as a group However, if you just want to surgically remove one or two profiles, there s a simpler version of the method (an override in geek-speak) that works with the username(s) in a string array as a parameter

1 Add an ASPNET page called deleteaprofileaspx to your project 2 Add a Label control called Label1 and a Button control called