private void Page_Load(object sender, System.EventArgs e)
        {
            // Put user code to initialize the page here

            for(int i=0;i<5;i++)
            {
                Table t1=new Table();
                TextBox t=new TextBox();
                Table1.Parent.Controls.Add(t);
                TableRow tr=new TableRow();
                TableCell tc=new TableCell();
                Table1.Rows.Add(tr);
                tr.Cells.Add(tc);
                tc.Controls.Add(t);
                //t.ID="t1";
            }

        }


private void LinkButton1_Click(object sender, System.EventArgs e)
        {

            index=int.Parse(h.Value);
            if(index>=0)
            {
                for(int i=0;i<=index;i++)
                {
                    TextBox t=new TextBox();
                    TableRow tr=new TableRow();
                    TableCell tc=new TableCell();
                    Table1.Rows.Add(tr);
                    tr.Cells.Add(tc);
                    tc.Controls.Add(t);
                    t.ID="textbox"+i.ToString();
                    t.ToolTip=t.ID;
                    h2.Value=t.ID;
                    String s=t.Text;
                }
                index=index+1;
                h.Value=index.ToString();

                //Response.Write(h2.Value);
            }

        }


private void Button1_Click(object sender, System.EventArgs e)
        {
            String a=0;
            t.text=a;


        //Response.Write(h2.Value);
        index=int.Parse(h.Value);
        for(int i=0;i<index;i++)
        {
SqlConnection cn=new SqlConnection("user id=sa;password=;data source=econduit2;initial catalog=pubs");
            cn.Open();
SqlCommand cmd=new SqlCommand("insert into dynamic(name)values(@nam)",cn);
SqlParameter p1;
p1=cmd.Parameters.Add(new SqlParameter("@nam",SqlDbType.VarChar));
            p1.Value=t.Text;
            cmd.ExecuteNonQuery();
            Response.Write(index);
        }
        }









How to added data of the textboxes into database field

please send code anyone

venkat