Referrence:
<asp:Button runat="server" Text="Save email" OnClick="SaveEmails" />
Onclick event:
protected void SaveEmails(object sender, EventArgs e)
{
for (int i = 0; i < this.Emails.Count; i++)
{
string constr = ConfigurationManager.ConnectionStrings["ConString2"].ConnectionString;
string sqlStatment = "INSERT INTO [Emails] ([From],[Subject],[Body],[Date]) VALUES (@From ,@Subject,@Body,@Date)";
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand(sqlStatment, con))
{
con.Open();
cmd.Parameters.AddWithValue("@From", this.Emails[i].From);
cmd.Parameters.AddWithValue("@Subject", this.Emails[i].Subject);
cmd.Parameters.AddWithValue("@Body", this.Emails[i].Body);
cmd.Parameters.AddWithValue("@Date", this.Emails[i].DateSent);
cmd.ExecuteNonQuery();
con.Close();
}
}
}
}
TABLE:
CREATE TABLE [dbo].[Emails](
[From] [varchar](200) NULL,
[Subject] [varchar](100) NULL,
[Date] [datetime] NULL,
[Body] [varchar](max) NULL
) ON [PRIMARY]
GO
Image:
Thank You.