how to create textboxes dynamically and insert textbox text
into sql database

Answers were Sorted based on User's Feedback



how to create textboxes dynamically and insert textbox text into sql database ..

Answer / aravind

TextBox1 = new TextBox();
TextBox1.ID = "TextBox1";
TextBox1.Style["Position"] = "Absolute";
TextBox1.Style["Top"] = "25px";
TextBox1.Style["Left"] = "100px";
Form1.Controls.Add(TextBox1);
and using
insert into columuname value ("+ textbox1.text+")

Is This Answer Correct ?    12 Yes 9 No

how to create textboxes dynamically and insert textbox text into sql database ..

Answer / harsh

private void buttongenerate_Click(object sender, EventArgs
e)
{
int inputnumber = Int32.Parse
(TextboxInput.Text);
inputtextboxes = new List<TextBox>();


for (int i = 1; i <= inputnumber; i++)
{
Label labelinput = new Label();
TextBox textboxnewinpute = new TextBox();
labelinput.Text = "Input" + i;
labelinput.Location = new Point(30,
TextboxInput.Bottom + (i * 30));
labelinput.AutoSize = true;

textboxnewinpute.Text = "";
textboxnewinpute.Name = "MyTextbox";
textboxnewinpute.Location = new Point
(labelinput.Width, labelinput.Top - 3);
inputtextboxes.Add(textboxnewinpute);
this.Controls.Add(labelinput);
this.Controls.Add(textboxnewinpute);

}

}



private void button2_Click(object sender, EventArgs e)
{
try
{
foreach (Control ctrl in Controls)
{
if (ctrl.Name == "MyTextbox")
{
if (con != null)
{
using (con)
{
int a = Convert.ToInt32
(TextboxInput.Text);
for (int i = 1; i <= a; i++)
{
cmd = new SqlCommand
("insert into DynamicDBdemo values ('" + ctrl.Text + "')",
con);
cmd.CommandType =
System.Data.CommandType.Text;
if
(cmd.Connection.State == System.Data.ConnectionState.Closed)
{
cmd.Connection.Open
();
}
}
if
(cmd.Connection.State == ConnectionState.Open)
{
cmd.ExecuteNonQuery
();
MessageBox.Show
("data added successfully");
}
}
}
}
}
}
catch (SqlException sx)
{
MessageBox.Show(sx.Message);
}
finally
{
con.Close();
}
}

Is This Answer Correct ?    3 Yes 9 No

Post New Answer

More ASP.NET Interview Questions

Why cyclomatic complexity is important?

0 Answers  


How can we update records in gridview?Is there any appropriate code for it?

0 Answers  


How can u handle Exceptions in Asp.Net?

4 Answers  


What are the data controls available in asp.net?

0 Answers  


I have developed a web application in asp.net 2.0 with Access as back end i am trying to gereate report/export data in excel. After hosting the site i am not getting any error or such exported excel file. but using the source code from my system it works fine. Could any one tell me why it is happening and what is its solution.

2 Answers  


What are sql notifications and sql invalidations?

0 Answers  


What are the Types of state management techniques

0 Answers   Digital GlobalSoft,


How can we secure the data which is send from client side to server? Like the login id and paasword needs to be authenticated on the server but we cannot send it in plain text into the server.One more thing we are not using the SSL here.

0 Answers   Microsoft,


To display data in a Repeater control which templete is provided ?

4 Answers   Siebel,


What is the typical session identifier?

0 Answers  


What Are Different Types of Debbugers

2 Answers   Accenture, TCS, Wipro,


How do you open a page in a new window?

0 Answers  


Categories