how to insert values from dynMically created textbox into db

Question

0.00/5 (No votes)

See more:

i am created textbox dynamically . i want to upload datas from that textbox to db bt i wont works..

C#

TextBox t = new TextBox();
          t.Location = new System.Drawing.Point(379, 60);
          this.Controls["dynamicTextBox"].Text = "my text";
          t.Text = "What are you doing now";
          t.Multiline = true;
          t.Size = new System.Drawing.Size(430, 55);
          panel2.Controls.Add(t);

and one more thing i cannot able to ad t.id="dd"; id shows error. so i try t.name="dd" but insert db sqlcommand i cannot insert values "insert into tablename values '"+ dd.text+"'",c.
dd.text shows error.
kindly rectify or provide valid code

Posted 17-Aug-15 1:08am

anandvijay1940

Add a Solution

2 solutions

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)

Wendelius · Answer 1 · 2015-08-17T01:20:00

Solution 1

It doesn't matter if the text box is created dynamically or not. The basic principle is always the same:
- get the value from a control
- set the value into a parameter
- execute the parameterized statement.

In other words, you should use an SQL statement which uses parameters as explained in SqlParameter[^]

Posted 17-Aug-15 1:20am

Wendelius

Comments

anandvijay1940 17-Aug-15 7:25am

bt textbox t=new textbox();
t.id="sd";
id not works me..
i dont knw y?

Wendelius 18-Aug-15 0:22am

At least two problems with the code above.
- What is bt?
- depending on the technology and what you have done, but most likely the textbox does not have a property called id.

Maciej Los 17-Aug-15 16:46pm

5ed!

Wendelius 18-Aug-15 0:19am

Thank you Maciej.

Maciej Los · Answer 2 · 2015-08-17T10:53:00

Solution 2

In addition to solution1 by Mika Wendelius[^], it's strongly recommended to read this article: Creating Dynamic Data Entry User Interfaces[^]

For further information, please see:
Create dynamic Textbox and Dropdownlist with Validation[^]
Save multiple Dynamic Textbox values to SQL database Windows Forms C#[^]

Posted 17-Aug-15 10:53am

Maciej Los

Comments

Wendelius 18-Aug-15 0:19am

Good links!

Maciej Los 18-Aug-15 1:50am

Thank you, Mika.