HTML
<asp:TextBox ID="txtValue" Text="1 Ali,sara,ahmed" runat="server" />
<asp:Button Text="Save" OnClick="Save" runat="server" />
C#
protected void Save(object sender, EventArgs e)
{
string[] data = this.txtValue.Text.Trim().Split(',');
string id = data[0].Split(' ')[0];
string name = string.Empty;
for (int i = 0; i < data.Length; i++)
{
name = i == 0 ? data[i].Split(' ')[1] : data[i];
this.SaveData(id, name);
}
}
//This code will be repeated till all the data[i] values inserted
private void SaveData(string id, string name)
{
string constr = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
string sqlStatment = "INSERT INTO TABLE1 VALUES(@Pid,@Keyword)";
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand(sqlStatment, con))
{
cmd.Parameters.AddWithValue("@Pid", id);
cmd.Parameters.AddWithValue("@Keyword", name);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
VB.Net
Protected Sub Save(sender As Object, e As EventArgs) Handles Button1.Click
Dim data As String() = Me.txtValue.Text.Trim().Split(","c)
Dim id As String = data(0).Split(" "c)(0)
Dim name As String = String.Empty
For i As Integer = 0 To data.Length - 1
name = If(i = 0, data(i).Split(" "c)(1), data(i))
Me.SaveData(id, name)
Next
End Sub
'This code will be repeated till all the data[i] values inserted
Private Sub SaveData(id As String, name As String)
Dim constr As String = ConfigurationManager.ConnectionStrings("conString").ConnectionString
Dim sqlStatment As String = "INSERT INTO TABLE1 VALUES(@Pid,@Keyword)"
Using con As New SqlConnection(constr)
Using cmd As New SqlCommand(sqlStatment, con)
cmd.Parameters.AddWithValue("@Pid", id)
cmd.Parameters.AddWithValue("@Keyword", name)
con.Open()
cmd.ExecuteNonQuery()
con.Close()
End Using
End Using
End Sub