How to calculate the values in a gridview

I believe the Duration column is calculated for each row and the GrandDuration for all the rows.
You can use an entity approach or grid cell calculation-on-the-fly method. I prefer the first one as it is more readable.

1. You can create a class to represent the values from db.

public class SignInInfo

{

public string EmpCode { get; set; }

public string EmpName { get; set; }

public DateTime InTime { get; set; }

public DateTime OutTime { get; set; }

public double Duration

{

get

{

TimeSpan span = OutTime - InTime;

return span.TotalHours;

}

2. Set the values from datareader

Eg:

IList list = new List();

while(dr.Read())
list.Add(new SignInInfo() { EmpCode=dr["EmpCode"]});

double grandTotal = GetGrandTotal(list);

3. After that map the above properties to the grid columns

4. Use the following method to calculate the grand total

public double GetGrandTotal(IList list)
{
double sum = 0;
foreach(SignInInfo info in list)
sum+=info.Duration;

return sum;
}

Please let me know if it works or not.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jean Paul15y ago
I believe the Duration column is calculated for each row and the GrandDuration for all the rows.
You can use an entity approach or grid cell calculation-on-the-fly method. I prefer the first one as it is more readable.

1. You can create a class to represent the values from db.

public class SignInInfo
{
public string EmpCode { get; set; }
public string EmpName { get; set; }
public DateTime InTime { get; set; }
public DateTime OutTime { get; set; }
public double Duration
{
get
{
TimeSpan span = OutTime - InTime;
return span.TotalHours;
}
}
}

2. Set the values from datareader

Eg:

IList list = new List();

while(dr.Read())
list.Add(new SignInInfo() { EmpCode=dr["EmpCode"]});

double grandTotal = GetGrandTotal(list);

3. After that map the above properties to the grid columns

4. Use the following method to calculate the grand total

public double GetGrandTotal(IList list)
{
double sum = 0;
foreach(SignInInfo info in list)
sum+=info.Duration;

return sum;
}

Please let me know if it works or not.
0