DataSet - Novice Question

[Guest]

I am using the datatable to display the details something like thi
Total X Y
GR 200 100 50 50
CS 100 50 25 2
FG% (cs/GR) 150% 50% 50% 50%

In the above table I am calculating the FG% while creating the row. In the end I use the table.Column.add("total") to get the totals for all the rows. But while the rows 1 and rows 2 totals are fine, you cannot add the % row in the same manner. I am virtually at my wits end as how to get the correct % in the totals column

TI
Ashok

 

[Scott Allen]

Two alternatives.

First, to add the new row, use

DataRow workRow = workTable.NewRow();

I'm assuming your columns are all of int type, so you won't be able to
just stick a % sign in the row. So an alternate technique (or perhaps
you need to combine the two) would be to handle the ItemCreated event.
Here is a good article on the subject:

Summary Rows in DataGrid Controls
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndive/html/data01102002.asp