ASP.NET

void CreateDynamicLinks()
    {
        tblDynamic.Controls.Clear();
        DataTable dtSite = GetSiteList(intTechId);
        int i = 0;
        foreach (DataRow row in dtSite.Rows)
        {
            i++;
            strLink = getSiteName(Convert.ToInt32(row["SiteID"].ToString()));
            TableRow tr = new TableRow();
            TableCell tcLinkButton = new TableCell();
            LinkButton linkButton = new LinkButton();
            linkButton.ID = row["SiteID"].ToString();
            linkButton.Text = strLink;
            linkButton.Command += new CommandEventHandler(OnLinkClick);
            linkButton.CommandName = row["SiteID"].ToString();
            linkButton.CommandArgument = row["SiteID"].ToString();
            tcLinkButton.Controls.Add(linkButton);
            tr.Cells.Add(tcLinkButton);
            tblDynamic.Rows.Add(tr);
        }

    }

protected void Update(object source, DataListCommandEventArgs e)
   {
       int ProductID = Convert.ToInt32(DataList1.DataKeys[e.Item.ItemIndex]);
       TextBox txtqty;
       txtqty = ((TextBox)e.Item.FindControl("txtqty"));
       string connectionstring = ConfigurationManager.ConnectionStrings["SilverOnline"].ConnectionString;
       SqlConnection conn = new SqlConnection(connectionstring);
       SqlCommand cmd = new SqlCommand("Update Home Set ProductQty=@productqty Where ProductID=@productid", conn);
       cmd.Parameters.Add("@productqty", SqlDbType.VarChar).Value = txtqty.Text;
       cmd.Parameters.Add("@productid", SqlDbType.Int).Value = ProductID;
       if (conn.State == ConnectionState.Closed)
           conn.Open();
       cmd.ExecuteNonQuery();
       if (conn.State == ConnectionState.Open)
           conn.Close();
       DataList1.EditItemIndex = -1;
      // Bindlist();
       Session["cart"] = dt;
       DataList1.DataSource = dt;
       DataList1.DataBind();
       lbltotal.Text = "Rs." + gettotal();
       }