Bring TOTAL In footer in Gridview ?

I have loaded the values in gridview. In the other gridivew I have loaded the selection values in the temporary table and I made remove when clicking Particular button.

 

My Requirement is, I have calculated the total amount in Tempory Table Loaded Gridview.Here I Show my code. I want to achieve the Total Amount in footer Template.

 

Any of you guide me. To achieve this task .

 

Design Page :

 

Back end codeing :

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyCon"].ConnectionString);

DataTable Dt = new DataTable();

DataTable Dt2 = new DataTable();

DataTable Basket_DataTable = null;

protected void Page_Load(object sender, EventArgs e)

{

if (Session["basket"] !=null)

{

Basket_DataTable = (DataTable)Session["basket"];

}

else

{

Basket_DataTable = new DataTable();

Basket_DataTable.Columns.Add("ProudtCode");

Basket_DataTable.Columns.Add("ImagePath");

Basket_DataTable.Columns.Add("BrandName");

Basket_DataTable.Columns.Add("Price");

Basket_DataTable.Columns.Add("Count");

Basket_DataTable.Columns.Add("Total");

}

if(Request["DELID"]!= null)

{

for (int i = 0; i < Basket_DataTable.Rows.Count; i++)

if (Basket_DataTable.Rows[i][0].ToString() == Request["DELID"].ToString())

Basket_DataTable.Rows.Remove(Basket_DataTable.Rows[i]);

}

if (Request["PROUDCTCODE"]!= null)

{

bool Found = false;

for(int i=0; i< Basket_DataTable.Rows.Count; i++)

if(Basket_DataTable.Rows[i][0].ToString()==Request["PROUDCTCODE"].ToString())

Found =true;

if(Found ==false)

{

string query1 = "select * from ProductMaster where ProudtCode='" + Request["PROUDCTCODE"] + "'";

SqlDataAdapter Dtt = new SqlDataAdapter(query1, con);

DataTable Dresult=new DataTable();

Dtt.Fill(Dresult);

if (Dresult != null && Dresult.Rows.Count == 1)

{

Basket_DataTable.Rows.Add(new object[] { Request["PROUDCTCODE"], Dresult.Rows[0]["ImagePath"].ToString(), Dresult.Rows[0]["BrandName"].ToString(), Dresult.Rows[0]["Price"].ToString(), "1", Dresult.Rows[0]["Price"].ToString() });

}

}

}

if (!IsPostBack)

{

LoadGrid();

LoadGrid1();

}

if (IsPostBack == false)

{

GridView1.DataSource = Basket_DataTable;

GridView1.DataBind();

}

Session["basket"]=Basket_DataTable;

}

public void LoadGrid()

{

con.Open();

string query = "Select * from ProductMaster where BrandName='ASUS'";

SqlDataAdapter Ada = new SqlDataAdapter(query,con);

Ada.Fill(Dt);

grdShop.DataSource = Dt;

grdShop.DataBind();

con.Close();

}

public void LoadGrid1()

{

con.Open();

string query5 = "Select * from ProductMaster where BrandName='APPLE'";

SqlDataAdapter Ada2 = new SqlDataAdapter(query5, con);

Ada2.Fill(Dt2);

GridView2.DataSource = Dt2;

GridView2.DataBind();

con.Close();

}

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

{

//decimal GrandTot = 0;

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

//{

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

// GrandTot =GrandTot + Convert.ToDecimal(Tot.Text);

// }

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

//{

// Label lbl = (Label)e.Row.FindControl("lblTotal");

// lbl.Text = GrandTot.ToString("c");

//}

}

}

 

Thanx in advance

Karthik k