add value to database from dynamically created textbox

[raghulvarma]

I have created only one object for the textbox and that particular textbox is being repeated as many times I want.But if I want to add the values in the database from each and every textbox which have been dynamically created how should I do that? I have uesd dropdown box to get the number of textboxes to be displayed and used panel to display them.
Let me explain with my real time scenario , if customer-A has 2 telephone lines and customer-B has 3 telephone lines then the textbox are displayed as required but how to add these values to DataBase from dynamically created textboxes?
thanx in advance

[nateraaaa]

Do the textboxes that you create dynamically contain an id property for each textbox? If not I would recommend that you use a counter variable or some other way to distinguish which textbox is which. Then simply reference the Text property of the textbox and pass that string value to your database as a parameter in a stored procedure.

Nathan

[Frinavale]

I have created only one object for the textbox and that particular textbox is being repeated as many times I want.But if I want to add the values in the database from each and every textbox which have been dynamically created how should I do that? I have uesd dropdown box to get the number of textboxes to be displayed and used panel to display them.
Let me explain with my real time scenario , if customer-A has 2 telephone lines and customer-B has 3 telephone lines then the textbox are displayed as required but how to add these values to DataBase from dynamically created textboxes?
thanx in advance

How are you dynamically displaying the textboxes?

[Frinavale]

I have an example for you:

Private textBoxArr(6) As TextBox
 
Private Sub Page_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init
    'This event happens before any controls are initialized by ASP.NET
    'The ViewState for objects has not been loaded.
    'After this event happens, the ViewState is loaded for each control and the object's properties are filled with the values submitted.
 
    'Creating the TextBox Objects that are dynamically shown in the web page
    'according to the number selected from a DropDownList
        For x As Integer = 0 To textBoxArr.Length - 1
            textBoxArr(x) = New TextBox
            textBoxArr(x).ID = "myTextBox" + x.ToString
            textBoxArr(x).Visible = False 'Initializing the TextBox so that it is not rendered in the browser 
            Pnl_TextBoxes.Controls.Add(textBoxArr(x)) 'Adding the TextBox to the Panel that holds the text boxes.
        Next
 
End Sub
 
Protected Sub numTextBoxes_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles numTextBoxes.SelectedIndexChanged
        For x As Integer = 0 To numTextBoxes.SelectedValue - 1
            textBoxArr(x).Visible = True 'Setting the TextBox to True
        Next
End Sub
 
Private Sub btnText_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnText.Click
 
        Dim str As New StringBuilder
 
        For i As Integer = 0 To textBoxArr.Length - 1
            If Not textBoxArr(i) Is Nothing Then
                str.Append(" " + textBoxArr(i).Text) 'Grabbing the text from the TextBox...remember that at this stage the TextBox's Text property has already been set by ASP.NET according to its ViewState
            End If
        Next
 
    'Showing in a label what was in the TextBoxes
        lbl_message.Text = "message: " + str.ToString
    'Instead of showing these values, you should store them in your database.
    End Sub