Please refer this
HTML
<asp:TextBox ID="txtMessage" runat="server" TextMode="MultiLine" Rows="5" Columns="20" />
<hr />
<br />
<asp:Button ID="Button1" Text="Save" runat="server" OnClick="Save" />
C#
protected void Save(object sender, EventArgs e)
{
string[] data = txtMessage.Text.Replace(Environment.NewLine, ",").Split(',');
for (int i = 0; i < data.Length; i++)
{
if (!string.IsNullOrEmpty(data[i]))
{
this.SaveData(data[i]);
}
}
}
private void SaveData(string data)
{
// Save the Data in SQL
}