S
Sparky Arbuckle
My SQL statement is as follows:
Dim strSQL = "SELECT tblDescription.ASIN, tblDescription.strTitle,
tblDescription.strArtist, tblDescription.strReview,
tblDescription.strImageDir, tblStyleASIN.StyleID, tblStyleASIN.ASIN " &
_
"FROM tblStyles INNER JOIN (tblDescription INNER JOIN
tblStyleASIN ON tblDescription.ASIN = tblStyleASIN.ASIN) ON
tblStyles.StyleID = tblStyleASIN.StyleID " & _
"WHERE tblStyles.StyleID = " & strID & ";"
This is bound to a DataList in the body of my ASP.NET page. The problem
is I run into an error when I input the following into my datalist:
<a href="ProductPage.aspx?ASIN=<%# DataBinder.Eval(Container.DataItem,
"ASIN") %>">Read More</a></FONT>
The error I get is:
Exception Details: System.Web.HttpException: DataBinder.Eval:
'System.Data.Common.DbDataRecord' does not contain a property with the
name ASIN
Could it be that I have a couple of different possible ASIN fields such
as tblDescription.ASIN, tblStyleASIN.ASIN, etc. . .? I want
Container.DataItem, "ASIN) to equal tblDescription.ASIN. Is there a way
to go about doing this?
Thanks in advance!
Dim strSQL = "SELECT tblDescription.ASIN, tblDescription.strTitle,
tblDescription.strArtist, tblDescription.strReview,
tblDescription.strImageDir, tblStyleASIN.StyleID, tblStyleASIN.ASIN " &
_
"FROM tblStyles INNER JOIN (tblDescription INNER JOIN
tblStyleASIN ON tblDescription.ASIN = tblStyleASIN.ASIN) ON
tblStyles.StyleID = tblStyleASIN.StyleID " & _
"WHERE tblStyles.StyleID = " & strID & ";"
This is bound to a DataList in the body of my ASP.NET page. The problem
is I run into an error when I input the following into my datalist:
<a href="ProductPage.aspx?ASIN=<%# DataBinder.Eval(Container.DataItem,
"ASIN") %>">Read More</a></FONT>
The error I get is:
Exception Details: System.Web.HttpException: DataBinder.Eval:
'System.Data.Common.DbDataRecord' does not contain a property with the
name ASIN
Could it be that I have a couple of different possible ASIN fields such
as tblDescription.ASIN, tblStyleASIN.ASIN, etc. . .? I want
Container.DataItem, "ASIN) to equal tblDescription.ASIN. Is there a way
to go about doing this?
Thanks in advance!