ASP.NET

protected void Button2_Click(object sender, EventArgs e)
    {
        OleDbDataReader dr = null;
        string str = "Select * From ProductSpecification";
        OleDbCommand cmd = new OleDbCommand(str, conn);
        conn.Open();
        dr = cmd.ExecuteReader();
        for (int i = 1; i < dr.VisibleFieldCount; i++)
        {
            while (dr.Read())
            {
                string s=dr["Specification"].ToString();
                TextBox txtctrl=new TextBox();
                txtctrl=(TextBox)Panel2.FindControl("txt" + s);
                    string s1 = txtctrl.Text;
                    string s2 = "Update ProductSpecification Set(Value='" + s1 + "')";
                    cmd = new OleDbCommand(s2, conn);
                    cmd.ExecuteNonQuery();
                
            }
        }
        conn.Close();
    }

protected void LinkButton2_Click(object sender, EventArgs e)
    {
        OleDbDataReader dr = null;
        string str = "Select * From ProductSpecification";
        OleDbCommand cmd = new OleDbCommand(str, conn);
        conn.Open();
        dr = cmd.ExecuteReader();
        for (int i = 1; i < dr.VisibleFieldCount; i++)
        {
            while (dr.Read())
            {
                Label lbl = new Label();
                String getlbl = dr["Specification"].ToString();
                lbl.ID = "lbl" + getlbl;
                lbl.Width=50;
                Panel2.Controls.Add(lbl);
                lbl.Text = getlbl;
                TextBox txt = new TextBox();
                string gettxt = dr["Specification"].ToString();
                txt.ID = "txt" + gettxt;
                Panel2.Controls.Add(txt);
                //Button b = new Button();
                //string getbutton=dr["Specification"].ToString();
                //b.ID = "btn" + getbutton;
                //b.Text = "Add";
                //Panel2.Controls.Add(b);
                Panel2.Controls.Add(new LiteralControl("<br>"));
            }
        }
        conn.Close();
        Button b = new Button();
        b.Text = "AddValues";
        b.Click += new EventHandler(btnadd_Click); //new EventHandler(btnadd_Click);
        Panel2.Controls.Add(b);
    }