upade and total in footer templae of repeter not working

Dear sir,
I have making cart in my project every things went to right but update and total value not working I m also attaching my code ...check and help me as possible.

Soursr Code(HTML)

 
       
       
       
       
       
       
       
       
       
       
       
       
       
       
     
       
       
      
       
       
      
       
        
       
       
       
       
       
       
        
       
      
       
         
         
       
                   
               
               

Check	Pic	Product ID	Emailid	Size	Color	Price	Quantity	Cost	Option
									Edit             Update             Cancel                         CommandArgument='<%# DataBinder.Eval(Container.DataItem, "id") %>'>Delete
Total	0

           
       
                     OnClientClick='javascript:return confirm("Are you sure you want to delete?")'
            onclick="dellink_Click">Delete Selected


Client side code(C#)


using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Web.Caching;
using System.Data.SqlClient;

public partial class shoping : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString());
    int totalPrice = 0;
    SqlDataAdapter da;
    public static int SQty = 0;
    protected void Page_Load(object sender, EventArgs e)
    {
        username.Text = Request.QueryString["emailid"].ToString();
        bindrepeter();
        if (Session["emailid"] == null)
        {
            login.Text = "Login";

        }
        else
        {
            login.Text = "Logout";
        }

    }
    //display record//
    protected void bindrepeter()
    {
        SqlCommand cmd = new SqlCommand("select *  from cart where emailid='" + username.Text + "'", con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
       
        da.Fill(ds, "cart");
        Repeater1.DataSource = ds;
        Repeater1.DataBind();
    }
    //edit and update record//
    protected void cpRepeater_ItemCommand(object source, RepeaterCommandEventArgs e)
    {
        LinkButton lnkUpdate = (LinkButton)e.Item.FindControl("lnkUpdate");
        LinkButton lnkCancel = (LinkButton)e.Item.FindControl("lnkCancel");
        LinkButton lnkEdit = (LinkButton)e.Item.FindControl("lnkEdit");
        LinkButton lnkDelete = (LinkButton)e.Item.FindControl("lnkDelete");
        Label totalcost = (Label)e.Item.FindControl("totalcost");
        Label price = (Label)e.Item.FindControl("price");
        Label lblemailid = (Label)e.Item.FindControl("emailid");
        Label lblrptID = (Label)e.Item.FindControl("lblid");
        TextBox txtName = (TextBox)e.Item.FindControl("txtName");
        CheckBox chkDelete = (CheckBox)e.Item.FindControl("CheckBoxDelete");
       
       
        if (e.CommandName == "edit")
        {
            lnkCancel.Visible = true;
            lnkUpdate.Visible = true;
            lnkEdit.Visible = false;
            txtName.Visible = true;
            lblemailid.Visible = false;

        }
        if (e.CommandName == "cancel")
        {
            bindrepeter();
        }
        if (e.CommandName == "update")
        {

            SqlCommand SqlCmd = new SqlCommand("update cart set quantity=@quantity  where id=@ID", con);
            SqlCmd.Parameters.Add("@quantity", SqlDbType.VarChar).Value = txtName.Text;
            SqlCmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = e.CommandArgument;
            try
            {
                con.Open();
                if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
                {
                    totalPrice = totalPrice + Convert.ToInt32(((Label)e.Item.FindControl("price")).Text);
                }
                SqlCmd.ExecuteNonQuery();

            }
            catch (Exception ex)
            {
                ex.Message.ToString();
            }
            finally
            {
                if (con.State == ConnectionState.Open)
                    con.Close();
            }
            bindrepeter();
        }
        if (e.CommandName == "delete")
        {

            SqlCommand SqlCmd = new SqlCommand("delete cart where id=@ID", con);
            SqlCmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = e.CommandArgument;
            try
            {
                con.Open();
                SqlCmd.ExecuteNonQuery();

            }
            catch (Exception ex)
            {
                ex.Message.ToString();
            }
            finally
            {
                if (con.State == ConnectionState.Open)
                    con.Close();
            }
            bindrepeter();
        }

    }
    void Repeater1_PreRender(object sender, EventArgs e)
    {
        Label lblTotal = (Label)Repeater1.Controls[Repeater1.Controls.Count - 1].FindControl("lblTotal");
        lblTotal.Text = totalPrice.ToString();
    }

    protected void dellink_Click(object sender, EventArgs e)
    {
        foreach (RepeaterItem Item in Repeater1.Items)
        {
            CheckBox chkDelete = (CheckBox)Item.FindControl("CheckBoxDelete");
            Label lblrptID = (Label)Item.FindControl("lblid");

            if (chkDelete.Checked)
            {

                SqlCommand SqlCmd = new SqlCommand("delete cart where id=@ID", con);
                SqlCmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = lblrptID.Text;
                SqlCmd.Connection = con;
                con.Open();
                SqlCmd.ExecuteNonQuery();
                con.Close();

            }
        }
        bindrepeter();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (CheckBox1.Checked == true)
        {

            Response.Redirect("~/ddorcheque.aspx?emailid=" + username.Text);
        }

        if (CheckBox2.Checked == true)
        {

            Response.Redirect("~/cash on delivery.aspx?emailid=" + username.Text);
        }
    }
    protected void sighup_Click(object sender, EventArgs e)
    {
        if (Session["emailid"] == null)
        {
            Response.Redirect("userregister.aspx");
        }
        else
        {
            Response.Redirect("useraccount.aspx?emailid=" + Session["emailid"].ToString());
        }

    }
    protected void login_Click(object sender, EventArgs e)
    {
        if (Session["emailid"] == null)
        {
            Response.Redirect("userlogin.aspx");
        }
        else
        {
            Session.Abandon();
            Session.Clear();
            Response.Redirect("Default.aspx");
        }
    }
    protected void account_Click(object sender, EventArgs e)
    {
        if (Session["emailid"] == null)
        {
            Response.Redirect("userlogin.aspx");
        }
        else
        {
            Response.Redirect("useraccount.aspx?emailid=" + Session["emailid"].ToString());
        }
    }
    protected void viewcart_Click(object sender, EventArgs e)
    {
        if (Session["emailid"] == null)
        {
            Response.Redirect("userlogin.aspx");
        }
        else
        {
            Response.Redirect("useraccount.aspx?emailid=" + Session["emailid"].ToString());
        }
    }

}