www.grise.pl
grise egTracker egSearch egLinks egSamples egPortfolio egContact
egSample - Export CSV

Export data to CSV file - Online Demo

Export.ashx
using System;
using System.Web;
using System.IO;
using System.Text;
using System.Globalization;

public class ExportCSV_demo : IHttpHandler 
{
        
    public void ProcessRequest (HttpContext context) 
    {
      context.Response.Clear();
      context.Response.ClearHeaders();
      context.Response.CacheControl = "public";
      context.Response.Cache.SetCacheability(HttpCacheability.Public);

      context.Response.AddHeader("Content-Disposition", "attachment; filename=sample.csv");
      context.Response.ContentType = "application/vnd.ms-excel";

      Stream stream = context.Response.OutputStream;
      Encoding encoding = context.Response.ContentEncoding;
      CultureInfo cultureInfo = (CultureInfo)System.Globalization.CultureInfo.InvariantCulture.Clone();
            
      using (StreamWriter writer = new StreamWriter(stream, encoding))
      {
        writer.WriteLine("\"Date\",\"Year\",\"Month\",\"Day\"");
        DateTime Date = DateTime.Now;                
        for (Int32 i = 0; i <= 5; i++)
        {
          Date = Date.AddDays(1);
          writer.WriteLine("\"{0}\",\"{1}\",\"{2}\",\"{3}\"", Date.ToString(cultureInfo),
            Date.Year.ToString(), Date.Month.ToString(), Date.Day.ToString());
        }
      }
            
      context.Response.End();      
    }
 
    public bool IsReusable 
    {
        get {
            return false;
        }
    }
}
grise egTracker egSearch egLinks egSamples egPortfolio egContact
© 2006-2012 grise.pl