Home Browse Net

Browse Topics

	BSD (4)
	DATABASE (11)
	DEVELOPMENT (40)
	LINUX (54)
	NETWORQMEDIA (11)
	OTHER (1)
	PERSONAL (5)
	WINDOWS (37)

Topic Contributors

mreschke

Matthew Reschke

Site Developer

Created: Jul 16th, 2008

Updated: Nov 27th, 2010

Topic Organization

	DEVELOPMENT (40)
	WINDOWS (37)
	.net (14)
	asp.net (7)
	vb.net (11)

Related Topics

ASP.NET Datagrid Date Formatting...

ASP.NET Alternate POST Method

Concat Strings and Variables in ...

ASP.NET DataSet or DataTable to ...

Impersonation in ASP.NET

.NET Listbox

.NET Directory to DataGrid

Loop Datagrid and get Forms

.NET Directory to Dataset

DevExpress ASPxGridView

Recursive File Search or List in...

DeleteOldFiles.vbs

VBScript Basics

VBScript Snippets

Batch File Snippets

Display Table Sizes in MSSQL

Python Tutorial

StartStopProc.vbs

VBScript File List

Windows Powershell

File

Download Selected (zip)

Download Selected (tar.gz)

Edit

Select All

Select None

View

Detail

Detail Preview

Icons

Preview

Show Hidden

Hide Hidden

Full Manager

Reset Defaults

Open In New Tab

Open In New Window

List Archive Contents

Download File

Open

Download Folder (as .zip)

ASP.NET Datagrid to HTML

ASP.NET Datagrid to HTML

Topic #85 by mreschke on 2008-07-16 15:40:08 (viewed 1,025 times)

Export an ASP.NET datagrid to HTML

Export with datagrid Render Control[-][- -][++]

Script Snippet


<%
'Dim stringWriter As System.IO.StringWriter = New System.IO.StringWriter
'Dim htmlWriter As System.Web.UI.HtmlTextWriter = New HtmlTextWriter(stringWriter)

'Must turn off sorting and paging
'Must also disable any custom buttons or links or image buttons in the datagrid, but I don't have any here
grdResults.AllowSorting = False
grdResults.AllowPaging = False

'Refresh the datagrid if it's not already
'The full bind here just gets the data from the database and calls the grid.Databind()
Me.dvResults = Nothing
Me.FullBind(Session("trkDsResults"))

'Render to HTML
grdResults.RenderControl(htmlWriter)

'Turn your stuff back on (and buttons, links... if any)
grdResults.AllowSorting = True
grdResults.AllowPaging = True

'Now stringWriter.ToString is your HTML datagrid output
'Write to a file here, if you want
Dim sWriter As System.IO.StreamWriter
sWriter = System.IO.File.CreateText(System.Configuration.ConfigurationSettings.AppSettings("FilePathABS").Trim & "Tracker/Temp/test.xls")
sWriter.Write(stringWriter.ToString)
sWriter.Close()
%>

Then you could stream the file to their browser with ASP.NET Stream File

networqmedia presents mReschke.com powered by the all new mrcore4