Inserting dynamic textbox data to database

Question

0.00/5 (No votes)

See more:

Hai,

Am developing a project in which am getting dynamic text boxes on button click, am not getting how to insert data in dynamic text boxes to data base on clicking submit button.~~Its urgent~~ help me.

my .cs page looks like this

C#

protected void btn1_Click(object sender, EventArgs e)
    {
        int a = 3;
        for (; a <= 5; a++)
        {
            TextBox lndline = new TextBox();
            lndline.ID = "lndline_txt" + a;
            r1_tc2.Controls.Add(lndline);
            Literal li1 = new Literal();
            li1.Text = "";
            r1_tc2.Controls.Add(li1);
        }
        int b = 1;
        if (b==1)
        {
            btn1.Enabled = false;
        }
    }

help me inserting the data to database.

Posted 18-May-12 21:09pm

shabadiveda

Updated 18-May-12 21:10pm

Wendelius

v2

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2012-05-18T21:14:00

Since you haven't posted anything that's related to the insertion in the database, the list of the steps are:
- Open a connection, see: SqlConnection[^]
- Create an SqlCommand[^]
- Add proper parameters, see SqlParameter[^]
- Set the values of the parameters
- Start a transaction, see SqlTransaction[^]
- Execute the command
- Commit or rollback the transaction depending on the success of the execution
- Close the connection
- Dispose the objects

Sangramsingh Pawar · Answer 2 · 2012-05-18T21:31:00

Use following

C#

List<string> list_txt_values=GetTxtValues();// Here you gets values of dynamically //created text boxes
// Now Call Your Function To Insert values in Database 

List<string> GetTxtValues()
{
List<string> list_txt_values = new List<string>();
  foreach(Control ctr in r1_tc2.Controls)
  {
    if(ctr.GetType().Name=="TextBox" && ((TextBox)ctr).Id.Contains("lndline_txt"))
    {
      list_txt_values.Add(((TextBox)ctr).Text) ;
    }
  }
return list_txt_values; 
}
</string></string></string></string>

Inserting dynamic textbox data to database

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Inserting dynamic textbox data to database

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us