Documentation Home
Connectors and APIs Manual
Download this Manual
PDF (US Ltr) - 4.5Mb
PDF (A4) - 4.5Mb Tutorial: Web Parts Personalization Provider

MySQL Connector/NET provides a web parts personalization provider that allows you to use a MySQL server to store personalization data.


This feature was added in Connector/NET 6.9.0.

This tutorial demonstrates how to configure the web parts personalization provider using Connector/NET.

Minimum Requirements
  • An ASP.NET website or web application with a membership provider

  • .NET Framework 3.0

  • MySQL 5.5

Configuring MySQL Web Parts Personalization Provider

To configure the provider, do the following:

  1. Add References to MySql.Data and MySql.Web to the website or web application project.

  2. Include a Connector/NET personalization provider into the system.web section in the web.config file.

     <personalization defaultProvider="MySQLPersonalizationProvider">
        <add name="MySQLPersonalizationProvider"
            MySql.Web, Version=, Culture=neutral,
          applicationName="/" />
        <allow verbs="modifyState" users="*" />
        <allow verbs="enterSharedScope" users="*"/>
Creating Web Part Controls

To create the web part controls, follow these steps:

  1. Create a web application using Connector/NET ASP.NET Membership. For information about doing this, see Section, “Tutorial: Connector/NET ASP.NET Membership and Role Provider”.

  2. Create a new ASP.NET page and then change to the Design view.

  3. From the Toolbox, drag a WebPartManager control to the page.

  4. Now define an HTML table with three columns and one row.

  5. From the WebParts Toolbox, drag and drop a WebPartZone control into both the first and second columns.

  6. From the WebParts Toolbox, drag and drop a CatalogZone with PageCatalogPart and EditorZone controls into the third column.

  7. Add controls to the WebPartZone, which should look similar to the following example:

          <asp:WebPartZone ID="LeftZone" runat="server" HeaderText="Left Zone">
              <asp:Label ID="Label1" runat="server" title="Left Zone">
                <asp:BulletedList ID="BulletedList1" runat="server">
                  <asp:ListItem Text="Item 1"></asp:ListItem>
                  <asp:ListItem Text="Item 2"></asp:ListItem>
                  <asp:ListItem Text="Item 3"></asp:ListItem>
          <asp:WebPartZone ID="MainZone" runat="server" HeaderText="Main Zone">
              <asp:Label ID="Label11" runat="server" title="Main Zone">
                <h2>This is the Main Zone</h2>
          <asp:CatalogZone ID="CatalogZone1" runat="server">
              <asp:PageCatalogPart ID="PageCatalogPart1" runat="server" />
          <asp:EditorZone ID="EditorZone1" runat="server">
              <asp:LayoutEditorPart ID="LayoutEditorPart1" runat="server" />
              <asp:AppearanceEditorPart ID="AppearanceEditorPart1" runat="server" />
  8. Outside of the HTML table, add a drop-down list, two buttons, and a label as follows.

    <asp:DropDownList ID="DisplayModes" runat="server" AutoPostBack="True"
    <asp:Button ID="ResetButton" runat="server" Text="Reset"
       OnClick="ResetButton_Click" />
    <asp:Button ID="ToggleButton" runat="server" OnClick="ToggleButton_Click"
       Text="Toggle Scope" />
    <asp:Label ID="ScopeLabel" runat="server"></asp:Label>
  9. The following code fills the list for the display modes, shows the current scope, resets the personalization state, toggles the scope (between user and the shared scope), and changes the display mode.

    public partial class WebPart : System.Web.UI.Page
      protected void Page_Load(object sender, EventArgs e)
        if (!IsPostBack)
          foreach (WebPartDisplayMode mode in WebPartManager1.SupportedDisplayModes)
            if (mode.IsEnabled(WebPartManager1))
        ScopeLabel.Text = WebPartManager1.Personalization.Scope.ToString();
      protected void ResetButton_Click(object sender, EventArgs e)
        if (WebPartManager1.Personalization.IsEnabled &&
      protected void ToggleButton_Click(object sender, EventArgs e)
      protected void DisplayModes_SelectedIndexChanged(object sender, EventArgs e)
        var mode = WebPartManager1.SupportedDisplayModes[DisplayModes.SelectedValue];
        if (mode != null && mode.IsEnabled(WebPartManager1))
          WebPartManager1.DisplayMode = mode;
Testing Web Part Changes

Use the following steps to validate your changes:

  1. Run the application and open the web part page. The page should look like similar to the example shown in the following figure in which the Toggle Scope button is set to Shared. The page also includes the drop-down list, the Reset button, and the Left Zone and Main Zone controls.

    Figure 4.3 Web Parts Page

    Content is described in the surrounding text.

    Initially when the user account is not authenticated, the scope is Shared by default. The user account must be authenticated to change settings on the web-part controls. The following figure shows an example in which an authenticated user is able to customize the controls by using the Browse drop-down list. The options in the list are Design, Catalog, and Edit.

    Figure 4.4 Authenticated User Controls

    Content is described in the surrounding text.

  2. Click Toggle Scope to switch the application back to the shared scope.

  3. Now you can personalize the zones using the Edit or Catalog display modes at a specific user or all-users level. The next figure shows Catalog selected from the drop-down list, which include the Catalog Zone control that was added previously.

    Figure 4.5 Personalize Zones

    Content is described in the surrounding text.