Ch13 Page 457 Step 12

ken evans · October 25th, 2010, 06:26 AM

I can open Reviews.aspx in the browser.
However, When I choose a Genre in the DropDownList, the postback happens but I don't see the list of reviews.

I compared my code with the downloaded source but I can't see any differences.

One small point, the three Management hyperlinks appear above the drop-down list and not to its left.

Any clues?

Thanks
Ken

Here is the code:

Management>Reviews.aspx

Code:

 
<%@ Page Title="Planet Wrox - Management - Reviews" Language="C#" MasterPageFile="~/MasterPages/Management.master" AutoEventWireup="true" CodeFile="Reviews.aspx.cs" Inherits="Management_Reviews" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="cpMainContent" Runat="Server">
  <asp:DropDownList  ID="DropDownList1" runat="server" AppendDataBoundItems="True" 
    AutoPostBack="True" DataSourceID="SqlDataSource1" DataTextField="Name" 
    DataValueField="Id">
    <asp:ListItem Value="">Make a Selection</asp:ListItem>
  </asp:DropDownList>
  <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
    DataKeyNames="Id" DataSourceID="SqlDataSource2">
    <Columns>
      <asp:HyperLinkField DataNavigateUrlFields="Id" 
        DataNavigateUrlFormatString="AddEditReview.aspx?Id={0}" DataTextField="Title" 
        HeaderText="Title" />
      <asp:TemplateField HeaderText="Authorized" SortExpression="Authorized">
       
        <ItemTemplate>
          <asp:Label ID="AuthorizedLabel" runat="server" Text='<%# GetBooleanText(Eval("Authorized")) %>' />
        </ItemTemplate>
      </asp:TemplateField>
      <asp:BoundField DataField="CreateDateTime" HeaderText="CreateDateTime" 
        SortExpression="CreateDateTime" DataFormatString="{0:g}" />
      <asp:CommandField HeaderText="Delete" ShowDeleteButton="True" />
    </Columns>
  </asp:GridView>
  <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
    ConnectionString="<%$ ConnectionStrings:PlanetWroxConnectionString1 %>" 
    
    SelectCommand="SELECT [Id], [Title], [CreateDateTime], [Authorized] FROM [Review] WHERE ([GenreId] = @GenreId)" 
    DeleteCommand="DELETE FROM [Review] WHERE [Id] = @Id" 
    InsertCommand="INSERT INTO [Review] ([Title], [CreateDateTime], [Authorized]) VALUES (@Title, @Authorized, @CreateDateTime )" 
    
    UpdateCommand="UPDATE [Review] SET [Title] = @Title, [Authorized] = @Authorized, [CreateDateTime] = @CreateDateTime,  WHERE [Id] = @Id">
    <DeleteParameters>
      <asp:Parameter Name="Id" Type="Int32" />
    </DeleteParameters>
    <InsertParameters>
      <asp:Parameter Name="Title" Type="String" />
      <asp:Parameter Name="CreateDateTime" Type="DateTime" />
      <asp:Parameter Name="Authorized" Type="Boolean" />
    </InsertParameters>
    <SelectParameters>
      <asp:ControlParameter ControlID="GridView1" Name="GenreId" PropertyName="SelectedValue" Type="Int32" />
    </SelectParameters>
    <UpdateParameters>
      <asp:Parameter Name="Title" Type="String" />
      <asp:Parameter Name="Authorized" Type="Boolean" />
      <asp:Parameter Name="CreateDateTime" Type="DateTime" />
      <asp:Parameter Name="Id" Type="Int32" />
    </UpdateParameters>
  </asp:SqlDataSource>
  <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:PlanetWroxConnectionString1 %>" 
    SelectCommand="SELECT [Id], [Name] FROM [Genre] ORDER BY [SortOrder]">
  </asp:SqlDataSource>
</asp:Content>

Management>Reviews.aspx.cs

Code:

 
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Management_Reviews : System.Web.UI.Page
{
  protected string GetBooleanText(object booleanValue)
  {
    bool authorized = (bool)booleanValue;
    if (authorized)
    {
      return "Yes";
    }
    else
    {
      return "No";
    }
  }

  protected void Page_Load(object sender, EventArgs e)
  {

  }
}

MasterPages>Management.Master

Code:

 

<%@ Master Language="C#" AutoEventWireup="true" CodeFile="Management.master.cs" Inherits="MasterPages_Management" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <asp:ContentPlaceHolder id="head" runat="server">
    </asp:ContentPlaceHolder>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <div style="width: 200px; float: left;"></div>
      <ul>
        <li><a href="~/Management/Default.aspx" runat="server">Management Home</a> </li>
        <li><a href="~/Management/Genres.aspx" runat="server">Manage Genres</a></li>
        <li><a href="~/Management/Reviews.aspx" runat="server">Manage Reviews</a></li>
        
      </ul>
     <div style="width: 750px; float; left;">  
        <asp:ContentPlaceHolder id="cpMainContent" runat="server">
        </asp:ContentPlaceHolder>
    </div>
    </div>
    </form>
</body>
</html>

MasterPages>Management.Master.cs

Code:

 
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class MasterPages_Management : System.Web.UI.MasterPage
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
}

Imar · October 25th, 2010, 06:37 AM

My source:

Code:

 
<SelectParameters>
  <asp:ControlParameter ControlID="DropDownList1" Name="GenreId" PropertyName="SelectedValue" Type="Int32" />
</SelectParameters>

Your source:

Code:

 
<SelectParameters>
  <asp:ControlParameter ControlID="GridView1" Name="GenreId" PropertyName="SelectedValue" Type="Int32" />
</SelectParameters>

You linked it to the GridView instead of the DropDownLisdt.

Hope this helps,

Imar