Tuesday, June 7, 2016

How to export DataTable To .CSV file in ASP.NET C#

To Export DataTable to .CSV file in ASP.NET C# use below function

private void DataTableToCSV(DataTable dt) 
        { 
            string filename = Server.MapPath("~/download.csv"); 
            StreamWriter sw = new StreamWriter(filename, false); 
            int iColCount = dt.Columns.Count; 
            for (int i = 0; i < iColCount; i++) 
            { 
                sw.Write(dt.Columns[i]); 
                if (i < iColCount - 1) 
                { 
                    sw.Write(","); 
                } 
            } 
            sw.Write(sw.NewLine); 
            foreach (DataRow dr in dt.Rows) 
            { 
                for (int i = 0; i < iColCount; i++) 
                { 
                    if (!Convert.IsDBNull(dr[i])) 
                    { 
                        sw.Write(dr[i].ToString()); 
                    } 
                    if (i < iColCount - 1) 
                    { 
                        sw.Write(","); 
                    } 
                } 
                sw.Write(sw.NewLine); 
            } 
            sw.Close(); 
            Response.Clear(); 
            Response.ContentType = "application/csv"; 
            Response.AddHeader("Content-Disposition", "attachment; filename=download.csv"); 
            Response.WriteFile(filename); 
            Response.Flush(); 
            Response.End(); 
        }

No comments:

Post a Comment