// Create the CSV file to which dataTable will be exported. StreamWriter sw = new StreamWriter(Server.MapPath("~/Data.csv"), false); // First we will write the headers. DataTable dt = {Get Data From Database}; 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); // Now write all the rows. 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();