DataRow Bound in asp.net

Rakesh Donthi

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.

Can some please guide me plz, Its very urgent...

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rakesh Donthi11y ago
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.
0
Upendra Pratap Shahi11y ago
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 < dt.Columns.Count; 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;
}
0
Upendra Pratap Shahi11y ago
bind this total values in footer of grid and count total from loop.
0
Rakesh Donthi11y ago
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

0
Upendra Pratap Shahi11y ago
Kindly clarify your question please.
0