private void GetOrders(string OrderNO) { DailyOrdersDAL ONSODAL = new DailyOrdersDAL(); ONSODAL.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString(); List <DailyOrders> ClientInvoiceList = ONSODAL.GetOrders(OrderNO); gvDailyorders.DataSource = ClientInvoiceList; gvDailyorders.DataBind(); }
protected void BtnExport_Click(object sender, EventArgs e) { DailyOrdersDAL ONSODAL = new DailyOrdersDAL(); ONSODAL.ConnectionString = ConfigurationManager.ConnectionStrings["MySQLConn"].ToString(); List <DailyOrders> DailyOredsList = ONSODAL.GetOrders(null); var mem = new MemoryStream(); var writer = new StreamWriter(mem, Encoding.UTF8, 1024, true); var csvWriter = new CsvWriter(writer); csvWriter.Configuration.Delimiter = ","; csvWriter.WriteField("ID"); csvWriter.WriteField("PIN"); csvWriter.WriteField("EmployeeID"); csvWriter.WriteField("FirstName"); csvWriter.WriteField("LastName"); csvWriter.WriteField("CatalogName"); csvWriter.WriteField("Quantity"); csvWriter.WriteField("OrderDate"); csvWriter.WriteField("P2MOrderNumber"); csvWriter.WriteField("GRSOrderNum"); csvWriter.WriteField("ItemNumber"); csvWriter.WriteField("JobTitle"); csvWriter.WriteField("OrderStatus"); csvWriter.WriteField("ProductCost"); csvWriter.WriteField("RewardName"); csvWriter.NextRecord(); int lenght = DailyOredsList.Count - 1; for (int i = 0; i <= lenght; i++) { csvWriter.WriteField(DailyOredsList[i].ID); csvWriter.WriteField(DailyOredsList[i].PIN); csvWriter.WriteField(DailyOredsList[i].EmployeeID); csvWriter.WriteField(DailyOredsList[i].FirstName); csvWriter.WriteField(DailyOredsList[i].LastName); csvWriter.WriteField(DailyOredsList[i].CatalogName); csvWriter.WriteField(DailyOredsList[i].Quantity); csvWriter.WriteField(DailyOredsList[i].OrderDate); csvWriter.WriteField(DailyOredsList[i].P2MOrderNumber); csvWriter.WriteField(DailyOredsList[i].GRSOrderNum); csvWriter.WriteField(DailyOredsList[i].PartnerSystemOrderNum); csvWriter.WriteField(DailyOredsList[i].ItemNumber); csvWriter.WriteField(DailyOredsList[i].JobTitle); csvWriter.WriteField(DailyOredsList[i].OrderStatus); csvWriter.WriteField(DailyOredsList[i].ProductCost); csvWriter.WriteField(DailyOredsList[i].RewardName); csvWriter.NextRecord(); } writer.Flush(); var data = Encoding.UTF8.GetString(mem.ToArray()); Response.Clear(); Response.AddHeader("content-disposition", "attachment; filename=DailyOrders.csv"); Response.Charset = ""; Response.ContentType = "text/csv"; Response.Write(data.ToString()); Response.End(); }