sum timesapn in gridview using asp.net

Question

Hi, i want to calculate total timesapn in gridview rows in asp.net kindly help me out. Thank you.

Rajeev Punhani · Answer

Hi Praveen, Please send gridview structure from aspx page so that we can help you.

Nishant Mittal · Answer

Convert the string in timespan Like Timestamp.Parse(Dg.row[0].column[2].tostring()) Then add I am not getting what is the issue

praveen kumar · Answer

in this i want to calculate DTLEN sum

Rajeev Punhani · Answer

Hi Praveen, Could you send Gridview structure.

praveen kumar · Answer

still facing the same issue

Rajeev Punhani · Answer

Hi Praveen, TimeSpan sum = TimeSpan.Zero; protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { string times= ((Label)e.Row.FindControl("lbltime")).Text; //string times= e.Row.Cells[columnIndex].Text; sum += (TimeSpan)times ; } if (e.Row.RowType == DataControlRowType.Footer) { Label lbl = (Label)e.Row.FindControl("lblTotal"); lbl.Text = sum.ToString(); } } If column is template field then search control else use commented line If the above solution is helpful then, accept the answer.

praveen kumar · Answer

Can you replay with me the full code, i cant understand

Nishant Mittal · Answer

Are u sure u have 7 cells?? Use this GridViewRow row = CustomersGridView.SelectedRow; string s = row.Cells[0].Text;

praveen kumar · Answer

hi Rajeev Punhani, getting error on cells[].value 'System.Web.UI.WebControls.TableCell' does not contain a definition for 'Value' and no extension method 'Value' accepting a first argument of type 'System.Web.UI.WebControls.TableCell' could be found (are you missing a using directive or an assembly reference?) Thank you

Rajeev Punhani · Answer

Hi Praveen, TimeSpan sum = TimeSpan.Zero; for ( int i = 0; i { sum += (TimeSpan)gridview1.Rows[i].Cells[7].Text; } This you can do in row created or row databound.Change cell index based on time span column. If the above solution is helpful then, accept the answer.

Nishant Mittal · Answer

This code is adding one time span in another. TimeSpan.Add returns a new instance of TimeSpan .

praveen kumar · Answer

can you explain me clearly with full code

Nishant Mittal · Answer

Hi Use this totalTime = totalTime.Add(time)//it will return a new timespan

sum timesapn in gridview using asp.net

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (13)