how to store copy of Email in database using SQL ServerC#A

Question

Hi
I have created web application with sending emails from asp.net,c#.
I want to store the copy of the email(sender,receiver,content) in database SQL table for future reference.
Rerieve the email from the database SQL table with the same content and line spaces,commas,semicolon ,that was sent from asp.net,c#.
Rerieved content can be displayed in PDF or some other file type.
Please any solution is appreciated.
Thanks and Regards
Ramachandran.

Bikesh Srivastava · Answer

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

Manas Mohapatra · Answer

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.

Milan Prajapati · Answer

Hi You can create table Sent like below: CREATE TABLE [dbo].[Sent]( [Id] [int] IDENTITY(11) 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.

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