Monthly payments
Question
Answers
All replies
-
User-893317190 posted
Hi peterV,
You could use checkbox to let your friend choose and when he click the export button , you could choose the selected row , export these rows and save the result in database.
Below is my code.Please don't forget to add EnableEventValidation = "false" or the user can't export excel.
<%@ Page Language="C#" EnableEventValidation = "false" AutoEventWireup="true" CodeBehind="FitnessCenter.aspx.cs" Inherits="MyWebFormCases.gridView2.FitnessCenter" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> </head> <body> <form id="form1" runat="server"> <asp:GridView ID="GridView1" runat="server" DataKeyNames="id" AutoGenerateColumns="false"> <Columns> <asp:BoundField DataField="id" HeaderText="id" /> <asp:BoundField DataField="selectDate" HeaderText="date" /> <asp:CheckBoxField DataField="isAuto" HeaderText="isAuto" /> <asp:BoundField DataField="name" HeaderText="name" /> <asp:TemplateField HeaderText="isExported"> <ItemTemplate> <asp:CheckBox runat="server" ID="box" Checked='<%# Eval("isExported") %>'></asp:CheckBox> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView> <asp:Button ID="Button1" runat="server" Text="Export" OnClick="Button1_Click" /> <asp:Button ID="Button2" runat="server" Text="Refresh" OnClick="Button2_Click" /> </form> </body>Code behind. I use entity framework. It also uses linq. And you could choose other ways to export excel. For example , you could use EPPlus.
UserItemDb dbContext = new UserItemDb(); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //select records in this month of this year (and other conditions) GridView1.DataSource= dbContext.FitnessCenters.Where(c => c.isAuto && !c.isExported && c.selectDate.Month == DateTime.Now.Month && c.selectDate.Year == DateTime.Now.Year).ToList(); GridView1.DataBind(); } } protected void Button1_Click(object sender, EventArgs e) { Response.Clear(); Response.Buffer = true; Response.AddHeader("content-disposition", "attachment;filename="+DateTime.Now.ToString()+".xls"); Response.Charset = ""; Response.ContentType = "application/vnd.ms-excel"; StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); List<int> list = new List<int>(); foreach (GridViewRow row in GridView1.Rows) { if (row.RowType == DataControlRowType.DataRow) { //select the checked checkbox if ((row.FindControl("box") as CheckBox).Checked) { //record id of the row list.Add(Convert.ToInt32(row.Cells[0].Text)); int id= Convert.ToInt32(row.Cells[0].Text); //change the isExported to true dbContext.FitnessCenters.Where(c => c.id == id).First().isExported = true; } } } //save changes to database dbContext.SaveChanges(); // bind the selected row to the gridview to export them GridView1.DataSource = dbContext.FitnessCenters.Where(C => list.Contains(C.id)).ToList(); GridView1.DataBind(); GridView1.AllowPaging = false; for (int i = 0; i < GridView1.Rows.Count; i++) { GridViewRow row = GridView1.Rows[i]; row.Attributes.Add("class", "textmode"); } GridView1.RenderControl(hw); string style = @"<style> .textmode { mso-number-format:\@; } </style>"; Response.Write(style); Response.Output.Write(sw.ToString()); Response.Flush(); Response.End(); } //don't forget this , or the user can't export public override void VerifyRenderingInServerForm(Control control) { } protected void Button2_Click(object sender, EventArgs e) { GridView1.DataSource = dbContext.FitnessCenters.Where(c => c.isAuto && !c.isExported && c.selectDate.Month == DateTime.Now.Month && c.selectDate.Year == DateTime.Now.Year).ToList(); GridView1.DataBind(); }The result.
Best regards,
Ackerly Xu
