Insert data in database from dynamically generated textbox.

Nidhi Donga

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

<%@ Page Language="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">
"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 < colCount; 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 < rowCount; i++) {
var row = table.rows[i];
var chkbox = row.cells[0].childNodes[1];
if (chkbox != null && chkbox.checked == true) {
if (rowCount <= 1) {
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)
);

3 Replies

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

Priyanka Jain7y ago
Accepted answer
You need to check nullable in your code also. Also the type of string your fields are accepting
Nidhi Donga7y ago
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.
Priyanka Jain7y ago
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()));

Insert data in database from dynamically generated textbox.

Sprinkler Irrigation Component's price