Net-informations.com
SiteMap  | About    

Write content from ASP.NET to Excel

The following program shows how to write the GridView content to an Excel file and save to a desired location.

Here we are using the FileStream class to write the content to a local system.

vb.net

  Dim fStream As New FileStream("c:\data.xls", FileMode.Create)

C#

  FileStream fStream = new FileStream("c:\\data.xls", FileMode.Create);

The following method will confirms that an HtmlForm control is rendered for the specified ASP.NET server control at run time.

vb.net
  Public Overrides Sub VerifyRenderingInServerForm(ByVal control As Control)

End Sub

C#
  public override void VerifyRenderingInServerForm(Control control)
  {

}

Somtimes you will get an exception unless you are not declared the above method in your program the exception shows like :

  

System.Web.HttpException: Control 'GridView1' of type 'GridView' must be placed inside a form tag with runat=server..

Default.aspx

  

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>Untitled Page</title>
</head>
<body>
	<form id="form1" runat="server">
	<div>
	<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1" />
	<asp:SqlDataSource ID="SqlDataSource1" runat="server"
	ConnectionString="<%$ ConnectionStrings:SQLDbConnection %>"
	SelectCommand="select * from stores" />
	</div>
	<asp:Button ID="Button1" runat="server" onclick="Button1_Click"
	Text="Export to Excel" Width="117px" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
	<asp:Label ID="Label1" runat="server" Text="Message : "></asp:Label>
	</form>
</body>
</html>


Click the following links to see full source code

C# Source Code
VB.NET Source Code
default.aspx.cs
default.aspx.vb





net-informations.com (C) 2016    Founded by raps mk
All Rights Reserved. All other trademarks are property of their respective owners.