<%@ Register TagPrefix="DNL" Assembly="DbNetLink.DbNetSuiteVS" Namespace="DbNetLink.DbNetSuiteVS" %>
<DNL:DbNetGrid ID="DbNetGrid1" runat="server" ConnectionString="SamplesDatabase" FromPart="[Order Details]" OnAggregateCellDataBind="UpdateAggregateRow"> <Columns> <DNL:GridColumn ColumnExpression="OrderID" /> <DNL:GridColumn ColumnExpression="ProductID" /> <DNL:GridColumn ColumnExpression="UnitPrice" /> <DNL:GridColumn ColumnExpression="Quantity" /> <DNL:GridColumn ColumnExpression="(UnitPrice * Quantity)" Label="Total" Aggregate="Sum" /> </Columns> </DNL:DbNetGrid>
/////////////////////////////////////////////////////////////// public void UpdateAggregateRow( object Sender, CellDataBindEventArgs Args) /////////////////////////////////////////////////////////////// { ((System.Web.UI.WebControls.TableRow)Args.Cell.Parent).Cells[3].Text = "Overall Total"; Args.Cell.Style.Add(HtmlTextWriterStyle.BackgroundColor, "gold"); }