GRIDVIEW Footer Concept

Set  grideviw  property

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"

BackColor="White" BorderColor="#336699" BorderStyle="Solid" BorderWidth="1px"

CellPadding="2" Font-Names="Verdana" ShowFooter="true" Font-Size="10pt"

Width="50%" DataKeyNames="id1" GridLines="Horizontal"

onrowdatabound="GridView1_RowDataBound">

 <Columns>

<asp:BoundField DataField="id1" HeaderText="ino" />

<asp:TemplateField HeaderText="total">

<ItemTemplate>

 <asp:Label ID="lblPrice" runat="server" Text='<%# Eval("total")%>' />

 </ItemTemplate>

 <FooterTemplate>

 <asp:Label ID="lblTotalPrice" runat="server" />

 </FooterTemplate>                 

 </asp:TemplateField>

</Columns>

C# code  :

private void BindData()

{

       

        string cs = @"connection string";

        cn = new SqlConnection(cs);

        cn.Open();

        string k = "select * from invoicetbl";

        SqlDataAdapter da = new SqlDataAdapter(k,cn);

        DataTable table = new DataTable();

      

        da.Fill(table);

        GridView1.DataSource = table;

        GridView1.DataBind();

}

  decimal totalPrice = 0M;

  decimal totalStock = 0M;

  int totalItems = 0;

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

    {

        if (e.Row.RowType == DataControlRowType.DataRow)

        {

            Label lblPrice = (Label)e.Row.FindControl("lblPrice");

            Label lblUnitsInStock = (Label)e.Row.FindControl("lblUnitsInStock");

            decimal price = Decimal.Parse(lblPrice.Text);

            totalPrice += price;

            totalItems += 1;

        }

        if (e.Row.RowType == DataControlRowType.Footer)

        {

            Label lblTotalPrice = (Label)e.Row.FindControl("lblTotalPrice");

          

            lblTotalPrice.Text = totalPrice.ToString();         

         

        }

    }