/// <summary> /// Download Button Click Event /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ButDownload_Click(object sender, EventArgs e) { DataDownloadAdmin csv = new DataDownloadAdmin(); OrderAdmin _OrderAdmin = new OrderAdmin(); string Orderid = Convert.ToString(OrderNumber.Text); DataSet Orders = _OrderAdmin.GetOrdersByOrderId(Orderid); if (Orders.Tables[0].Rows.Count > 0) { //Set Formatted Data from DataSet string strData = csv.Export(Orders, true, tabDelimeter); byte[] data = ASCIIEncoding.ASCII.GetBytes(strData); Response.Clear(); // Set as Excel as the primary format Response.AddHeader("Content-Type", "application/Excel"); Response.AddHeader("Content-Disposition", "attachment;filename=Order.csv"); Response.ContentType = "application/vnd.xls"; Response.BinaryWrite(data); Response.End(); } else { ltrlError.Text = "* No Orders to download"; return; } }