how to store copy of Email in database using SQL Server,C#,A

Hi,

 

You can create table Sent like below:

 

CREATE TABLE [dbo].[Sent](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Sender] [nvarchar](100) NULL,
[Receiver] [nvarchar](100) NULL,
[Subject] [nvarchar](500) NULL,
[Content] [nvarchar](max) NULL,
CONSTRAINT [PK_Sent] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] 

 

 

All you need to do is to store your email in the above table and then after you can retrieve the Email data and display as HTML in your page and from that you can create PDF as well usign iTextsharp or evopdf.

Hi,

I think its not any big deal ,you need to just create a table store object value what you are sending in mail. 

You can create table with following columns like:

 

From VARCHAR(500)

To VARCHAR(max)

Subject NVARCHAR(max)

Body NVARCHAR(max)

 

You can use iTextsharp tool to export html content to PDF.