Summerize timespane in datagridview using ms access db

Question

Hello I am using ms access as a database already have bind the data in datagridview. Need to summerize the timespane i have tried but it show not in a correct formate. kindly help me

praveen kumar · Answer

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

dinesh kumar · Answer

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

praveen kumar · Answer

I am struggling creating summery for the timespan

dinesh kumar · Answer

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 i f this helps you kindly please UPVote it. Regards DK

Summerize timespane in datagridview, using ms access db