Creating Multiple Dynamic TextBox in c# n storing the value in mssql

emma oj

Please help me with the code to create Dynamic TextBox in ASP.NET and store data to SQL Server using button click. Every time a user enters x number of textbox inside the Textbox field and click on the button,it will generate the stated x numbers of row with three individual Textbox and another button will save the value to database.

Example: x = 4

[ TextBox1 ] [TextBox2] [TextBox3] | |New Row|

[ TextBox4 ] [TextBox5] [TextBox6] |New Row|

[ TextBox7 ] [TextBox6] [TextBox9] |New Row|

[ TextBox10 ] [TextBox11] [TextBox12] |New Row|

|Save|

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar5y ago
Accepted answer
Hi,

Please use this link which will help you,
https://www.aspforums.net/Threads/101989/Dynamically-add-and-remove-TextBox-and-save-value-to-Database-with-UserControl-using-C-and-VBNet-in-ASPNet/
+1
emma oj5y ago
Thank you so much Jignesh Kumar ,i really appreciate.But the values does not store to the database.
0
Sachin Singh5y ago
In your example the column is fixed as 3 , but when you are creating everything at run time then make it dynamica as well , specify number of cols and rows and it will generate table with textboxes
private void GenerateTable(int colsCount, int rowsCount){

        //Creat the Table and Add it to the Page
        Table table = new Table();
        table.ID = "Table1";
        Page.Form.Controls.Add(table);

        // Now iterate through the table and add your controls
        for (int i = 0; i < rowsCount; i++){
            TableRow row = new TableRow();
            for (int j = 0; j < colsCount; j++){
                TableCell cell = new TableCell();
                TextBox tb = new TextBox();

                // Set a unique ID for each TextBox added
                tb.ID = "TextBoxRow_" + i + "Col_" + j;
                // Add the control to the TableCell
                cell.Controls.Add(tb);
                // Add the TableCell to the TableRow
                row.Cells.Add(cell);
            }

            // Add the TableRow to the Table
            table.Rows.Add(row);
        }
}

protected void Page_Load(object sender, EventArgs e){
         // the two paramters are declared globally
         GenerateTable(numOfColumns, numOfRows);
}
0