How to insert the Dynamically generated textbox values in a database

Question

0.00/5 (No votes)

See more:

C#

if (txtQuantity.Text != "")
        {
            try
            {
                for (int i = 0; i < quantity; i++)
                {
                    foreach (Control ctrl in this.Controls)
                    {
                        TextBox txtBox1 = new TextBox();
                        txtBox1.ID = "tb1" + i.ToString();
                        txtBox1.Text = txtBox1.Text;
                        PlaceHolder1.Controls.Add(txtBox1);
                        if (ctrl is TextBox)
                        {
                            
                            con.Open();  
                            string qryInsertProduct = "insert into Product_Details(GatePassNo,ClientID,Product_name,SerialNo,Status,CheckIN_Date ,Customer_Name, Customer_location) values('" + GatePassNo + "','" + clientID + "','" + productName + "','" + txtBox1.Text + "','" + status + "','" + TextBox1.Text + "','" + ddlCName.SelectedItem.Value + "','" + ddlCLocation.SelectedItem.Value + "')";
                            SqlCommand comInsertProduct = new SqlCommand(qryInsertProduct, con);
                            comInsertProduct.ExecuteNonQuery();
                        }
                    }

This my code, please help.

Posted 25-Feb-14 21:40pm

Member 10578683

Updated 25-Feb-14 21:55pm

Maciej Los

v2

Add a Solution

Comments

Maciej Los 26-Feb-14 3:55am

And the issue is...

Member 10578683 26-Feb-14 4:09am

according to quantity the textboxes are dynamically generating. i need the value that i m writing in that dynamically generated textboxes into my database. SerialNo is the column where i want to insert. How will i do this. please help.

V5709 26-Feb-14 5:59am

what is the error in this code? you said that you want to insert text value of dynamically generated text boxes into db. But here creation of text boxes & insertion of its values into db are in same function .How it is possible?how you are going to write text in dynamic textbox?

Member 10578683 26-Feb-14 6:13am

i have written the code to create the textboxes in othher btn Click event.here i wrote the code to insert

V5709 26-Feb-14 6:14am

then where thing is going wrong?

V5709 26-Feb-14 6:21am

what issue you are facing? is there is any exception?

Member 10578683 26-Feb-14 6:32am

all valuese are inserting in db except the SerialNo. That field remains empty

Member 10578683 26-Feb-14 6:22am

public partial class CheckIn : System.Web.UI.Page
{
DataUtility du = new DataUtility();

SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["Con"]);
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string[] filePaths = Directory.GetFiles(Server.MapPath("~/upload/"));
List<ListItem> files = new List<ListItem>();
foreach (string filePath in filePaths)
{
files.Add(new ListItem(Path.GetFileName(filePath), filePath));
}
GridView1.DataSource = files;
GridView1.DataBind();
}

if (!Page.IsPostBack)
{
//lblCurrentDate.Text = DateTime.Now.ToString();
BindCName();
ddlCLocation.Items.Insert(0, "<--Select-->");
ddlCLocation.Items[0].Value = "";
BindProducts();
gdvProducts.Visible = false;

}

}
protected void ddlCName_SelectedIndexChanged(object sender, EventArgs e)
{
string qryLocation = "select Customer_Location from Customer_Details where Customer_name='" + ddlCName.SelectedItem.Value + "'";
DataSet dsLocation = du.GetDataSet(qryLocation);
ddlCLocation.DataSource = dsLocation;
ddlCLocation.DataTextField = "Customer_Location";
ddlCLocation.DataValueField = "Customer_Location";
ddlCLocation.DataBind();
ddlCLocation.Items.Insert(0, "<--Select-->");
ddlCLocation.Items[0].Value = "";
}
public void BindCName()
{
string qry = "select distinct Customer_Name from Customer_Details";
DataSet ds = du.GetDataSet(qry);
ddlCName.DataSource = ds;
ddlCName.DataTextField = "Customer_Name";
ddlCName.DataValueField = "Customer_Name";
ddlCName.DataBind();
ddlCName.Items.Insert(0, "<--Select-->");
ddlCName.Items[0].Value = "";

}

protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{

// string entryDate = lblCurrentDate.Text;
string customerName = ddlCName.SelectedItem.Value;
string customerLocation = ddlCLocation.SelectedItem.Value;
string GatePassNo = txtGatePass.Text;
ViewState["GatePassNo"] = GatePassNo;
string productName = ddlProductName.SelectedItem.Value;

con.Open();
string qryClientID = "select ID from Customer_Details where Customer_Name='" + customerName + "' and Customer_Location='" + customerLocation + "'";
int clientID = du.ExecuteSqlScaler(qryClientID);

string qryCustomer_Name = "select Customer_name from Customer_Details where Customer_name='" + ddlCName.SelectedItem.Value + "' and Customer_Location='" + customerLocation + "'";
SqlCommand comma = new SqlCommand(qryCustomer_Name, con);
comma.ExecuteNonQuery();
con.Close();
int quantity = Convert.ToInt32(txtQuantity.Text.Trim());
// string serials = txtSerials.Text;
string status = "Under Repair";
//string qryCheck = "Select GatePassNo from Product_Details ";
//string[] serialArray = serials.Split(';');
if (txtQuantity.Text != "")
{
try
{
for (int i = 0; i < quantity; i++)
{
foreach (Control ctrl in this.Controls)
{
TextBox txtBox1 = new TextBox();
txtBox1.ID = "tb1" + i.ToString();
txtBox1.Text = txtBox1.Text;
PlaceHolder1.Controls.Add(txtBox1);
if (ctrl is TextBox)
{

con.Open();
string qryInsertProduct = "insert into Product_Details(GatePassNo,ClientID,Product_name,SerialNo,Status,CheckIN_Date ,Customer_Name, Customer_location) values('"

Member 10578683 26-Feb-14 6:52am

did you understand my problem

Member 10578683 26-Feb-14 6:56am

please help

2 solutions

Solution 1

As per i understand you're trying to dynamically create TextBox control, assign a value to it and save its value into database. You did not provide enough information to provide direct answer.

Looking at code you've provided, i do not understand why do you need to create TextBox dynamically, especially when you create TextBox in the same code which is used to save value into database. It means that user can't enter/type any value into newly created textbox.

Sorry, but it looks like code-dump. You'll not be able go further, until you do not understand what your code does.

I would suggest to start here:
ASP.NET[^]
Connecting to Databases in ASP.NET[^]
Walkthrough: Editing and Inserting Data in Web Pages with the DetailsView Web Server Control[^]

On the other hand, you should read about SQL Injection[^].
How To: Protect From SQL Injection in ASP.NET[^]
Stop SQL Injection Attacks Before They Stop You[^]
SQL Injection and how to avoid it[^]

Posted 26-Feb-14 3:48am

Maciej Los

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

V5709 · Accepted Answer · 2014-02-26T17:40:00

Just look at your code.

C#

for (int i = 0; i < quantity; i++)
                {
                    foreach (Control ctrl in this.Controls)
                    {
                        TextBox txtBox1 = new TextBox();
                        txtBox1.ID = "tb1" + i.ToString();
                        txtBox1.Text = txtBox1.Text;
                        PlaceHolder1.Controls.Add(txtBox1);
                        if (ctrl is TextBox)
                        {
                            
                            con.Open();  
                            string qryInsertProduct = "insert into Product_Details(GatePassNo,ClientID,Product_name,SerialNo,Status,CheckIN_Date ,Customer_Name, Customer_location) values('" + GatePassNo + "','" + clientID + "','" + productName + "','" + txtBox1.Text + "','" + status + "','" + TextBox1.Text + "','" + ddlCName.SelectedItem.Value + "','" + ddlCLocation.SelectedItem.Value + "')";
                            SqlCommand comInsertProduct = new SqlCommand(qryInsertProduct, con);
                            comInsertProduct.ExecuteNonQuery();
                        }
                    }

Here in loop you have created text box controls.Just followed by an insert statement.
You are assigning text to dynamically created text boxes by the code line

C#

txtBox1.Text = txtBox1.Text;

Here both 'txtBox1.Text' are blank.That's why you are not getting any text value to insert.