Linking Reviews to ViewDetails Form

trtyler · October 4th, 2016, 02:11 PM

Does anyone have any suggestions on how one might link the individual Reviews in the "BulletedList" of the "AllByGenre" Form with the "ViewDetails" Form. I've tried a number of approaches but can not seem to find a way to pass the "ReviewId" to the url for the ViewDetails.aspx. For example, something like the following:

<asp:BulletedList ID="ReviewList" runat="server" DisplayMode="LinkButton"
DataSource = '<%# Eval("Reviews") %>' DataTextField="Title" DataValueField="Id"
NavigateUrl='<%# "ViewDetails?ReviewId=" + Reviews.Id.ToString()%>'>

gives the following error:Reviews does not exist in current context.

or alternatively something like the following:

<asp:BulletedList ID="ReviewList" runat="server" DisplayMode="LinkButton" DataSource = '<%# Eval("Reviews") %>' DataTextField="Title" DataValueField="Id" NavigateUrl='<%# "ViewDetails?ReviewId=" + Eval("Id")%>'>

gives the following error message: System.Web.HttpException: DataBinding: does not contain a property with the name 'Id'.

Any suggestions would be greatly appreciated.

T.

Imar · October 5th, 2016, 03:36 AM

Hi there,

Can you provide your full code including code behind? Is your database scheme exactly the same as in the book?

Imar

trtyler · October 5th, 2016, 12:34 PM

Imar:

My code is given below. Itâs pretty much the same as in the book with the exception that Iâve changed some names: Reviews = Songs, Genre = Bands and PlanetWroxEntities becomes TRTDevelopmentSongsAndBandsEntities. I know what Iâm asking extends what is presented in the book but as I looked at my web site I felt it really needed to have functionality equivalent to that seen in the âAll.aspxâ and âMy Favorite Reviewsâ pages. However, after several days and a lot of "Googling" I have simply not been able to implement that functionality. I donât even know if Iâm on the right tract.

For the present I have implemented a solution on my web site that I hate. Iâve inserted a second bulleted list underneath that of in the âAllSongsByBand.aspxâ form using the âDataDisplayMode = âHyperLinkâ and âDataTextField =âClipLinkââ (a filed I've inserted into the "Songs" table that provides a url link to a clip of the song). This works to an extent but does not link the âViewDetailâ Form, looks awful, and is not acceptable.

The âViewDetails.aspxâ and âViewDetails.aspx.csâ look pretty much the same as in the book with the exception that Iâve changed names (âSongsâ and âBandsâ again) and added a couple of additional fields to display. If you need to look at the code I can send it.

I appreciate your rapid response. Any guidance or pointers or even an opinion as to whether or not Iâm on the right tract would be greatly appreciated.

I'm greatly indebted to you as this is my first real attempt a creating a web site. My site does work perfectly anologus to that you have created in the book and with the knowledge you provided have been able to make some adaptations. I still have a lot nore to learn, however, about how Asp.Net works :-)

Thanks

Code:

<%@ Page Title="All Songs By A Band" Language="C#" MasterPageFile="~/MasterPages/Frontend.master"
  AutoEventWireup="true" CodeFile="AllSongsByBand.aspx.cs" Inherits="Songs_AllSongsByBand" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="cpMainContent" runat="Server">
  <asp:Repeater ID="Repeater1" runat="server">
    <ItemTemplate>
      <h3>
        <asp:Literal ID="Literal1" runat="server" Text='<%# Eval("Band1")
 %>'></asp:Literal>
      </h3>
      <asp:BulletedList ID="SongList" runat="server" 
    DataSource='<%# Eval ("Songs") %>' DataTextField="Title" 
    DisplayMode="Text">
      </asp:BulletedList>
    </Itemtemplate>
  </asp:Repeater>
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="cpClientScript" runat="Server">
</asp:Content>

And the âCode Behindâ

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 Songs_AllSongsByBand : BasePage
{
    protected void Page_Load(object sender, EventArgs e)
    {
      using (TRTDevelopmentSongsAndBandsEntities MyEntities = new
TRTDevelopmentSongsAndBandsEntities())
      {
        var AllBands = from Band in MyEntities.Bands.Include("Songs")
                       orderby Band.Band1
                       select new { Band.Band1, Band.Songs};
        Repeater1.DataSource = AllBands.ToList();
        Repeater1.DataBind();
      }
    }
  }

trtyler · October 6th, 2016, 05:59 PM

Ok, after about three weeks of frustration, the answer was already there in the project. Essential I got rid of the "BulletedList" (I did need a whole new approach). I then used the code that was already present in the "Default" form of the "Reviews" folder: This is the code that lists the favorite genre from the "myProfile" list. so the code in the "AllReviewsByGenre" form looks like this:

Code:

 <asp:Repeater ID="BandRepeater" runat="server">
    <HeaderTemplate>
      <p>Below you will find a list of songs for each of your favorite bands.</p>
    </HeaderTemplate>
    <ItemTemplate>
      <h3>
        <asp:Literal ID="Literal1" runat="server" Text='<%# Eval("Band1") %>'></asp:Literal>
      </h3>
      <h4>
        <asp:Literal ID="Literal2" runat="server" Text='<%# Eval("Notes") %>'></asp:Literal>
      </h4>
        <asp:Repeater ID="SongRepeater" runat="server" ItemType="Song" DataSource='<%# Eval("Songs") %>'>
          <ItemTemplate>
            <asp:HyperLink ID="HyperLink1" CssClass="HyperLinkBullet" runat="server" Text='<%# Item.Title %>'
              NavigateUrl='<%# "ViewDetails?SongId=" + Item.Id.ToString() %>'>
            </asp:HyperLink><br />
          </ItemTemplate>
        </asp:Repeater>
    </ItemTemplate>
  </asp:Repeater>

[NB: remember I have replaced "Genre with "Bands" and "Reviews" with "Songs"]

I've added a CssClass to the Hyperlink and added the following styling for that class:

Code:

.HyperLinkBullet

{
    display: list-item;
    list-style-type: disc;
    margin-top: 10px
}

The code behind is essentially the same as that in "Default.aspx.cs" in the Songs folder.

The solution works well and actually provides more flexability in styling the bullet types.

Hopefully this may help any others wishing to modify a "BulletedList" styling. Anyone wishing to see the result can go to TRTDevelopment.com :-)

T.

Imar · October 8th, 2016, 07:52 AM

Yeah, I was going to suggest the same thing; just didn't have the time to post earlier.

Cheers,

Imar