datagrid total

[davebat]

I have a datagrid which is bound to a filtered dataview, what is the best way to go about totalling the numerical values and putting them in the footer

Dim dr As DataRowView
        Dim range01tot As Decimal = 0.0
        Dim i As IEnumerator = dvOne.GetEnumerator()
        While (i.MoveNext())
            dr = i.Current
            range01tot += (dr("value"))
        End While

[temp_12000]

Originally posted by davebat
I have a datagrid which is bound to a filtered dataview, what is the best way to go about totalling the numerical values and putting them in the footer

I tried two methods:

1) use SQL to compute SUM;
2) use a loop and fetch the values for each row in the datagrid, then add them;

do not know whether they are good methods, but both work for me.

[Briantcva]

It's in C# but you should get the idea.

DataRowView dr; int hoursCount=0;
IEnumerator i=viewStaffSchedule.GetEnumerator();
while(i.MoveNext())
     {
          dr=(DataRowView)i.Current;	
          hoursCount+=int.Parse(dr["ProjectHours"].ToString());
     }
lblTotalHours.Text=hoursCount.ToString();

[davebat]

thanks both of you, Brian I have translated this as well as i can into VB and am just unsure about the int.parse part, Im still pretty new to this.

Dim dr As DataRowView
        Dim rangeo1tot As Integer = 0
        Dim i As IEnumerator = dvOne.GetEnumerator()
        While (i.MoveNext())
            dr = i.Current
            range01tot += Int.Parse(dr, "range01".ToString())
        End While

The int is underlined as an error "Overload resolution failed because no accesible 'int' accepts this number of arguments" Do you know what i need to do

[fret]

try to use the:

range01tot += Integer.Parse(dr, "range01".ToString())

[davebat]

it needed to be

range01tot += Integer.Parse(dr("range01").ToString())

I found a good c# to vb converter at

http://authors.aspalliance.com/aldot...translate.aspx

Only problem now is that I get the error message "Input string was not in a correct format. "

[davebat]

bump

[Briantcva]

This line maybe?

dr=(DataRowView)i.Current;

I noticed yours doesn't have it. It's casting the enumerator to a DataRowView - I think the VB equivalent is CType.