BindItemDetail Function

This function is used to pull the item details from the PDshop database; so that it can be displayed on your page (you will see this function in use in the “item.aspx” page).  You can call this function and bind the data to the page by adding code similar to this to the "script" section of your .aspx file:

itemdetail.DataSource = pd.binditemdetail()
itemdetail.DataBind()

You can display the results in the "HTML" section of your .aspx file with code similar to this:

<!-- Item Detail -->
<asp:Repeater id="itemdetail" runat="server">
<itemtemplate>

  <%# DataBinder.Eval(Container.DataItem, "name") %>
  <br>
  <%# DataBinder.Eval(Container.DataItem, "itemno") %>
  <br>  
  <%# DataBinder.Eval(Container.DataItem, "shortdesc") %>
  <br>
      <!-- Item Options-->
      <asp:repeater runat="server" datasource='<%# Container.DataItem.Row.GetChildRows("OptionCats") %>'>
      <itemtemplate>

        <%# Container.DataItem("groupname") %><br>
<%# Container.DataItem("groupoptions") %><br>

      </itemtemplate>
      </asp:Repeater>
      <!-- End Item Options -->

</itemtemplate>
</asp:Repeater>
<!-- End Item Detail -->

The Binditemdetail function returns all data columns in the "items" database table:

name   (DataType: nvarchar)
itemno   (DataType: nvarchar)
description   (DataType: ntext)
smallimage   (DataType: nvarchar)
largeimage   (DataType: nvarchar)
price   (DataType: currency)
shortdesc   (DataType: nvarchar)
active   (DataType: nvarchar)
feature   (DataType: nvarchar)
saleprice   (DataType: currency)
onsale   (DataType: nvarchar)
search   (DataType: ntext)
qty   (DataType: number)
addqty   (DataType: number)
imgresize   (DataType: nvarchar)
hideprice   (DataType: nvarchar)
hidehead   (DataType: nvarchar)
weight   (DataType: number)
digital   (DataType: nvarchar)
digfile   (DataType: nvarchar)
pgvisits   (DataType: number)
pgvisitson   (DataType: number)
taxable   (DataType: nvarchar)
custom1   (DataType: nvarchar)
custom2   (DataType: nvarchar)
custom3   (DataType: nvarchar)
imgwrap   (DataType: nvarchar)
shipping   (DataType: number)

These additional String type columns are also returned (the data returned will include all HTML and formatting):

buybutton
updatebutton
savebutton
emailbutton
wishbutton
catcount
priceeach
baseprice
image
nameheading
itemnoheading
custom1heading
custom1text
custom2heading
custom2text
custom3heading
custom3text
imagewrap
imagenowrap
optionheader
optionfooter
optionheader2
optionfooter2
finalpriceheading
finalprice
stockmessage
qtydiscounts
hiddeninput

Article Applies to: ASP.NET (Microsoft's .NET), PDshop .NET