Insert data in database from dynamically generated textbox.

Question

I want to insert data in data base from dynamically generated textboxes.I am using below code but it is not working properly and giving me errors. .aspx "C#" AutoEventWireup= "true" CodeBehind= "test_table_dynamic.aspx.cs" Inherits= "Test_captcha.test_table_dynamic" %> "http://www.w3.org/1999/xhtml" > "server" > "Content/bootstrap.css" rel= "stylesheet" /> "Scripts/jquery-3.0.0.js" > "Scripts/bootstrap.js" > body { font-family: 'lato' , sans-serif; } .container { max-width: 1000px; margin-left: auto; margin-right: auto; padding-left: 10px; padding-right: 10px; } h2 { font-size: 26px; margin: 20px 0; text-align: center; } h2 small { font-size: 0.5em; } .responsive-table li { border-radius: 3px; padding: 25px 30px; display: flex; justify-content: space-between; margin-bottom: 25px; } .responsive-table .table-header { background-color: #95A5A6; font-size: 14px; text-transform: uppercase; letter-spacing: 0.03em; } .responsive-table .table-row { background-color: #ffffff; box-shadow: 0px 0px 9px 0px rgba(0, 0, 0, 0.1); } .responsive-table .col-1 { flex-basis: 5%; } .responsive-table .col-2 { flex-basis: 50%; } .responsive-table .col-3 { flex-basis: 25%; } .responsive-table .col-4 { flex-basis: 25%; } @media all and (max-width: 767px) { .responsive-table .table-header { display: none; } .responsive-table li { display: block; } .responsive-table .col { flex-basis: 100%; } .responsive-table .col { display: flex; padding: 10px 0; } .responsive-table .col:before { color: #6C7A89; padding-right: 10px; content: attr(data-label); flex-basis: 50%; text-align: right; } } "text/javascript" > function addRow(tableID) { var table = document.getElementById(tableID); var rowCount = table.rows.length; var row = table.insertRow(rowCount); var colCount = table.rows[0].cells.length; for ( var i = 0; i var newcell = row.insertCell(i); newcell.innerHTML = table.rows[0].cells[i].innerHTML; //alert(newcell.childNodes); switch (newcell.childNodes[0].type) { case "text" : newcell.childNodes[0].value = "" ; break ; case "checkbox" : newcell.childNodes[0].checked = false ; break ; case "select-one" : newcell.childNodes[0].selectedIndex = 0; break ; } } } function deleteRow(tableID) { try { var table = document.getElementById(tableID); var rowCount = table.rows.length; for ( var i = 0; i var row = table.rows[i]; var chkbox = row.cells[0].childNodes[1]; if (chkbox != null && chkbox.checked == true ) { if (rowCount alert( "Cannot delete all the rows." ); break ; } table.deleteRow(i); rowCount--; i--; } } } catch (e) { alert(e); } } "form1" runat= "server" > class = "container" > Sprinkler Irrigation Component's price class = "responsive-table" > class = "table-row" > class = "col col-1" data-label= "Job Id" >Email: class = "col col-2" data-label= "Customer Name" > "form-control" ID= "c_email" placeholder= "Email" runat= "server" > class = "col col-3" data-label= "Amount" > class = "container" > class = "responsive-table" > class = "table-row" > class = "col col-1" data-label= "Job Id" >Nozzle class = "col col-2" > "dataTable1" class = "table-bordered table-hover table-striped table" > "checkbox" name= "chk" /> "nozzle_lph" runat= "server" type= "text" placeholder= "LPH" > "nozzle_price" runat= "server" type= "text" placeholder= "RS./unit" > class = "col col-3" > class = "col col-4" > "button" class = "btn btn-danger active" value= "Add Row" onclick= "addRow('dataTable1')" /> "button" class = "btn btn-info active" value= "Delete Row" onclick= "deleteRow('dataTable1')" /> class = "container" > class = "responsive-table" > class = "table-row" > class = "col col-1" data-label= "Job Id" >Lateral class = "col col-2" > "dataTable2" class = "table-bordered table-hover table-striped table" > "checkbox" name= "chk" /> "txt_lat_mm" runat= "server" type= "text" placeholder= "LPH" > "txt_lat_price" runat= "server" type= "text" placeholder= "RS./unit" > class = "col col-3" > class = "col col-4" > "button" class = "btn btn-danger active" value= "Add Row" onclick= "addRow('dataTable2')" /> "button" class = "btn btn-info active" value= "Delete Row" onclick= "deleteRow('dataTable2')" /> class = "container" > class = "responsive-table" > class = "table-row" > class = "col col-1" data-label= "Job Id" >Submain Pipe class = "col col-2" > "dataTable3" class = "table-bordered table-hover table-striped table" > "checkbox" name= "chk" /> "txt_smain_mm" runat= "server" type= "text" placeholder= "LPH" > "txt_smain_price" runat= "server" type= "text" placeholder= "RS./unit" > class = "col col-3" > class = "col col-4" > "button" class = "btn btn-danger active" value= "Add Row" onclick= "addRow('dataTable3')" /> "button" class = "btn btn-info active" value= "Delete Row" onclick= "deleteRow('dataTable3')" /> class = "container" > class = "responsive-table" > class = "table-row" > class = "col col-1" data-label= "Job Id" >Main Pipe class = "col col-2" > "dataTable4" class = "table-bordered table-hover table-striped table" > "checkbox" name= "chk" /> "txt_main_mm" runat= "server" type= "text" placeholder= "LPH" > "txt_main_price" runat= "server" type= "text" placeholder= "RS./unit" > class = "col col-3" > class = "col col-4" > "button" class = "btn btn-danger active" value= "Add Row" onclick= "addRow('dataTable4')" /> "button" class = "btn btn-info active" value= "Delete Row" onclick= "deleteRow('dataTable4')" /> class = "container" > class = "responsive-table" > class = "table-row" > class = "col col-1" data-label= "Job Id" >Motor Pumping Unit class = "col col-2" > "dataTable5" class = "table-bordered table-hover table-striped table" > "checkbox" name= "chk" /> "txt_mpum_hp" runat= "server" type= "text" placeholder= "LPH" > "txt_mpump_price" runat= "server" type= "text" placeholder= "RS./unit" > class = "col col-3" > class = "col col-4" > "button" class = "btn btn-danger active" value= "Add Row" onclick= "addRow('dataTable5')" /> "button" class = "btn btn-info active" value= "Delete Row" onclick= "deleteRow('dataTable5')" /> class = "table-row" > class = "col col-1" data-label= "Job Id" > class = "col col-2" data-label= "Customer Name" > "sprink_submit" runat= "server" CssClass= "btn btn-danger btn-group-lg active" Text= "Submit" OnClick= "sprink_submit_Click" /> class = "col col-3" data-label= "Amount" > "Button2" runat= "server" CssClass= "btn btn-warning btn-group-lg active" Text= "Back" /> .aspx.cs using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; using System.Configuration; using System.IO; using System.Web.Script.Serialization; namespace Test_captcha { public partial class test_table_dynamic : System.Web.UI.Page { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[ "Mycon" ].ToString()); protected string Values; protected void Page_Load( object sender, EventArgs e) { //c_email.Text = Session["Company"] as string; } protected void sprink_submit_Click( object sender, EventArgs e) { SqlCommand cmd = new SqlCommand( "insert into company_sprinkler_data_test(company_email,nozzle_lph,noozle_price,lateral_mm,lateral_price,main_mm,main_price,Sp_mpump_hp,Sp_mpump_price)values(@company_email,@nozzle_lph,@nozzle_price,@lateral_mm,@lateral_price,@main_mm,@main_price,@Sp_mpump_hp,@Sp_mpump_price)" ); con.Open(); cmd.Connection = con; cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue( "@company_email" , c_email.Text.Trim().ToString()); cmd.Parameters.AddWithValue( "@nozzle_lph" , nozzle_lph.Text.Trim().ToString()); cmd.Parameters.AddWithValue( "@nozzle_price" , nozzle_price.Text.Trim().ToString()); cmd.Parameters.AddWithValue( "@lateral_mm" , txt_lat_mm.Text.Trim().ToString()); cmd.Parameters.AddWithValue( "@lateral_price" , txt_lat_price.Text.Trim().ToString()); cmd.Parameters.AddWithValue( "@submain_mm" , txt_smain_mm.Text.Trim().ToString()); cmd.Parameters.AddWithValue( "@submain_price" , txt_smain_price.Text.Trim().ToString()); cmd.Parameters.AddWithValue( "@main_mm" , txt_main_mm.Text.Trim().ToString()); cmd.Parameters.AddWithValue( "@main_price" , txt_main_price.Text.Trim().ToString()); cmd.Parameters.AddWithValue( "@Sp_mpump_hp" , txt_mpum_hp.Text.Trim().ToString()); cmd.Parameters.AddWithValue( "@Sp_mpump_price" , txt_mpump_price.Text.Trim().ToString()); int row; try { row = cmd.ExecuteNonQuery(); if (row > 0) { ScriptManager.RegisterStartupScript( this , GetType(), "alert" , "alert('Price added Sucessful');window.location='MIS_login.aspx';" , true ); } else { ScriptManager.RegisterStartupScript( this , GetType(), "alert" , "alert('Add Prices again');" , true ); } } catch (Exception) { throw ; } finally { if (con.State == ConnectionState.Open) con.Close(); } } } } Data table CREATE TABLE [dbo].[company_sprinkler_data_test] ( [sprink_id] INT IDENTITY (1, 1) NOT NULL , [company_email] VARCHAR (100) NULL , [nozzle_lph] INT NULL , [noozle_price] FLOAT (53) NULL , [lateral_mm] INT NULL , [lateral_price] FLOAT (53) NULL , [main_mm] INT NULL , [main_price] FLOAT (53) NULL , [Sp_mpump_hp] INT NULL , [Sp_mpump_price] FLOAT (53) NULL , PRIMARY KEY CLUSTERED ([sprink_id] ASC ) );

Priyanka Jain · Answer

You need to check nullable in your code also. Also the type of string your fields are accepting

Priyanka Jain · Answer

You need to use Form1.FindControl[" "] as Textbox to get dynamic control id but this is just for single controls, you can use dynamically generate id to get text value cmd.Parameters.AddWithValue( "@company_email" , (form1.FindControl( "c_email" ) as TextBox).Text.Trim().ToString()); cmd.Parameters.AddWithValue( "@nozzle_lph" , (form1.FindControl( "nozzle_lph" ) as TextBox).Text.Trim().ToString()); cmd.Parameters.AddWithValue( "@nozzle_price" ,Convert.ToInt32((form1.FindControl( "nozzle_price" ) as TextBox).Text.Trim())); cmd.Parameters.AddWithValue( "@lateral_mm" , Convert.ToInt32((form1.FindControl( "txt_lat_mm" ) as TextBox).Text.Trim())); cmd.Parameters.AddWithValue( "@lateral_price" , Convert.ToInt32((form1.FindControl( "txt_lat_price" ) as TextBox).Text.Trim().ToString())); cmd.Parameters.AddWithValue( "@submain_mm" , Convert.ToInt32((form1.FindControl( "txt_smain_mm" ) as TextBox).Text.Trim())); cmd.Parameters.AddWithValue( "@submain_price" , Convert.ToInt32((form1.FindControl( "txt_smain_price" ) as TextBox).Text.Trim())); cmd.Parameters.AddWithValue( "@main_mm" , Convert.ToInt32((form1.FindControl( "txt_main_mm" ) as TextBox).Text.Trim())); cmd.Parameters.AddWithValue( "@main_price" , Convert.ToInt32((form1.FindControl( "txt_main_price" ) as TextBox).Text.Trim())); cmd.Parameters.AddWithValue( "@Sp_mpump_hp" , (form1.FindControl( "txt_mpum_hp" ) as TextBox).Text.Trim())); cmd.Parameters.AddWithValue( "@Sp_mpump_price" , Convert.ToInt32((form1.FindControl( "txt_mpump_price" ) as TextBox).Text.Trim()));

Nidhi Donga · Answer

Server Error in '/' Application. Input string was not in a correct format. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Line 74: cmd.Parameters.AddWithValue("@submain_mm", Convert.ToInt32((form1.FindControl("txt_smain_mm") as TextBox).Text.Trim())); Dear Ma'am, Thank you for the code but this code is showing above error.