GridView to excel after create send mail c#

Posted by Diego Bran on Stack Overflow See other posts from Stack Overflow or by Diego Bran
Published on 2012-11-16T16:43:04Z Indexed on 2012/11/16 16:59 UTC
Read the original article Hit count: 194

Filed under:
|
|
|

I want to send a .xlsx , first I created (It has html code in it) then I used a SMTP server to send it , it does attach the file but when I tried to open it " It says that the file is corrupted etc" any help?

Here is my code

    try
            {

            System.IO.StringWriter sw = new System.IO.StringWriter();
            System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);

            // Render grid view control.
            gvStock.RenderControl(htw);

            // Write the rendered content to a file.
            string renderedGridView = sw.ToString();
            File.WriteAllText(@"C:\test\ExportedFile.xls", renderedGridView);

           // File.WriteAllText(@"C:\test\ExportedFile.xls", p1);
            }
            catch (Exception e) 
            {
            Response.Write(e.Message);
            }


            try
            {
            MailMessage mail = new MailMessage();
            SmtpClient SmtpServer = new SmtpClient("server");
            mail.From = new MailAddress("[email protected]");
            mail.To.Add("[email protected]");
            mail.Subject = "Test Mail - 1";
            mail.Body = "mail with attachment";



            Attachment data = new Attachment("C:/test/ExportedFile.xls");
            mail.Attachments.Add(data);

            SmtpServer.Port = 25;
            SmtpServer.Credentials = new System.Net.NetworkCredential("user", "pass");
          //  SmtpServer.EnableSsl = true;
            SmtpServer.UseDefaultCredentials = false;
            SmtpServer.Send(mail);
            }
            catch( Exception e) 
            {
            Response.Write(e.Message);
            }

© Stack Overflow or respective owner

Related posts about c#

Related posts about excel