DataRow Bound in asp.net

Question

Hi All I have to calculate the values of Employees as per below table based on months. I am getting the values of Payroll, contractors, TAG team from DB. April May Employees 6 8 payroll 1 1 Contractors 2 3 Tag team 3 4 Can some please guide me plz, Its very urgent...

Rakesh Donthi · Answer

Is there any way where i can bind the values in Header because my clients wants in Header only and this is just as example, i have many columns similar to that.

Upendra Pratap Shahi · Answer

Use below code it may help you--- set property of gridview ShowFooter="true" int total = 0; ; gvStatistReport.FooterRow.Cells[1].Text = "Total" ; gvStatistReport.FooterRow.Cells[1].Font.Bold = true ; gvStatistReport.FooterRow.Cells[1].HorizontalAlign = HorizontalAlign.Left; for ( int k = 2; k { total = dt.AsEnumerable().Sum(row => row.Field (dt.Columns[k].ToString())); gvStatistReport.FooterRow.Cells[k].Text = total.ToString(); gvStatistReport.FooterRow.Cells[k].Font.Bold = true ; }

Upendra Pratap Shahi · Answer

bind this total values in footer of grid and count total from loop.

Rakesh Donthi · Answer

Hi.. I have to calculate the values of 1,2,3 and result should be dynamically. Highlighted in yellow color April May Employees 6 8 payroll 1 1 Contractors 2 3 Tag team 3 4

Upendra Pratap Shahi · Answer

Kindly clarify your question please.

DataRow Bound in asp.net

Answers (5)