how to insert multiple textbox values on button click event

Question

how to insert multiple textbox values on button click event in a single cloumn

Upendra Pratap Shahi · Answer

Kindly go through this link- http://stackoverflow.com/questions/22591756/get-values-from-dynamically-added-textboxes-asp-net-c-sharp

Rajeesh Menoth · Answer

Hi Check the accepted answer in this link : http://forums.asp.net/p/1447166/3296156.aspx Code: using System.Collections.Specialized; using System.Text; using System.Data.SqlClient; //At Button Click event int numOfTextBox = 5; StringCollection sc = new StringCollection(); for (int i = 1; i //extract the TextBox values TextBox txtQuestion =(TextBox)Page.FindControl(TextBoxQuestion + i); TextBox txtAnswer =(TextBox)Page.FindControl(TextBoxAnswer + i); //get the values here and add it in a collection sc.Add(txtQuestion.Text +  + txtAnswer.Text); } InsertRecords(sc); //End private void InsertRecords(StringCollection sc){ SqlConnection conn = new SqlConnection(Your Connection String); StringBuilder sb = new StringBuilder(string.Empty); string[] splitItems = null; foreach (string item in sc) { const string sqlStatement = INSERT INTO Table1 (Column1Column2) VALUES; if (item.Contains()) { splitItems = item.Split(.ToCharArray()); sb.AppendFormat({0}('{1}''{2}');  sqlStatement splitItems[0] splitItems[1]); } } try { conn.Open(); SqlCommand cmd = new SqlCommand(sb.ToString() conn); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); } catch (System.Data.SqlClient.SqlException ex) { string msg = Insert Error:; msg += ex.Message; throw new Exception(msg); } finally { conn.Close(); } }

Saroj Kumar Sahu · Answer

Hi Syed I think all of your textbox control is in the form not in master page. if so then find the below code for your reference. protected void Button1_Click(object sender EventArgs e) { //your sql connection SqlConnection con = new SqlConnection(Data Source=yourserver;Initial Catalog=yourdatabase;User ID=user;Password=password); int i = 1; String All50Values = ; string str = insert into devicenumber(DeviceNumber) values (@devicenumber); while (i { string id = TextBox + i; TextBox txtobj = Page.FindControl(id) as TextBox; if (txtobj.Text != ) { All50Values = All50Values + txtobj.Text + ; //Note the delimter here is  } else { Response.Redirect(Devicenumber.aspx); } i++; } //remove last comma from the string All50Values = All50Values.Remove(All50Values.Length - 1); try { //Do it Outside the While. Opening a connection is costly operation con.Open(); SqlCommand cmd = new SqlCommand(str con); cmd.Parameters.AddWithValue(@devicenumber All50Values); cmd.ExecuteNonQuery(); con.Close(); } catch { } } Note:If all of your textbox control is in master page then replace the Line Page.FindControl(id) as TextBox with Master.FindControl(id) as TextBox

Inathi Gqola · Answer

Hi Syed This is how you would do your insert. Of course you would have to include all your 50 parameters I only included three. private void yourButton_Click(object sender EventArgs e) { string yourName = txtName.Text; string yourSurname = txtSurname.Text; int sales = txtSales; yourDatabaseConn.Open(); SqlCommand yourCommand = new Sql Command(); yourCommand.Connection = yourDatabaseConn; yourCommand.CommandText = INSERT INTO yourTable (yourName yourSurname numOfSales)VALUES(@parameter1 @parameter2 @parameter3); yourCommand.Parameters.AddWithValue(@parameter1 yourName); yourCommand.Parameters.AddWithValue(@parameter2 yourSurname); yourCommand.Parameters.AddWithValue(@parameter3 numOfSales); yourCommand.ExecuteNonQuery(); yourDatabaseConn.Close(); Happy Coding! NB: I have not tested the code.

Sivaraman Dhamodaran · Answer

You should edit you code as follows (Note that it is not tested and I am leaving that to you) protected void Button1_Click(object sender EventArgs e) { int i = 1; String All50Values = ; string str = insert into devicenumber(DeviceNumber) values (@devicenumber); while (i { string id = TextBox + i; TextBox txtobj = Master.FindControl(id) as TextBox; if(txtobj.Text!=) { All50Values = All50Values + txtobj.Text + ; //Note the delimter here is  } else { Response.Redirect(Devicenumber.aspx); } i++; } //Do it Outside the While. Opening a connection is costly operation con.Open(); cmd = new SqlCommand(str con); cmd.Parameters.AddWithValue(@devicenumber All50Values); cmd.ExecuteNonQuery(); con.Close(); }

syed ali · Answer

My question is i have one form which has around 50 textboxes and i need to insert those textbox values into my one of the sql database table when the user click on the save button.

syed ali · Answer

protected void Button1_Click(object sender EventArgs e) { int i = 1; while (i <= 50) { con.Open(); string id = TextBox + i; TextBox txtobj = Master.FindControl(id) as TextBox; if(txtobj.Text!=) { string str = insert into devicenumber(DeviceNumber) values (@devicenumber); cmd = new SqlCommand(str con); cmd.Parameters.AddWithValue(@devicenumber TextBox1.Text); cmd.ExecuteNonQuery(); } else { Response.Redirect(Devicenumber.aspx); } i++; con.Close(); } } } sir please see my code

Pankaj Kumar Choudhary · Answer

hello @Syed if you want to insert insert multiple textbox values on button click event in a single cloumn then you can create a string that hold all textbox value with comma seprated. then use a stored procedure in database that seprate all these value and insert each value into column separately

Sivaraman Dhamodaran · Answer

1) Collect the values from the text boxes and Append the values like: string OneColumn = Textbox1.text + Textbox2.text + .... + textboxN.text 2) Then insert the above OnEColumn String value to the database

Saroj Kumar Sahu · Answer

Hi Ali Can you please elaborate your question clearly means in which format you want the data in that column ? If you want all these vaue in one column without any separator/delimeter then Collect all the textboxes values into one string and update this into database column. find the sample in below link http://forums.asp.net/t/1818735.aspx?using+foreach+loop+how+to+insert+multiple+textbox+values+into+sql+database+in+asp+net