Part V: Building Community Applications in .NET framework

Generator Code 39 Full ASCII in .NET framework Part V: Building Community Applications

The second <Content> element provides the content displayed in the main portion of the page For the Login page, the only item here is the Login control, described in the next paragraph The Login control displays the labels, text boxes, and buttons necessary to let the user log in For more information about using the Login control, refer to 4

The Home page (Defaultaspx) displays a greeting and a list of the departments The department list is a little redundant, since the sidebar in the Master Page also displays a list of the departments However, the list displayed in the main area of the Home page includes the department descriptions in addition to the names Listing 9-4 shows the aspx code for this page A code-behind file isn t required Refer to Figure 9-3 for a refresher of what this page looks like

Listing 9-4:

The Home page (Defaultaspx)

<%@ Page Language= C# 1 MasterPageFile= ~/MasterPagemaster AutoEventWireup= true CodeFile= Defaultaspxcs Inherits= _Default Title= Company Intranet %> <asp:Content ID= Content1 2 ContentPlaceHolderID= ContentPlaceHolder1 Runat= Server > <h1> Welcome to the Company Intranet </h1> </asp:Content> <asp:Content ID= Content2 3 ContentPlaceHolderID= ContentPlaceHolder2 Runat= Server > Welcome to our fabulous new company Intranet, where<br /> each department of our growing company can customize<br /> its own page<br /><br /> Which department would you like to visit <br /><br /><br /> <asp:Repeater ID= Repeater1 runat= Server 4 DataSourceID= SqlDataSource1 > <ItemTemplate> <asp:LinkButton ID= LinkButton1 5 runat= server Text= <% #Eval( name ) %> PostBackUrl= <% #Eval( deptid ,

DeptHomeaspx dept={0} ) %> />  --  <asp:Label ID= Label1 runat= server Text= <% #Eval( description ) %> /> <br /> </ItemTemplate> </asp:Repeater> <asp:SqlDataSource ID= SqlDataSource1 runat= server ConnectionString= <%$ ConnectionStrings: ConnectionString %> SelectCommand= SELECT [deptid], [name], [description] FROM [Departments] ORDER BY [name] > </asp:SqlDataSource> </asp:Content> Here are the secrets to understanding this listing:

6 7

As usual, the Page directive has to be changed if you re working in VB Specifically, you should change the Language, AutoEventWireup, and CodeFile attributes The first <Content> element provides the heading Welcome to the Company Intranet at the top of the page The second <Content> element begins with several lines of text The Repeater control displays the list of departments It s bound to the data source named SqlDataSource1 The LinkButton control displays the name field and uses the deptid field as the value of the dept query string in the PostBack URL For example, if the user clicks the link for the Human Resources department, the PostBack URL will be DeptHomeaspx dept=hr This odd-looking construction displays a space, two hyphens, and another space to separate the department name from the description This Label control displays the description field from the data source The data source uses a simple SELECT statement to retrieve the deptid, name, and description columns for each row in the Departments table

2 3 4 5

7 8

The Department Home page (DeptHomeaspx) is the home page for the department, as chosen by the user It displays the department s description

and a list of the content types This page was illustrated back in Figure 9-4, and Listing 9-5 shows the aspx code No code-behind file is required for this page but the page does contain an expression that must be coded differently depending on the language you re using This page is displayed when the user clicks one of the department links that appear in the Master Page or on the Home page (Defaultaspx) Either way, the PostBack URL for the Department link passes the ID of the selected department as a query string with the name dept

Listing 9-5:

The Department Home page (DeptHomeaspx)

<%@ Page Language= C# MasterPageFile= ~/MasterPagemaster AutoEventWireup= true CodeFile= DeptHomeaspxcs Inherits= DeptHome Title= Company Intranet %> <asp:Content ID= Content1 Runat= Server ContentPlaceHolderID= ContentPlaceHolder1 >

<asp:FormView ID= FormView1 runat= server 3 DataKeyNames= deptid DataSourceID= SqlDataSource1 > <ItemTemplate> <h1> <asp:Label ID= nameLabel runat= server 4 Text= <%# Eval( name ) %> ></asp:Label> </h1> </ItemTemplate> </asp:FormView> <asp:SqlDataSource ID= SqlDataSource1 runat= server ConnectionString= <%$ ConnectionStrings: ConnectionString %> SelectCommand= SELECT [deptid], [name] FROM [Departments] WHERE [deptid] = @deptid ORDER BY [name] > <SelectParameters> <asp:QueryStringParameter Name= deptid QueryStringField= dept Type= String /> </SelectParameters> </asp:SqlDataSource> </asp:Content> <asp:Content ID= Content2 Runat= Server