This is part four of the ASP.NET Forums Website tutorial. In this tutorial we will create the Post.aspx which will display all of the comments for a given post.
Adding the Post.aspx Page
The next thing that we need to do is add our Post page that will display all of the comments from the Comments table for a given PostId. To begin:
- Right click the project in your Solution Explorer.
- Select Add New Item…
- Select a Web Form and name it Post.aspx.
- Ensure that the Select master page checkbox is checked and click Add.
- Select the MasterPage.master we added earlier and click OK.
Similar to the other pages, we will be using a repeater to display all of the comments given a PostId. To add the repeater, open Post.aspx up to Design mode and:
- Expand the Data tab in your toolbox.
- Drag and drop a Repeater into the ContentPlaceHolder1 on the Web Form.
- Expand the Repeater Tasks Menu.
- In the Choose Data Source DropDownList, select <New Data Source…>.
- In the Data Source Configuration Wizard, select a Sql Database and click OK.
- It will now prompt you to choose your data connection, in the DropDownList select the ForumDBConnectionString we added earlier.
- Next, we need to configure the Select Statement, to do this select the Comments table from the Name DropDownList.
- Click WHERE… to add a Where clause.
- Set the Column to PostId.
- Set the Operator to =.
- Set the Source to QueryString.
- Set the QueryString field to id.
- Click Add.
- Click OK.
- Click ORDER BY…
- Set the Sort by DropDownList to CommentDateTime and choose Descending.
- Click OK.
- Click Next.
- Click Finish.
We are using Server Intellect and have found that by far, they are the most friendly, responsive, and knowledgeable support team we've ever dealt with!
Next, we need to format this repeater to output all of the comments given a PostId into a neat table. To do this, open up the Post.aspx to Source mode and:
- In the Repeater tags, add the following code for the header:
<HeaderTemplate>
<table border="1" width="800px" cellpadding="5px">
</HeaderTemplate> - Under the Header Template tag, add in the following code for the items:
<ItemTemplate>
<tr>
<td align="right">
By: <%# Eval("CommentUserName") %> @ <%# Eval("CommentDateTime") %>
</td>
</tr>
<tr>
<td>
<%# Eval("CommentMessage") %>
</td>
</tr>
</ItemTemplate> - Under the ItemTemplate tag, add in the following code for the footer:
<FooterTemplate>
<tr>
<td>
<a href="NewComment.aspx?id=<%= Request.QueryString["id"] %>">Comment</a>
</td>
</tr>
</table>
</FooterTemplate>
Yes, it is possible to find a good web host. Sometimes it takes a while. After trying several, we went with Server Intellect and have been very happy. They are the most professional, customer service friendly and technically knowledgeable host we've found so far.
At this point, we need to test this out. However, we don’t have any comments in our database so we will need to add a few manually. To do this:
1. Open up the Server or Database Explorer.
2. Right click the Comments table and select Show Table Data.
3. Add in the following entries:
| CommentId | PostId | CommentUserName | CommentMessage | CommentDateTime |
| 1 | 1 | admin | Hello I'm admin | 1/1/2001 12:00:00 AM |
| 2 | 1 | joe | Hello I'm joe | 1/1/2001 12:00:00 AM |
Now that we have come content, let’s test this out. Go ahead and load up the home page and navigate to General Discussion -> Introductions. You should see something like this:
That is pretty much it for the Past page, next we need to add some functionality to our New Post and Comment links.
If you're ever in the market for some great Windows web hosting, try Server Intellect. We have been very pleased with their services and most importantly, technical support.
The Post.aspx source looks like this:
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> |
No comments:
Post a Comment