vb.net - Grdview to excel and save so dialog box does not show -
i have following code. creates , saves excel file content in grdview4 great. @ end of application displays disalog box not want. there anyways dialog box not show?
response.contentencoding = system.text.encoding.unicode response.contenttype = "application/vnd.ms-excel" ' response.addheader("content-disposition", "attachment;filename=""c:\echobacs\rejectedbacsbacs\rejectedbacs" & newdate & ".xls") ' response.transmitfile("c:\rejectedbacs" & newdate & ".xls") response.charset = "" me.enableviewstate = false dim ostringwriter new system.io.stringwriter dim ohtmltextwriter new system.web.ui.htmltextwriter(ostringwriter) gridview4.headerrow.style.add("background-color", "#ffffff") gridview4.rendercontrol(ohtmltextwriter) dim helpme string = ostringwriter.tostring() ' response.write(ostringwriter.tostring()) ' httpcontext.current.response.end() file.writealltext("c:\echobacs\rejectedbacs\rejectedbacs" & newdate & ".xls", helpme) ohtmltextwriter.close()
do not use response in case, ask save dialog box. if want save file disk without prompt this. giving in c#
system.web.ui.webcontrols.datagrid grid = new system.web.ui.webcontrols.datagrid(); grid.headerstyle.font.bold = true; grid.datasource = datatable; grid.datamember = datatable.tablename; grid.databind(); using(streamwriter sw = new streamwriter ("d:\\temp\test.xls")) { using (htmltextwriter hw = new htmltextwriter(sw)) { grid.rendercontrol(hw); } }
Comments
Post a Comment