Do calculations in repeater

[have]

Hi All,

I'm quite new to ASP.net and i can't figure out one thing.
I would like to add the total price and the total discount to 2 different
variables so when my reapeater is finished i've got my data on the screen
and the total price and the total discount

So far i've got this code wish works fine to show the data but it doesn't do
any calculation

Dim query As String
kid = Request.QueryString("kid")
//this query is a very simple versiono of the real one
query = "SELECT Title, ArtistName, Price DefaultPrice,Discount WHERE
CustomerID = '" & kid & "'
connection = New SqlConnection(connectionString)
connection.Open()
Dim commando As SqlCommand = New SqlCommand(query, connection)
Dim reader As SqlDataReader = commando.ExecuteReader()
Dim TotalPrice As Double

voorstellingen.DataSource = reader
voorstellingen.DataBind()
reader.Close()
connection.Close()
getKlantGegevens()

So i would like to fill a variable with the total price and a variable with
the total discount.

Thanks in advance
Erik

[Cowboy (Gregory A. Beamer) - MVP]

In general, it is best to go ahead and calculate aggregates in the database
and simply pass back the results. Doing so not only enhances performance, but
increases maintainability of the ASPX pages and their code behind.

If you have to manipulate in the ASPX and/or its code behind, you may be
able to bind to a function that does the calculation. It is a one way trip,
however. If you need complete flexibility, you are better creating the output
yourself, rather than using a repeater. This can be a simple table creation
in the code behind or a custom control. You will probably find you do not
need to go to this step if you will simply calculate in the database.

---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

"ha**@none.com" wrote:

Hi All,

I'm quite new to ASP.net and i can't figure out one thing.
I would like to add the total price and the total discount to 2 different
variables so when my reapeater is finished i've got my data on the screen
and the total price and the total discount

So far i've got this code wish works fine to show the data but it doesn't do
any calculation

Dim query As String
kid = Request.QueryString("kid")
//this query is a very simple versiono of the real one
query = "SELECT Title, ArtistName, Price DefaultPrice,Discount WHERE
CustomerID = '" & kid & "'
connection = New SqlConnection(connectionString)
connection.Open()
Dim commando As SqlCommand = New SqlCommand(query, connection)
Dim reader As SqlDataReader = commando.ExecuteReader()
Dim TotalPrice As Double

voorstellingen.DataSource = reader
voorstellingen.DataBind()
reader.Close()
connection.Close()
getKlantGegevens()

So i would like to fill a variable with the total price and a variable with
the total discount.

Thanks in advance
Erik

[GrantMagic]

if you wanna do calculations in a repeater, you need to use the on
ItemDataBound command.
Than for every item, increment a variable by the value required.

When the Repeated is finished binding, the value will be in the variable
<ha**@none.com> wrote in message
news:41*********************@dreader6.news.xs4all. nl...

Hi All,

I'm quite new to ASP.net and i can't figure out one thing.
I would like to add the total price and the total discount to 2 different
variables so when my reapeater is finished i've got my data on the screen
and the total price and the total discount

So far i've got this code wish works fine to show the data but it doesn't
do
any calculation

Dim query As String
kid = Request.QueryString("kid")
//this query is a very simple versiono of the real one
query = "SELECT Title, ArtistName, Price DefaultPrice,Discount
WHERE
CustomerID = '" & kid & "'
connection = New SqlConnection(connectionString)
connection.Open()
Dim commando As SqlCommand = New SqlCommand(query, connection)
Dim reader As SqlDataReader = commando.ExecuteReader()
Dim TotalPrice As Double

voorstellingen.DataSource = reader
voorstellingen.DataBind()
reader.Close()
connection.Close()
getKlantGegevens()

So i would like to fill a variable with the total price and a variable
with
the total discount.

Thanks in advance
Erik