9: Building a Content Management System in .NET

Printing Code 39 Extended in .NET 9: Building a Content Management System

ControlToValidate= txtInsertTitle ErrorMessage= Title is required Display= Dynamic /> </InsertItemTemplate> </asp:TemplateField> <asp:TemplateField ShowHeader= True 13 HeaderText= Text: HeaderStyle-Width= 80px HeaderStyle-VerticalAlign= Top > <ItemTemplate> 14 <asp:TextBox ID= txtItemContent runat= server Text= <%# Eval( content ) %> ReadOnly= True TextMode= MultiLine Width= 250px Height= 200px /><br /> </ItemTemplate> <EditItemTemplate> 15 <asp:TextBox ID= txtEditContent runat= server Text= <%# Bind( content ) %> TextMode= MultiLine Width= 250px Height= 200px BackColor= LightBlue /><br /> <asp:RequiredFieldValidator ID= RequiredFieldValidator3 runat= server ControlToValidate= txtEditContent ErrorMessage= Text is required Display= Dynamic /> </EditItemTemplate> <InsertItemTemplate> 16 <asp:TextBox ID= txtInsertContent runat= server Text= <%# Bind( content ) %> TextMode= MultiLine Width= 250px Height= 200px BackColor= LightBlue /><br /> <asp:RequiredFieldValidator ID= RequiredFieldValidator4 runat= server ControlToValidate= txtInsertContent ErrorMessage= Text is required Display= Dynamic /> </InsertItemTemplate> </asp:TemplateField> </Fields> </asp:DetailsView> <asp:SqlDataSource ID= SqlDataSource2 17 runat= server ConnectionString= <%$ ConnectionStrings: ConnectionString %> OldValuesParameterFormatString= original_{0}

(continued)

Listing 9-9 (continued)

SelectCommand= SELECT 18 [contentid], [title], [content] FROM [ContentItems] WHERE ([contentid] = @contentid) UpdateCommand= UPDATE [ContentItems] 19 SET [title] = @title, [content] = @content WHERE [contentid] = @original_contentid DeleteCommand= DELETE 20 FROM [ContentItems] WHERE [contentid] = @original_contentid InsertCommand= INSERT 21 INTO [ContentItems] ([title], [content], [typeid], [deptid]) VALUES (@title, @content, @typeid, @deptid) > <SelectParameters> 22 <asp:QueryStringParameter Name= contentid QueryStringField= item Type= Int32 /> </SelectParameters> <UpdateParameters> 23 <asp:Parameter Name= title Type= String /> <asp:Parameter Name= content Type= String /> <asp:Parameter Name= original_contentid Type= Int32 /> </UpdateParameters> <DeleteParameters> 24 <asp:Parameter Name= original_contentid Type= Int32 /> </DeleteParameters> <InsertParameters> 25 <asp:Parameter Name= title Type= String /> <asp:Parameter Name= content Type= String /> <asp:QueryStringParameter Name= deptid QueryStringField= dept Type= String /> <asp:QueryStringParameter Name= typeid QueryStringField= type Type= String /> </InsertParameters> </asp:SqlDataSource> <br /> <asp:LinkButton ID= btnReturn 26 runat= server Text= Return to list OnClick= btnReturn_Click /> </asp:Content>

Brace yourself the following paragraphs describe the 26 essential tenets of this listing:

You will need to change this Page directive if you use the VB version of the code-behind file Specifically, you ll need to change the Language, AutoEventWireup, and CodeFile attributes to VB, False, and Detailaspxvb The first <Content> element displays the department name at the top of the page This FormView is bound to the SqlDataSource1 data source and displays the department name This Label control displays the name field The first SQL data source (SqlDataSource1) retrieves the department name, using a parameter named deptid to specify the department to retrieve The deptid parameter is a query parameter, taking its value from the dept query string The second <Content> element provides the main content for the page The DetailsView control displays the title and text for the selected content item, which is retrieved by the SqlDataSource2 data source If you re working in Visual Basic, you should drop the OnItemDeleted, OnItemInserted, or OnItemCommand attributes

2 3 4 5

6 7 8

9 10

This <TemplateField> element is the first of two fields contained in the <Fields> element for the DetailsView control The Item template is used to display the content item s title when the DetailsView control is displayed in Read-Only mode It consists of a single read-only text box that uses the Eval method to bind to the title field of the data source The EditItem template is displayed when the user clicks the Edit link to edit a content item It includes two controls: a text box that uses the Bind method to bind to the title field, and a RequiredFieldValidator that ensures that the user enters a value for the title (Notice that the background color for the text box is set to blue to provide a visual clue that the page is in Edit mode) The InsertItem template is displayed when the DetailsView control enters Insert mode That happens when the Detailsaspx page is called with -1 as the value of the item query string This

11

12