<%@ Page language="c#" %>
<%@ Import namespace="System.Data" %>
<%@ Register tagPrefix="ASPItalia" namespace="ASPItalia.com" assembly="MathColumn" %>

<script runat="server">

private void Page_Load(object sender, System.EventArgs e)
{
  DataTable dt=new DataTable();
  dt.Columns.Add("Tipo",typeof(string));
  dt.Columns.Add("Prezzo1",typeof(decimal));
  dt.Columns.Add("Prezzo2",typeof(decimal));
  DataRow r;
  for (int x=1;x<5;x++)
  {
    r=dt.NewRow();
    r[0]="Tipo " + x;
    r[1]=x*100.5m;
    r[2]=x*200.5m;
    dt.Rows.Add(r);
  }
  DataGrid1.DataSource=dt;
  DataGrid1.DataBind();
}

</script>

<asp:DataGrid EnableViewState="False" id="DataGrid1" AutoGenerateColumns="False" runat="server" BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px" BackColor="White" CellPadding="4" GridLines="Vertical" ForeColor="Black">
  <AlternatingItemStyle BackColor="White"/>
  <ItemStyle BackColor="#F7F7DE"/>
  <HeaderStyle Font-Bold="True" ForeColor="White" BackColor="#6B696B"/>
  <Columns>
    <asp:BoundColumn DataField="tipo" HeaderText="Tipo"></asp:BoundColumn>
    <asp:BoundColumn DataField="Prezzo1" HeaderText="Prezzo 1" DataFormatString="&amp;euro; {0:#,##0.00}"/>
    <asp:BoundColumn DataField="Prezzo2" HeaderText="Prezzo 2" DataFormatString="&amp;euro; {0:#,##0.00}"/>
    <ASPItalia:MathColumn DataFields="Prezzo1,Prezzo2" Operation="AVG" HeaderText="Media" DataFormatString="&amp;euro; {0:#,##0.00}"/>
    <ASPItalia:MathColumn DataFields="Prezzo1,Prezzo2" Operation="SUM" HeaderText="Somma" DataFormatString="&amp;euro; {0:#,##0.00}"/>
  </Columns>
</asp:DataGrid>