Hi all

Have anyone know the way to summary every row in datagrid to datagrid's footer
I try to use this code but it didn't show anything

****************************

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        'Put user code to initialize the page here
        If Page.IsPostBack = False Then
            Header.Text = "Review Your Product In Cart"

            ' Calculate end-user's shopping cart ID
            Dim cart As VCDeasy.ShoppingCartDB = New VCDeasy.ShoppingCartDB
            Dim cartId As String = cart.GetShoppingCartId()

            ' Populate datagrid with shopping cart data
            MyDataGrid.DataSource = cart.GetItems(cartId)
            MyDataGrid.DataBind()

            ' Update total price label
            TotalLbl.Text = "Total : " & String.Format("{0:c}", cart.GetTotal(cartId))
            MyDataGrid.Item.Cells(1).Text = "Total: " & String.Format("{0:#,###}", cart.GetTotal(cartId))
        End If

*************************************
cart.GetTotal(cartId)) is my function that calculate the summary value

How can i solve this problem?

Thanks in advance

Blueman137

Usually you would do this with the datagrid's ItemCreated handler. In the method that handles that event, you can test e.Item for "Footer" and then access the cell where you want to write the total string.