Hi akhter,

Refer

Display sum of Columns total in GridView Footer in ASP.Net using C# and VB.Net

Refer below code.

HTML

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        this.BindGrid();
    }
}

Decimal DDQTY = 0;
Decimal DDWeight = 0;
protected void GVballist_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        Label lblDQ = (Label)e.Row.FindControl("Qty");
        DDQTY += Convert.ToDecimal(lblDQ.Text);
        Label lblDWT = (Label)e.Row.FindControl("BWeight");
        DDWeight += Convert.ToDecimal(lblDWT.Text);
    }
    else if (e.Row.RowType == DataControlRowType.Footer)
    {
        Label lbl = (Label)e.Row.FindControl("lblQTotal");
        lbl.Text = DDQTY.ToString();
        Label lbl1 = (Label)e.Row.FindControl("lblWTotal");
        lbl1.Text = DDWeight.ToString();
    }
}

protected void btn_Trfer_Click(object sender, EventArgs e)
{
    if (lbinvid.Text == "")
    {
        Response.Write("<script>alert('Please Generate Invoice ID.')</script>");
    }
    else
    {
        foreach (GridViewRow row in GVballist.Rows)
        {
            if ((row.FindControl("CheckBox1") as CheckBox).Checked)
            {
                int id = Convert.ToInt32((row.FindControl("hfBID1") as HiddenField).Value);
                using (SqlCommand cmd = new SqlCommand("Sp_Ret_DisBale_BB_INv", con))
                {
                    cmd.Parameters.AddWithValue("@Action", "Update_Invoice");
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("@ID", id);
                    cmd.Parameters.AddWithValue("@Inv_ID", lbinvid.Text);
                    con.Open();
                    cmd.ExecuteNonQuery();
                    con.Close();
                }
            }
        }

        lbmsg.Text = "Transfer Successfully.";
        this.BindGrid();
    }
}

private void loadgvbales()
{
    SqlCommand ocmd = new SqlCommand("Sp_Ret_DisBale_BB_INv", con);
    ocmd.CommandType = CommandType.StoredProcedure;
    ocmd.Parameters.AddWithValue("@Action", "Dispatch");
    ocmd.Parameters.AddWithValue("@DID", lbdispatchno.Text);
    con.Open();
    using (SqlDataAdapter da = new SqlDataAdapter(ocmd))
    {
        DataTable dt = new DataTable();
        da.Fill(dt);
        if (dt.Rows.Count > 0)
        {
            ViewState["dt"] = dt;
        }
        con.Close();
    }
}

private void BindGrid()
{
    loadgvbales();
    this.GVballist.DataSource = ViewState["dt"] as DataTable;
    this.GVballist.DataBind();
}