Export an ASP.NET datagrid to HTML</div></div></div></div></div></div><h1 class="heading1 " id="toc0">Export with datagrid Render Control<span class="header_toggle"><a href="javascript:toggle_wiki_header('toc0')" id="toc0__link">[-]</a></span><span class="header_collapse"><a href="javascript:toggle_wiki_headers(true);">[--]</a></span><span class="header_expand"><a href="javascript:toggle_wiki_headers(false);">[++]</a></span></h1><div class="header1_content table-bordered" style="display: block" id="toc0__content"><div><div><div><div><div>&lt;codebox vbscript&gt;&lt;%'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 heregrdResults.AllowSorting = FalsegrdResults.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 = NothingMe.FullBind(Session(&quot;trkDsResults&quot;))'Render to HTMLgrdResults.RenderControl(htmlWriter)'Turn your stuff back on (and buttons, links... if any)grdResults.AllowSorting = TruegrdResults.AllowPaging = True'Now stringWriter.ToString is your HTML datagrid output'Write to a file here, if you wantDim sWriter As System.IO.StreamWritersWriter = System.IO.File.CreateText(System.Configuration.ConfigurationSettings.AppSettings(&quot;FilePathABS&quot;).Trim &amp; &quot;Tracker/Temp/test.xls&quot;)sWriter.Write(stringWriter.ToString)sWriter.Close()%&gt;&lt;/codebox&gt;<strong>Then you could stream the file to their browser with <a class="free_link_new" href="/post/create?title=ASP.NET%20Stream%20File">ASP.NET Stream File</a></strong>