my source code
protected void Button3_Click(object sender, EventArgs e) {
UltraWebGrid1.Bands[0].Columns.Add("Total", "ba_ulimit * 5 = ?"); Infragistics.WebUI.UltraWebGrid.UltraGridColumn c = UltraWebGrid1.Bands[0].Columns.FromKey("Total"); c.DataType = "System.Double"; c.Format = "C"; c.Formula = " [ba_ulimit] * 5 "; c.Width = Unit.Pixel(150); c.CellStyle.HorizontalAlign = HorizontalAlign.Right;
// set up footer summaries for total column c.Footer.Key = "Total"; c.Footer.Caption = "Total = "; c.Footer.Total = Infragistics.WebUI.UltraWebGrid.SummaryInfo.Sum; c.Footer.Formula = "ROUND(SUM([Total]),2)";
// set up footer summaries for the Unit Price column c = UltraWebGrid1.Bands[0].Columns.FromKey("ba_ulimit"); c.Width = Unit.Pixel(150); //c.Header.Caption = "ba_ulimit Value"; c.CellStyle.HorizontalAlign = HorizontalAlign.Right; c.AllowUpdate = Infragistics.WebUI.UltraWebGrid.AllowUpdate.Yes; //c.Format = "###,###,###.00";
Infragistics.WebUI.UltraWebGrid.ColumnFooter cf = c.Footer; cf.Key = "ba_bcode"; cf.Caption = "ba_bcode value = "; cf.Total = Infragistics.WebUI.UltraWebGrid.SummaryInfo.Avg; cf.Formula = "ROUND(SUM([ba_bcode]),2)";
// Allow for footers to be visible Infragistics.WebUI.UltraWebGrid.UltraGridBand b = UltraWebGrid1.Bands[0]; b.ColFootersVisible = Infragistics.WebUI.UltraWebGrid.ShowMarginInfo.Yes;
}
what is "#VALUE!" ?
i do .. File attachment PNG pic.
i don't know. help me plz ^^
thank you~
i solving a problem..
add my code ^^
this.UltraWebGrid1.DisplayLayout.AddNewBox.Hidden = false; this.UltraWebGrid1.DisplayLayout.AllowAddNewDefault = AllowAddNew.Yes; this.UltraWebGrid1.DisplayLayout.AllowUpdateDefault = AllowUpdate.Yes;
thank you ~
hardmanii said: what is "#VALUE!" ?
It usually means that the expression you are using to generate the value you are trying to display is generating an invalid value. I'd start by looking for "divide by zero", type mismatches, etc.