<asp:GridView ID="grdBorrowerMaster" runat="server" AllowPaging="True" AutoGenerateColumns="False" CssClass="GridFont1" OnPageIndexChanging="grdBorrowerMaster_PageIndexChanging" OnSelectedIndexChanged="grdBorrowerMaster_SelectedIndexChanged" PageSize="20" Width="500px"> <Columns> <asp:TemplateField HeaderText="Borrower Name" ShowHeader="False"> <ItemTemplate> <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Select" Text='<%# Bind("NameAll") %>'></asp:LinkButton> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Applied Date"> <EditItemTemplate> <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("CurrDate") %>'></asp:TextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Bind("CurrDate","{0:MM/dd/yyyy}") %>'></asp:Label> <asp:Label ID="lblBorrowerId" runat="server" Text='<%# Bind("BorrowerId") %>' Visible="False"></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:BoundField DataField="NameAll" HeaderText="Borrower Name" Visible="False" /> <asp:BoundField DataField="BorkerName" HeaderText="Broker Name" /> <asp:BoundField DataField="STATUS" HeaderText="Status" SortExpression="STATUS" /> <asp:BoundField DataField="Processor" HeaderText="Processor" /> </Columns> </asp:GridView>
protected void butexport_Click1(object sender, EventArgs e) { try { Response.Clear(); Response.AddHeader("content-disposition", "attachment;filename=PipelineReport.xls"); Response.Charset = ""; // If you want the option to open the Excel file without saving than // comment out the line below // Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = "application/vnd.xls"; StringWriter stringWrite = new System.IO.StringWriter(); HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); grdBorrowerMaster .RenderControl (htmlWrite ); Response.Write(stringWrite.ToString()); Response.End(); } catch (Exception ex) { lblError.Visible = true; lblError.Text = ex.Message; } } public override void VerifyRenderingInServerForm(Control control) { //Confirms that an HtmlForm control is rendered for the specified ASP.NET //server control at run time. }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)