Databases
StackOverflow2013
Postsdbo
POExport to Excel stopped working when I added an AJAX panel
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POExport to Excel stopped working when I added an AJAX panel
    primarykey
    data
    text
    <p>I am just starting to learn how to use Ajax and I am stuck on this. </p> <p>I have buttons in my ASP.net web site that work perfectly but the export to Excel and export to CSV stopped working after I added an Ajax panel.</p> <p>They worked before I added the panel and when I debug the function <code>To_Excel_Click</code> is called is processed but it just does not create the Excel file. Something in Ajax I think is preventing the file to be created.</p> <p>Thank you for any help </p> <p>HTML Ajax</p> <pre><code>&lt;asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent"&gt; &lt;asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional"&gt; &lt;contenttemplate&gt; &lt;asp:Button ID="BT1" runat="server" Text="Submit" Visible="false" onclick="BT1"/&gt; &lt;asp:Button ID="BT2" runat="server" Text="Submit" Visible="false" onclick="BT2" /&gt; &lt;asp:Button ID="BTMakeCVS" runat="server" Text="Submit to CVS" Visible="false" onclick="BTMakeCVS_Click" /&gt; &lt;asp:Button ID="To_Excel" runat="server" Text="To Excel" onclick="To_Excel_Click" Visible="false" AutoPostBack="True"/&gt; &lt;/fieldset&gt;&lt;fieldset class="Matainancefieldset3"&gt; &lt;asp:GridView ID="GVData" runat="server" Visible="false"&gt; &lt;RowStyle CssClass="Row" /&gt; &lt;AlternatingRowStyle CssClass="AltRow" /&gt; &lt;PagerTemplate&gt;&lt;table&gt;&lt;tr&gt;&lt;td&gt; &lt;asp:PlaceHolder ID="ph" runat="server"&gt; &lt;/asp:PlaceHolder&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt; &lt;/PagerTemplate&gt; &lt;/asp:GridView&gt; &lt;asp:Label ID="LBExcell" runat="server" Text="Model:" Visible="false"&gt;&lt;/asp:Label&gt; &lt;/contenttemplate&gt; &lt;/asp:UpdatePanel&gt; &lt;/asp:Content&gt; </code></pre> <p>C#</p> <pre><code>protected void To_Excel_Click(object sender, EventArgs e) { ExcelExport.Export("Summary.xls", GVData); } public class ExcelExport { public static void Export(string fileName, GridView gv) { HttpContext.Current.Response.Clear(); HttpContext.Current.Response.AddHeader( "content-disposition", string.Format("attachment;filename={0}", fileName)); HttpContext.Current.Response.ContentType = "application/ms-excel"; using (StringWriter sw = new StringWriter()) { using (HtmlTextWriter htw = new HtmlTextWriter(sw)) { Table table = new Table(); table.GridLines = gv.GridLines; if (gv.HeaderRow != null) { ExcelExport.PrepareControlForExport(gv.HeaderRow); table.Rows.Add(gv.HeaderRow); } foreach (GridViewRow row in gv.Rows) { ExcelExport.PrepareControlForExport(row); table.Rows.Add(row); } if (gv.FooterRow != null) { ExcelExport.PrepareControlForExport(gv.FooterRow); table.Rows.Add(gv.FooterRow); } table.RenderControl(htw); HttpContext.Current.Response.Write(sw.ToString()); HttpContext.Current.Response.End(); } } } private static void PrepareControlForExport(Control control) { for (int i = 0; i &lt; control.Controls.Count; i++) { Control current = control.Controls[i]; if (current is LinkButton) { control.Controls.Remove(current); control.Controls.AddAt(i, new LiteralControl((current as LinkButton).Text)); } else if (current is ImageButton) { control.Controls.Remove(current); control.Controls.AddAt(i, new LiteralControl((current as ImageButton).AlternateText)); } else if (current is HyperLink) { control.Controls.Remove(current); control.Controls.AddAt(i, new LiteralControl((current as HyperLink).Text)); } else if (current is DropDownList) { control.Controls.Remove(current); control.Controls.AddAt(i, new LiteralControl((current as DropDownList).SelectedItem.Text)); } else if (current is CheckBox) { control.Controls.Remove(current); control.Controls.AddAt(i, new LiteralControl((current as CheckBox).Checked ? "True" : "False")); } if (current.HasControls()) { ExcelExport.PrepareControlForExport(current); } } } } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USmarc_s
    1. USuser2615302
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COTo add to the answer already given my Garrison... the `UpdatePanel` effectively uses the browser AJAX ability to request HTML updates from the server, and the the browser displays that HTML. What you're effectively asking the server to do is return an Excel document as HTML to be displayed within the browser, which isn't going to work. As he says, keep it outside of the panel and it will work
      singulars
      1. POExport to Excel stopped working when I added an AJAX panel
      1. USfreefaller
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload