Hi,
I want total of a column in footer but i am creating my columns dynamically and it is asp label type and i need Total of that column in footer
I am using this code. But it returning a error page with error
Sum is not supported for type "System.Object".
but when i comment line denoted with * than page works fine but not able to display total. Please help
templateColumn = new GridTemplateColumn();
controlID = "lbl_Total" + colCounter.ToString();
templateColumn.ItemTemplate = new CreateItemTemplate("Label", this, controlID, null, 27, "16px", colCounter, dtSchedule.Rows.Count);
templateColumn.HeaderText = dtGetColumnsNameForGrid.Rows[colCounter - 1]["HeaderText"].ToString();
templateColumn.UniqueName = dtGetColumnsNameForGrid.Rows[colCounter - 1]["UniqueName"].ToString();
templateColumn.DataField = dtGetColumnsNameForGrid.Rows[colCounter - 1]["UniqueName"].ToString();
templateColumn.FooterText = "Total: ";
***** templateColumn.Aggregate = GridAggregateFunction.Sum;
I want total of a column in footer but i am creating my columns dynamically and it is asp label type and i need Total of that column in footer
I am using this code. But it returning a error page with error
Sum is not supported for type "System.Object".
but when i comment line denoted with * than page works fine but not able to display total. Please help
templateColumn = new GridTemplateColumn();
controlID = "lbl_Total" + colCounter.ToString();
templateColumn.ItemTemplate = new CreateItemTemplate("Label", this, controlID, null, 27, "16px", colCounter, dtSchedule.Rows.Count);
templateColumn.HeaderText = dtGetColumnsNameForGrid.Rows[colCounter - 1]["HeaderText"].ToString();
templateColumn.UniqueName = dtGetColumnsNameForGrid.Rows[colCounter - 1]["UniqueName"].ToString();
templateColumn.DataField = dtGetColumnsNameForGrid.Rows[colCounter - 1]["UniqueName"].ToString();
templateColumn.FooterText = "Total: ";
***** templateColumn.Aggregate = GridAggregateFunction.Sum;