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

Answers (4)