Hello!
A.
Your book is definately the best I have ever used. I was wondering if the next book called "Professional ASP...." works by the same method with " Try it out " on each chapter as in your book.

B.
When I reached Page 417 step 12 "Bound to:" field I saw that it contains the following options:
1. (Unbound)
2. Id
3. Name

I am asked to select GenreId but that is not available.
Where is my problem?
If it of any use my code is :

<%@PageLanguage="C#"MasterPageFile="~/MasterPages/ManagementMaster.master"AutoEventWireup="true"CodeFile="AddEditReview.aspx.cs"Inherits="Management_AddEditReview"Title="Planet Wrox - Management - Insert and Update Reviews" %>
<asp:ContentID="Content1"ContentPlaceHolderID="head"Runat="Server">
</asp:Content>
<asp:ContentID="Content2"ContentPlaceHolderID="cpMainContent"Runat="Server">
<asp:DetailsViewID="DetailsView1"runat="server"AutoGenerateRows="False"DataKeyNames="Id"DataSourceID="sdsGenres"DefaultMode="Insert"Height="50px"Width="125px">
<Fields>
<asp:BoundFieldDataField="Id"HeaderText="Id"InsertVisible="False"ReadOnly="True"SortExpression="Id"/>
<asp:TemplateFieldHeaderText="Title"SortExpression="Title">
<EditItemTemplate>
<asp:TextBoxID="TextBox1"runat="server"Text='<%# Bind("Title") %>'></asp:TextBox>
<asp:RequiredFieldValidatorID="reqVal1"ControlToValidate="TextBox1"runat="server"ErrorMessage="Please enter a title">
</asp:RequiredFieldValidator>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBoxID="TextBox1"runat="server"Text='<%# Bind("Title") %>'></asp:TextBox>
<asp:RequiredFieldValidatorID="reqVal2"ControlToValidate="TextBox1"runat="server"ErrorMessage="Please enter a title">
</asp:RequiredFieldValidator>
</InsertItemTemplate>
<ItemTemplate>
<asp:LabelID="Label1"runat="server"Text='<%# Bind("Title") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBoxID="TextBox1"runat="server"Text='<%# Bind("Title") %>'></asp:TextBox>
<asp:RequiredFieldValidatorID="reqVal1"ControlToValidate="TextBox1"runat="server"ErrorMessage="Please enter a title">
</asp:RequiredFieldValidator>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBoxID="TextBox1"runat="server"Text='<%# Bind("Title") %>'></asp:TextBox>
<asp:RequiredFieldValidatorID="reqVal2"ControlToValidate="TextBox1"runat="server"ErrorMessage="Please enter a title">
</asp:RequiredFieldValidator>
</InsertItemTemplate>
</asp:TemplateField>
<asp:TemplateFieldHeaderText="Summary"SortExpression="Summary">
<EditItemTemplate>
<asp:TextBoxID="TextBox2"TextMode="MultiLine"Width="500"Height="100"runat="server"Text='<%# Bind("Summary") %>'></asp:TextBox>
<asp:RequiredFieldValidatorID="reqVal3"ControlToValidate="TextBox2"runat="server"ErrorMessage="Please enter a summary">
</asp:RequiredFieldValidator>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBoxID="TextBox2"TextMode="MultiLine"Width="500"Height="100"runat="server"Text='<%# Bind("Summary") %>'></asp:TextBox>
<asp:RequiredFieldValidatorID="reqVal4"ControlToValidate="TextBox2"runat="server"ErrorMessage="Please enter a summary">
</asp:RequiredFieldValidator>
</InsertItemTemplate>
<ItemTemplate>
<asp:LabelID="Label2"runat="server"Text='<%# Bind("Summary") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBoxID="TextBox2"TextMode="MultiLine"Width="500"Height="100"runat="server"
Text='<%# Bind("Summary") %>'></asp:TextBox>
<asp:RequiredFieldValidatorID="reqVal3"ControlToValidate="TextBox2"runat="server"ErrorMessage="Please enter a summary">
</asp:RequiredFieldValidator>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBoxID="TextBox2"TextMode="MultiLine"Width="500"Height="100"runat="server"
Text='<%# Bind("Summary") %>'></asp:TextBox>
<asp:RequiredFieldValidatorID="reqVal4"ControlToValidate="TextBox2"runat="server"ErrorMessage="Please enter a summary">
</asp:RequiredFieldValidator>
</InsertItemTemplate>
</asp:TemplateField>
<asp:TemplateFieldHeaderText="Body"SortExpression="Body">
<EditItemTemplate>
<asp:TextBoxID="TextBox3"runat="server"Text='<%# Bind("Body") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBoxID="TextBox3"runat="server"Text='<%# Bind("Body") %>'></asp:TextBox>
</InsertItemTemplate>
<ItemTemplate>
<asp:LabelID="Label3"runat="server"Text='<%# Bind("Body") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBoxID="TextBox3"TextMode="MultiLine"Width="500"Height="100"runat="server"
Text='<%# Bind("Summary") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBoxID="TextBox3"TextMode="MultiLine"Width="500"Height="100"runat="server"
Text='<%# Bind("Summary") %>'></asp:TextBox>
</InsertItemTemplate>
</asp:TemplateField>
<asp:TemplateFieldHeaderText="GenreId"SortExpression="GenreId">
<EditItemTemplate>
<asp:TextBoxID="TextBox4"runat="server"Text='<%# Bind("GenreId") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:DropDownListID="DropDownList1"runat="server"DataSourceID="sdsGenres"DataTextField="Name"DataValueField="Id">
</asp:DropDownList>
</InsertItemTemplate>
<ItemTemplate>
<asp:LabelID="Label4"runat="server"Text='<%# Bind("GenreId") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:CheckBoxFieldDataField="Authorized"HeaderText="Authorized"SortExpression="Authorized"/>
<asp:BoundFieldDataField="UpdateDateTime"HeaderText="UpdateDateTime"SortExpression="UpdateDateTime"Visible="False"/>
<asp:CommandFieldShowEditButton="True"ShowInsertButton="True"/>
</Fields>
</asp:DetailsView>
<asp:SqlDataSourceID="SqlDataSource1"runat="server"ConnectionString="<%$ ConnectionStrings:PlanetWroxConnectionString1 %>"DeleteCommand="DELETE FROM [Review] WHERE [Id] = @Id"InsertCommand="INSERT INTO [Review] ([Title], [Summary], [Body], [GenreId], [Authorized], [UpdateDateTime]) VALUES (@Title, @Summary, @Body, @GenreId, @Authorized, @UpdateDateTime)"SelectCommand="SELECT [Id], [Title], [Summary], [Body], [GenreId], [Authorized], [UpdateDateTime] FROM [Review] WHERE ([Id] = @Id)"UpdateCommand="UPDATE [Review] SET [Title] = @Title, [Summary] = @Summary, [Body] = @Body, [GenreId] = @GenreId, [Authorized] = @Authorized, [UpdateDateTime] = @UpdateDateTime WHERE [Id] = @Id">
<SelectParameters>
<asp:QueryStringParameterName="Id"QueryStringField="Id"Type="Int32"/>
</SelectParameters>
<DeleteParameters>
<asp:ParameterName="Id"Type="Int32"/>
</DeleteParameters>
<UpdateParameters>
<asp:ParameterName="Title"Type="String"/>
<asp:ParameterName="Summary"Type="String"/>
<asp:ParameterName="Body"Type="String"/>
<asp:ParameterName="GenreId"Type="Int32"/>
<asp:ParameterName="Authorized"Type="Boolean"/>
<asp:ParameterDbType="Date"Name="UpdateDateTime"/>
<asp:ParameterName="Id"Type="Int32"/>
</UpdateParameters>
<InsertParameters>
<asp:ParameterName="Title"Type="String"/>
<asp:ParameterName="Summary"Type="String"/>
<asp:ParameterName="Body"Type="String"/>
<asp:ParameterName="GenreId"Type="Int32"/>
<asp:ParameterName="Authorized"Type="Boolean"/>
<asp:ParameterDbType="DateTime"Name="UpdateDateTime"/>
</InsertParameters>
</asp:SqlDataSource>
<asp:SqlDataSourceID="sdsGenres"runat="server"ConnectionString="<%$ ConnectionStrings:PlanetWroxConnectionString1 %>"SelectCommand="SELECT [Id], [Name] FROM [Genre] ORDER BY [SortOrder]">
</asp:SqlDataSource>
<p>
</p>
</asp:Content>

Hi Dan,

Can you please repost your code and when you do so, use the Remove Code Formatting button on the toolbar to remove the color coding? Due to a bug in this forum all relevant spaces are lost.

Also, are you sure you're opening up the right dialogs for the correct control? GenreId should be available in the binding dialog; just a few lines above the DDL you see this: Bind("GenreId") which implies GenreId is in scope.

Glad to hear you like the book so much...

AFAIK, the Pro series doesn't use Try It Out exercises, but you could download a sample chapter and see if you like it: http://www.wrox.com/WileyCDA/WroxTit...470187573.html

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!