Getting aggregate totals

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

This is probably simple, but what I want to do as I navigate through a
larger table is to automatically update a couple of labels with an aggregate
total of year-to-date points.

I have a couple of data adapters using the following command:

SELECT SUM(cytd)
FROM JuniorMaster
WHERE (JrNumber=?)

On each record selection I am casting the value in the junior's number text
box to the parameter and running the query to a dataset named dsCYTD and
another like above to run another set of year-to-date points.

My question is how would I then assign the value of the dataset to a
variable? I have tried assigning it directly to the label (lblCYTD.text =
dsCTYD1.tables(0).item(0).tostring) but this just assigns the word "Table"
to the label.

Also when I go into the data adapter properties and use the fill option, it
works. Every record does not contain Null records; they all contain the
value of zero (0).

Thanks in advance for any help that I can use.

Brad
 
Hi Brad,

You should use
lblCYTD.text = dsCTYD1.tables(0).Rows(0).item(0).tostring()
 
Back
Top