protected void loadRecordToCSV() { String DataFilePath = HttpContext.Current.Server.MapPath("~/App_Data/GroupSeat.csv"); String CSVdata = ""; CSVdata += ","; CSVdata += "FLIGHT NO,"; CSVdata += "DEPART DATE,"; CSVdata += "SECTORS,"; CSVdata += "NO OF PAX BOOKED,"; CSVdata += "STAFF NAME,"; CSVdata += "DEPOSIT AMOUNT,"; CSVdata += "SUBMITTED/r/n"; try { System.IO.StreamReader sr = new System.IO.StreamReader(DataFilePath); int i = 0; Decimal DepsTot = 0; while (!sr.EndOfStream) { String record = sr.ReadLine(); //Response.Write(record+"<br>/r/n"); if (record != null && record != "") { String[] records = record.Split(','); Decimal Deposit = System.Convert.ToDecimal(records[5]); DateTime updateDate = System.Convert.ToDateTime(records[7]); if (updateDate < RetFrom || updateDate > RetTo.AddDays(1)) { continue; } i++; DepsTot += Deposit; CSVdata += i + ","; CSVdata += records[0] + ","; CSVdata += records[1] + ","; CSVdata += records[2] + ","; CSVdata += records[3] + ","; CSVdata += records[4] + ","; CSVdata += Deposit.ToString("S$0.00") + ","; CSVdata += updateDate.ToString("ddMMMyyyy") + "/r/n"; } } sr.Close(); } catch { return; } //sent export data string temp = string.Format("attachment;filename={0}", "GroupSeats_" + RetFrom.ToString("ddMMMyyyy") + "_" +RetTo.ToString("ddMMMyyyy") + ".csv"); Response.ClearHeaders(); Response.AppendHeader("Content-disposition", temp); Response.Write(CSVdata); Response.End(); }