web error running chap 12 Customizing GridView Columns

Onypips · March 6th, 2011, 05:35 PM

When I press Ctrl+f5 on step 12 p.407 for the Customizing GridView Columns, the Reviews.aspx web page opens fine. I choose a genre from the dropdownlist - when I do the following web error message shows in a message box titled "Webpage error":

Line: 5
Error: Sys.WebForms.PageRequestManagerServerErrorExceptio n: Could not determine a MetaTable. A MetaTable could not be determined for the data source 'SqlDataSource2' and one could not be inferred from the request URL. Make sure that the table is mapped to the dats source, or that the data source is configured with a valid context type and table name, or that the request is part of a registered DynamicDataRoute.

I redid the entire chapter and copied the PlanetWrox database (.mdf & .ldf) from the source code to the app_data folder and still get the same message.

Help! Any ideas?

Imar · March 6th, 2011, 05:51 PM

Hi there,

Sounds like you used incorrect column types. Can you post your code? Makes it a lot easier to see what's going on.

Cheers,

Imar

Onypips · March 6th, 2011, 08:29 PM

<%@ Page Title="Planet Wrox - Management - Reviews" Language="VB" MasterPageFile="~/MasterPages/ManagementMaster.master" AutoEventWireup="false" CodeFile="Reviews.aspx.vb" Inherits="Management_Reviews" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:DropDownList ID="DropDownList1" runat="server" AppendDataBoundItems="True"
AutoPostBack="True" DataSourceID="SqlDataSource1" DataTextField="Name"
DataValueField="Id">
<asp:ListItem Value="" Selected="True">Please select a genre</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 ConvertEmptyStringToNull="False" HeaderText="Authorized"
SortExpression="Authorized">
<EditItemTemplate>
<asp:DynamicControl ID="DynamicControl1" runat="server" DataField="Authorized"
Mode="Edit" />
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblAuthorized" runat="server" Text='<%# GetBooleanText(Eval("authorized")) %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:DynamicField DataField="CreateDateTime" DataFormatString="{0:d}"
HeaderText="CreateDateTime" />
<asp:CommandField HeaderText="Delete" ShowDeleteButton="True" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:PlanetWroxConnectionString1 %>"

SelectCommand="SELECT [Id], [Title], [Authorized], [CreateDateTime] FROM [Review] WHERE ([GenreId] = @GenreId)"
DeleteCommand="DELETE FROM [Review] WHERE [Id] = @Id"
InsertCommand="INSERT INTO [Review] ([Title], [Authorized], [CreateDateTime]) 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="Authorized" Type="Boolean" />
<asp:Parameter Name="CreateDateTime" Type="DateTime" />
</InsertParameters>
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" 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>
</ContentTemplate>
</asp:UpdatePanel>
</asp:Content>

Imar · March 6th, 2011, 09:02 PM

Hi there,

That's what I thought. Your GridView coontans DynamicFields, for some reason. When you modify the columns, do you see the same options as in Figure 12-12 or do you have other options? You should choose the fields from the Bound Fields list.

When you created the site back in Chapter 2, did you create the correct type? E.g. the ASP.NET Empty web site?

Take a look at the source that comes with the book to see the differences.

Imar

Onypips · March 6th, 2011, 10:14 PM

You are right. Had bound fields and dynamic fields options available in the full list - this time picked the bound fields. It didnt specify to use bound fields in the book so thats why I didnt really look deep into the list.
Works great now! Thanks for your very quick responses!

Howard

Imar · March 7th, 2011, 04:06 PM

I am not sure why you see those fields. I tried a couple of sites in various flavours of Visual Studio and never see those fields appear when I choose the standard ASP.NET Website template.

Anyway, glad you figured it out.

Cheers,

Imar