Export excel sheet data from dataset in ASP.NET

Environment :
                

ASP.NET 1.1v
Visual C#
SQL Server2000
MS Excel2003
Microsoft Visual Studio2003

1. Create one webapplication using visual studio.
2. Just put the button text as “Exports to Excel” in webform1.aspx.

3.  Use the following namespaces for this application
using System;
using System.Collections;
using System.ComponentModel;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
4. In button(Exports to Excel) click event

SqlConnection conn            =    new SqlConnection(ConfigurationSettings.AppSettings["PubsConnection"]);
                SqlCommand    [...]