Inserting Multiple Values to Database using Single TextBox with Values Separated with Comma

Vikram
9y
15.6k
0
0

Blog

Front end Code:

Am just created 2 textboxes. In text box 1 we can enter number of values , make sure values should be separated with comma(,). Textbox2 is normal.

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
Name:<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
Number:<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="Button" />
</div>
</form>
</body>
</html>

In the code behind am splitting textbox values and inserting into an array. By using for loop sending values to database.

Create stored procedure in database:

create proc multiple @name varchar(50),@cellnumber int
AS
Begin
insert into people1 (name,cellnumber) values(@Name,@cellnumber);
End

Code Behind

using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
namespace _19_oct_textbox_split
{
public partial class WebForm2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=192.168.3.48;Initial Catalog=vikram;User ID=sa;Password=Atharvana01");
SqlCommand cmd = new SqlCommand("multiple", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
if (TextBox1.Text.Contains(','))//checking for you are entered single value or multiple values
{
string[] arryval = TextBox1.Text.Split(',');//split values with ‘,’
int j = arryval.Length;
int i = 0;
for (i = 0; i < j; i++)
{
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@Name", arryval[i]);
cmd.Parameters.AddWithValue("@cellnumber", TextBox2.Text);
cmd.ExecuteNonQuery();
}
}
else
{
SqlCommand cm = new SqlCommand(String.Format("insert into people1 (name,cellnumber) values('{0}','{1}')", TextBox1.Text,TextBox2.Text), con);
cm.ExecuteNonQuery();
}
}
}
}

I think it is simple to understand.