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

What is Boxing and Unboxing?

7 Answers   Accenture, IBM, Tech Mahindra,


How can you send an email message from an asp.net web page?

0 Answers  


Does google crawl redirects?

0 Answers  


What is the answer for "Which configuration Tool your using means" ? we have to tell about IIS or .Net Framework or VSS? Give me in brief ?

3 Answers   eXensys,


What is syntax code to send email from an asp.net application?

0 Answers  






What is the Difference B/W Finalize() and Dispose() in .Net?

12 Answers   HCL, IBM,


What is the use of web.config and machine.config files?

0 Answers   Amdocs,


1.how to encrpt query string in asp.net? 2.there are 10000 records then i wnat display 5000 records one gridview and 5000 records another grid view what is the process?

2 Answers   Marlabs,


how we can solve machine key error in asp.net?

3 Answers  


What is localhost in asp.net?

0 Answers  


What is ASLM?

0 Answers   MCN Solutions,


What do you understand from custom control?

0 Answers   C DAC, CDAC,


Categories