Add data from dynamically added textbox to database

Question

Below is the code to add textboxes and button dynamically on button click. I need to add tat textbox data to database on another button click. Have no idea on that. Any suggestions will be helpful.

private void button1_Click(object sender, EventArgs e)
{
    int v;
    v = c++;
    panel1.VerticalScroll.Value = VerticalScroll.Minimum;

    Button btn = new Button();
    btn.Name = "btn" + v;
    btn.Text = "Remove";
    btn.Location = new Point(300, 5 + (30 * v));
    btn.Click += new EventHandler(btn_Click);

    TextBox txt = new TextBox();
    txt.Name = "TextBox" + v;
    txt.Location = new Point(30, 5 + (30 * v));
    txt.Tag = btn;

    TextBox txt1 = new TextBox();
    txt1.Name = "TextBox2" + v;
    txt1.Location = new Point(170, 5 + (30 * v));
    txt1.Tag = btn;

    panel1.Controls.Add(txt);
    panel1.Controls.Add(txt1);
    panel1.Controls.Add(btn);
}

private void btn_Click(object sender, EventArgs e)
{
    for (int i = panel1.Controls.Count - 1; i >= 0; i--) 
    {
        var item = panel1.Controls[i];

        if (item.Tag == sender || item == sender)
            panel1.Controls.Remove(item);
    }
}

Can you give specific details about that? Do you have a method for database interactions etc? — Anıl Canlı, Feb 27 '14 at 11:27
To get the textbox's text you can use something like this. `panel1.Controls["nameOfTextbox"].Text` — Sinya, Feb 27 '14 at 11:42

Sudhakar Tillapudi · Answer 1 · 2014-02-27T12:14:31.893

Solution : You need to save the Name of the dynamic TextBox Controls before accessing them as below:

List<String> controlNames=new List<String>();
TextBox txt = new TextBox();
txt.Name = "TextBox" + v;
controlNames.Add(txt.Name);
txt.Location = new Point(30, 5 + (30 * v));
txt.Tag = btn;


TextBox txt1 = new TextBox();
txt1.Name = "TextBox2" + v;
controlNames.Add(txt1.Name);
txt1.Location = new Point(170, 5 + (30 * v));
txt1.Tag = btn;

Now access them while to save the data into Database

protected void btnSaveData_Click(object sender, EventArgs e)
{

    //Read TextBox Values
    TextBox txBox1 = (TextBox) Controls.Find(controlNames[0],true)[0];
    TextBox txtBox2 = (TextBox) Controls.Find(controlNames[1],true)[0];
    MySqlConnection con = new MySqlConnection("connection string here");
    String query="INSERT INTO [TABLENAME] ([COLUMNNAME1],[COLUMNNAME2]) VALUES(@COLUMNVALUE1 , @COLUMNVALUE2)";
    MySqlCommand command = new MySqlCommand(query,con);

    command.Parameters.AddWithValue("@COLUMNNAME1",txBox1.Text);
    command.Parameters.AddWithValue("@COLUMNNAME2",txBox2.Text);

    int status=0;
    con.Open();
    status = command.ExecuteNonQuery();

    if(status>0)
    {
        MessageBox.Show("Rows Inserted Successfully!");
    }
    else
    {
        MessageBox.Show("No Rows Inserted!");
    }

    con.Close();
}

textboxws are dynamically added. How can i get the id or name of such textboxes — Robin, Feb 27 '14 at 11:46
@Robin: you need to provide second argument to Find() method as `true` check my edited answer — Sudhakar Tillapudi, Feb 27 '14 at 12:14
this code adds only one set of textboxes added dynamically to db.i can add many textboxes dynamically. How to get all the textbox values. — Robin, Feb 27 '14 at 13:04

Add data from dynamically added textbox to database

1 Answers1