My data of gridview is exporting to excel sheet but it is exporting extra buttons in that page also and also exporting the navigation links that i have used in the master page Below is my code ltaspContent ID34Content234 ContentPlaceHolderID34ContentPlaceHolder134 Runat34Server34gt ltcc2ToolkitScriptManager ID34ToolkitScriptManager134 runat34server34 gt ltcc2ToolkitScriptManagergt ltaspUpdatePanel ID34UpdatePanel134 runat34s

i have done minor change and now things are working fineUse ResponseEnd instead of HttpContextCurrentApplicationInstanceCompleteRequestprotected void btnExportclickobject sender EventArgs e try ResponseClear ResponseAddHeader34contentdisposition34 34attachmentfilenameiQuizxls34 ResponseCharset 3434 ResponseContentType 34applicationvndxls34 SystemIOStringWriter stringWrite new SystemIOStringWriter SystemWebUIHtmlTextWriter htmlWrite new HtmlTextWriterstringWrite GridView1RenderControlhtmlWrite ResponseWritestringWriteToString ResponseEnd HttpContextCurrentApplicationInstanceCompleteRequest catch Exception ex finally

Additional Page Buttons getting exported along with GridView to Excel in ASP.Net

rohit.so...

SOLVED CLOSED ACTIVE ANSWERED
User: rohit.sood8
Posted: on Nov 25, 2013 11:43 PM
Forum: Data Controls
Answer: 1
Views: 2793

My data of gridview is exporting to excel sheet but it is exporting extra buttons in that page also and also exporting the navigation links that i have used in the master page, Below is my code:
 
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
 
 
 <cc2:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server" > </cc2:ToolkitScriptManager>
  
  <asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional">
   
    <ContentTemplate>
    
 
         <div style="padding-left:20px;line-height:1.5em;";>
              
             <div style="width:100%";>
                <div style="float:left";>
            
                 <asp:TextBox ID="txt_from_date" runat="server" placeholder="search final list" CssClass="input"></asp:TextBox>
                 <cc2:CalendarExtender ID="CalendarExtender1" TargetControlID="txt_from_date" Format="dd MMM yyyy" runat="server"  Enabled="True"
                   PopupButtonID="ImageButton1" >
                   </cc2:CalendarExtender>
                 <asp:ImageButton ID="ImageButton1" runat="server"
                   ImageUrl="../images/Calendar_scheduleHS.png"   CausesValidation="false" />
                 <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="*"
                 ControlToValidate="txt_from_date" ValidationGroup="Group1">
                 </asp:RequiredFieldValidator>
                  
                  
                 <asp:Button ID="btn_search" runat="server" Text="Search !!!" 
                 CssClass="btn-submit-search-final-list" ValidationGroup="Group1"
                        onclick="btn_search_Click"/>
                      
                </div>
                 
               
    <div style="float:right;margin-right:250px";>
     <asp:ImageButton ID="btn_print_list" runat="server" OnClick="PrintCurrentPage" ImageUrl="../images/print.png" AlternateText="Print List"/>&nbsp;&nbsp;&nbsp;
    <%-- <asp:ImageButton ID="btn_export_list_to_excel" runat="server"
            ImageUrl="../images/excel.jpg" AlternateText="Export List to Excel"
            onclick="btn_export_list_to_excel_Click"/>--%>
             
              <asp:Button ID="btnExport" runat="server" Text="Export Grid to ExcelFile" OnClick="btnExport_click" />
    </div>
                 
              </div>
             
             
             <asp:GridView ID="GridView1" runat="server" BackColor="White" text-align="center"
            BorderColor="#336666" BorderStyle="Double" BorderWidth="2px" CellPadding="4"
             Height="50px" Width="1320px" 
            style="text-align:left;line-height:27px; margin-top:70px;
            margin-left:4px;position:absolute;float:left;font-family:Arial;"
            AutoGenerateColumns="false"
             GridLines="Horizontal">
              
              
            <FooterStyle BackColor="White" ForeColor="#333333" />
            <PagerStyle BackColor="#336666" ForeColor="White" HorizontalAlign="Center" />
            <SelectedRowStyle BackColor="#339966" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#336666" Font-Bold="True" ForeColor="White" />
            <RowStyle BackColor="White" ForeColor="#333333" />
         
        <Columns>
        
           <asp:BoundField DataField="student_name" HeaderText="Student Name" ReadOnly="true"/>
           
        </Columns>
    </asp:GridView>
     
               
         </div>
             
    </ContentTemplate>
 
     <Triggers>
        <asp:PostBackTrigger ControlID="btnExport" />
     </Triggers>
 
  </asp:UpdatePanel>
 
</asp:Content>

Download FREE API for Word, Excel and PDF in ASP.Net

rohit.so...

0 4

Reply
ANSWER
User: rohit.sood8
Replied: on Nov 26, 2013 01:56 AM
Report

i have done minor change and now things are working fine.

Use Response.End(); instead of 
HttpContext.Current.ApplicationInstance.CompleteRequest();


protected void btnExport_click(object sender, EventArgs e)
  {
      try
      {
 
          Response.Clear();
          Response.AddHeader("content-disposition", "attachment;filename=iQuiz.xls");
          Response.Charset = "";
          Response.ContentType = "application/vnd.xls";
          System.IO.StringWriter stringWrite = new System.IO.StringWriter();
          System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
          GridView1.RenderControl(htmlWrite);
          Response.Write(stringWrite.ToString());
          Response.End();
         // HttpContext.Current.ApplicationInstance.CompleteRequest();
      }
 
      catch (Exception ex)
      { }
 
      finally
      { }
  }

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Additional Page Buttons getting exported along with GridView to Excel in ASP.Net

Company

Explore

Follow us

Contact Us