Repeater control footer summary (asp.net 2 with vb)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello,

I have a repeater that is bound to a SQL Server table. I would like to
place a summary in the footer for the item count and product cost.

I have two fields. One for the product name and the other for product
cost.

<%#Container.DataItem("ProductA")%>
<%#Container.DataItem("PriceA")%>

My question is, how to count the products (ProductA), get the total price
(sum PriceA) and then place the value in the footer.

Any help with this would be appreciated.

--
Thanks in advance,

sck10



.

Relevant Pages

  • Re: find control inside a repeater
    ... RepeaterItem where the event occured (the footer) and look for the ... Since the footer doesn't have that control the ... DropDownList Controls In an ASP.Net DataGrid ... >Is there any tutorials which explains repeater in great details? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: calculate only visible data in the report
    ... This is Sql Server question. ... footer, I need to show only visible rows grand total. ... I need to calculate grand total of only visible rows data in my report. ... I dont no how to avoid those hidden rows values from the calculation. ...
    (microsoft.public.sqlserver)
  • Use a label in a FooterTemplate control? Surely, there must be a way...
    ... I have a typical Repeater that contains a Template. ... SUM up the $$ amounts from all the records in the repeater. ... So I tried to place a Label control in the footer and fill the Text of the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: calculate only visible data in the report
    ... I'm not understanding - If you are talking about a standard Sql Server ... If you are referring to data extracted to a report that may make more ... footer, I need to show only visible rows grand total. ... I dont no how to avoid those hidden rows values from the calculation. ...
    (microsoft.public.sqlserver)
  • Re: Repeater Control : Can it work with different data sources?
    ... The repeater, as a control, is made up of templates for rows of data (and ... every second row) and then a header and footer template. ... The norm, when creating a table, is to put the and all header tags ...
    (microsoft.public.dotnet.framework.aspnet)