Summerize timespane in datagridview, using ms access db

Hi,

to get total value of the columns i am using this code

int sum = 0;
  for( int i=0; i  {
  sum +=Convert.ToInt32(dataGridView1.Rows[i].Cells[4].Value);

  }

  label2.Text = sum.ToString();

i just want to get my timespan total calculation of the entire columns, it showing
this error Invalid cast from 'DateTime' to 'Int32'.

kindly help me

thank you

can you post what you tried , B'cos upto my knowledge there is no default feature or behavior available for displaying summaries (or) summary row in Datagrid (wpf). so i would suggest for extended grid or wpf toolkit which can be found in here. 

http://blogs.msdn.com/b/vinsibal/archive/2008/10/31/wpf-datagrid-frozen-row-sample.aspx


if this helps you please upvote it


Regards,
DK

I am struggling creating summery for the timespan

Hi praveen , are you struggling in creating summary row or in displaying the data time format for your summary value (TimeSpan). 


If it's only format then you could apply through 

Value = TimeSpan.ParseExact(value, "you can apply your required format ", null);

to know about format strings please refer the below link:

https://msdn.microsoft.com/en-us/library/ee372286(v=vs.110).aspx


if this helps you kindly please UPVote it.
Regards
DK