Intersoft Community - WebGrid Enterprise - Column aggregate to have a different DataFormatString to column

Column aggregate to have a different DataFormatString to column

Mark.R.P — Sun, 20 Sep 2009 20:27:10 GMT

Thanks. This has solved my problem.

Column aggregate to have a different DataFormatString to column

Mark.R.P — Sun, 20 Sep 2009 20:18:33 GMT

Thanks. This has solved my problem.

Column aggregate to have a different DataFormatString to column

Glayaar — Fri, 18 Sep 2009 03:20:33 GMT

You could try using CustomAggegrate server side event to achieve this functionality.

For example you would like to format UnitPrice column to have c6 format

<ISWebGrid:WebGridColumn Caption="UnitPrice" DataMember="UnitPrice" DataType="System.Decimal" Name="UnitPrice" Width="150px" AggregateFunction="Custom" FooterText="Total : " DataFormatString="c6">

Because we set the column to have an aggegrate custom we will need to implement CustomAggegrate server side event. In this event we could also have a different format string for the aggegrate column

protected void WebGrid1_CustomAggregate(object sender, ISNet.WebUI.WebGrid.CustomAggregateArgs e)
{
    if (e.Column.Name == "UnitPrice")
    {
        // obtain the rows that need to be calculated
        WebGridRowCollection rows = e.Rows;
        Decimal total = 0;

        // loop through all rows
        foreach (WebGridRow row in rows)
        {
            total += Decimal.Parse(row.Cells.GetNamedItem("UnitPrice").Value.ToString());
        }

        // pass the result back to AggregateResult.
        e.AggregateResult = total.ToString("c2");
    }
}

Column aggregate to have a different DataFormatString to column

Mark.R.P — Fri, 18 Sep 2009 00:59:54 GMT

Is it possible for a column aggregate to have a different data format string to the column? I have a column whose DataFormatString ="c6" but I need the column aggregate to have DataFormatString="c2". Can you please provide code showing how this can be done? I am using WebGrid 7.0 with BatchUpdate enabled.