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

Question

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|

Jignesh Kumar · 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/

Sachin Singh · Answer

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 TableRow row = new TableRow(); for ( int j = 0; 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); }

emma oj · Answer

Thank you so much Jignesh Kumar ,i really appreciate.But the values does not store to the database.

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

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)