krallabandi@gmail.com wrote:
> any ideas on this problem pls?
>
> Thanks
>
> krallabandi@gmail.com wrote:
> > Hi,
> >
> > I am using Response object in vb.net to download an excel sheet with
> > data.
> > It worked well and I could download excel file with data. But suddenly
> > It started downloading only blank excel sheet. even though the data
> > exists. Do I need to do any refreshing? or do I need to re-start IIS?
> >
> >
> > Dim dt As DataTable = DSCAG.Tables(0)
> >
> > Dim strFileName As String = "Downloadfile.xls"
> > Response.Clear()
> > Response.Buffer = True
> > Response.ContentType = "application/vnd.ms-excel"
> > Response.AddHeader("Content-Disposition", "attachment;
> > filename=""" & strFileName & """")
> > Response.ContentEncoding = System.Text.Encoding.UTF7
> > Response.Charset = ""
> > EnableViewState = False
> > Dim oStringWriter As New System.IO.StringWriter
> > Dim oHTMLTextWriter As New
> > System.Web.UI.HtmlTextWriter(oStringWriter)
> >
> > DGCAGReference.DataSource = dt
> > DGCAGReference.DataBind()
> >
> > DGCAGReference.RenderControl(oHTMLTextWriter)
> >
> > Dim strResponse As String = oStringWriter.ToString
> > strResponse = strResponse.Replace("</td>", "&nbsp;</td>")
> > Response.Write(strResponse)
> >
> > Thanks.