how to insert multiple textbox values on button click event

syed ali

11y6.9kVisual Basic .NET

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

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Upendra Pratap Shahi11y ago
Kindly go through this link-

http://stackoverflow.com/questions/22591756/get-values-from-dynamically-added-textboxes-asp-net-c-sharp
0
Rajeesh Menoth11y ago
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 <= 5; 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 (Column1,Column2) 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();
}
}
0
Saroj Kumar Sahu11y ago
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 <= 50)
{
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
0
Inathi Gqola11y ago
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.
0
Sivaraman Dhamodaran11y ago
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 <= 50)
{
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();
}
0
syed ali11y ago
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.
0
syed ali11y ago
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
0
Pankaj Kumar Choudhary11y ago
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
0
Sivaraman Dhamodaran11y ago
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
0
Saroj Kumar Sahu11y ago
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
0