Al Pascual ASP.NET Blog - All Comments

re: How to fix Sys.WebForms.PageRequestManagerParserErrorException in AJAX 1.0

pdm2 — Sat, 07 Nov 2009 22:12:04 GMT

Adding a trigger to the update panel outside the contenttemplate fixed my exel download from a button within the panel!

Thanks to Jonny Coder!

johnnycoder.com/.../export-gridview-to-excel-within-an-updatepanel

...

</ContentTemplate>

<asp:PostBackTrigger ControlID="btnExport" />

</Triggers>

</asp:UpdatePanel>

...

re: How to fix Sys.WebForms.PageRequestManagerParserErrorException in AJAX 1.0

pdm2 — Sat, 07 Nov 2009 21:22:30 GMT

Ususally I'm able to convert a SqlDataSource to a DataView to bind to a new Gridview use Response.Write to send the Excel file to the user using StringWriter, triggered by an asp:button. Trying from a button in the UpdatePanel is not working even with enableEventValidation="false" and I still don't see how to do this after reading this whole thread and posts, that is without trying to decrypting the blob of data AJAX receives from the server.

Any tricks for me, or do I have to give up and move the button outside the update panel even though I don't want to in the layout?

~~~~~~~~

'VB Sub

Protected Sub btnDownload_Click(ByVal sender As Object, ByVal e As System.EventArgs)

Dim sbFile as string = Now.ToString("yyyy-MM-dd").ToString( + ".xls"))

Dim dv As DataView = mySqlDataSource.Select(DataSourceSelectArguments.Empty)

DataViewToExcel(dv, sbFile.ToString)

End Sub

//C# Class void

public static void DataViewToExcel(DataView dv, string filename)

{

//Convert SqlDataSource to DataView then export to excel for raw data without GridView formatting.

if (dv.Count > 0)

{

if (dv.Count < 65536)

{

//VerifyRenderingInServerForm(gv);

HttpContext.Current.Response.Clear();

HttpContext.Current.Response.ContentEncoding = Encoding.GetEncoding("ISO-8859-1");

HttpContext.Current.Response.Charset = "";

HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + filename.ToString());

System.IO.StringWriter TextWriter = new System.IO.StringWriter();

HttpContext.Current.Response.ContentType = "application/vnd.xls";

System.IO.StringWriter stringwrite = new System.IO.StringWriter();

HtmlTextWriter htmlwrite = new HtmlTextWriter(stringwrite);

GridView gv = new GridView();

gv.DataSource = dv;

gv.AllowPaging = false;

gv.AllowSorting = false;

gv.DataBind();

gv.RenderControl(htmlwrite);

HttpContext.Current.Response.Write(stringwrite.ToString());

HttpContext.Current.Response.End();

}

else

{

//Msg.Text = "Too many rows - Export to Excel not possible";

}

Migrating Graffiti CMS from VistaDB to SQL Server

DamianM — Mon, 26 Oct 2009 11:39:07 GMT

I’ve been running this site on of Graffiti CMS for a while now. Graffiti seemed like such a good product, it’s a shame Telligent seem have to abandoned it without any communication. Anyway, after a long hiatus I started to actually use it

re: Adding GeoRSS to GeoTwitter

Daddy56 — Thu, 22 Oct 2009 22:26:57 GMT

But to claim we are completely neutral is perhaps to be naïve about the human condition. ,

Baby names meanings are important when choosing a name

Baby names meanings are important when choosing a name — Thu, 22 Oct 2009 13:36:28 GMT

Pingback from Baby names meanings are important when choosing a name

re: How to fix Sys.WebForms.PageRequestManagerParserErrorException in AJAX 1.0

r4 nds — Tue, 13 Oct 2009 06:07:01 GMT

I tried your solution.....dint worked for me.....any other possibility?

re: How to fix Sys.WebForms.PageRequestManagerParserErrorException in AJAX 1.0

Chetan — Thu, 08 Oct 2009 09:12:13 GMT

when search network is not found then generate this error in browser.

re: Dealing with Silverlight and SSL and without SSL

ds r4 — Sat, 03 Oct 2009 05:47:24 GMT

Thanx for the information. If i want to use SSL for silverlight, does that mean that I would have to need a certification from the server I want to connect.

re: How to create an Http Handle to re write the URL

vinay — Tue, 29 Sep 2009 15:58:34 GMT

i want to creat my url address for creat my blog. how to creat i to this.

Baby name meaning and origin for Pascual

Baby name meaning and origin for Pascual — Sun, 27 Sep 2009 03:36:53 GMT

Pingback from Baby name meaning and origin for Pascual