Preferred Language:

Listing 9.21 - Web.config

Illustrates how to use the ASP.NET ProfileParameter object.

Listing 9.21 - Web.config
Copy 

<?xml version="1.0"?>
<configuration>
    <connectionStrings>
        <add name="GuestBook" connectionString="Data Source=.\SQLEXPRESS;
      AttachDbFilename=|DataDirectory|GuestBookDB.mdf;
Integrated Security=True;User Instance=True" />
    </connectionStrings>

    <system.web>
        <profile enabled="true">
            <properties>
                <add name="DisplayName" defaultValue="Anonymous" />
            </properties>
        </profile>
    </system.web>

</configuration>

The following pages uses the profile property.

Listing 9.22 - ShowProfileParamter.aspx (C#)
Copy 

<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
    <title>Show ProfileParameter</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>

    <asp:FormView
        id="frmGuestBook"
        DataSourceID="srcGuestBook"
        DefaultMode="Insert"
        Runat="server">
        <InsertItemTemplate>
        <asp:Label
            id="lblComments"
            Text="Enter Your Comments:"
            Runat="server" />
        <br />
        <asp:TextBox
            id="txtComments"
            Text='<%# Bind("Comments") %>'
            TextMode="MultiLine"
            Columns="50"
            Rows="4"
            Runat="server" />
        <br />
        <asp:Button
            id="btnInsert"
            Text="Add Comments"
            CommandName="Insert"
            Runat="server" />        
        </InsertItemTemplate>
    </asp:FormView>    

    <hr />
    
    <asp:GridView
        id="grdGuestBook"
        DataSourceID="srcGuestBook"
        Runat="server" />
        
    <asp:SqlDataSource
        id="srcGuestBook"
        SelectCommand="SELECT Name,Comments,EntryDate 
            FROM GuestBook ORDER BY Id DESC"
        InsertCommand="INSERT GuestBook (Name,Comments)
            VALUES (@Name,@Comments)"
        ConnectionString="<%$ ConnectionStrings:GuestBook %>"
        Runat="server">
        <InsertParameters>
            <asp:ProfileParameter Name="Name" PropertyName="DisplayName" /> 
        </InsertParameters>
    </asp:SqlDataSource>
    
    
    </div>
    </form>
</body>
</html>