To set the web.config file, perform following steps:

1. Inside Solution Explorer select the web.config file and double-click it. Web.config file will open.
2. Locate the connectionStrings section and replace it with following <connectionStrings> <remove name="LocalSqlServer"/> <add name="AdventureWorksConnectionString" connectionString="Data Source=localhost;Initial Catalog=AdventureWorks;Integrated Security=True"/> </connectionStrings>
3. Locate the compilation section and replace it with following <compilation debug="true"> <assemblies> <add assembly="System.Security, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/> <!-- next setting is required to reference the GEET dll installed in the Global Assembly Cache --> <add assembly="GEETMultiSheet, Version=1.3.2.0, Culture=neutral, PublicKeyToken=67ad70e900207353"/> </assemblies> </compilation>
4. Save and close the web.config file.

Inside the Solution Explorer double-click the default.aspx page.

1. Select the Page Properties and set the "ASYNC" property to true. This property must be set to true to allow the Gridview to Excel Export Tool to send mail asynchronously. This feature won't be used in this walkthrough.
2. Insert a Sqldatasource into the default.aspx page.
3. Configure the sqldatasource this way:
   1. Select the sqldatasource
   2. Press F4 to open the properties window
   3. Select (Expressions) and click the three dotted button
   4. In the "bindable properties" box, select the "Connectionstring" property
   5. Select ConnectionStrings in the "expression type" dropdown list
   6. Select "AdventureWorksConnectionString" from the "Connection Name" dropdown list
      
   7. Press Ok
   8. in the Sqldatasource property window select the "SelectQuery" property and click the three dotted button
   9. in the SELECT command box paste the following query:
      SELECT * FROM Production.Product
   10. Press "Query Builder" to Open the Query Builder
   11. Press "Execute Query" to run the query and preview results
   12. Press Ok. The window should be similar to the following
       
   13. Press Ok
4. Insert a Gridview into the default.aspx
   1. Press "choose Data source" from the Gridview tag.
   2. Select "SqlDatasource1" from the dropdown list.
   3. Select "Edit columns" from the Gridview tag
   4. Uncheck "auto-generate fields"
   5. Press "Refresh Schema"
   6. From "Available Fields" box Select and Add following "databound" fields
      • ProductID
      • Name
      • ProductNumber
      • SafetyStockLevel
      • StandardCost
      • SellStartDate
      • ModifiedDate
   7. Select the "StandardCost" field inside the "available field" box
   8. In the Boundfield Properties set the DataFormatString to "{0:#,##0.00}"
      
   9. Select the "SafetyStockLevel" field inside the "available field" box
   10. In the Boundfield Properties set the DataFormatString property to "{0:#,##0}"
   11. In the Boundfield Properties set the HeaderText property to "Safety Stock Level"
   12. Select the ProductNumber in the "Selected fields" box; then set its HeaderText property to "Product Code"
   13. Press Ok.
   14. Enable Paging for the Gridview by checking the Enable Paging checkbox in the Gridview Task window
5. Insert a Button
6. Verify that its ID property is "Button1"
7. Set the "Text" property of the button to "Export to Excel 2003"
8. Double click Button1.The Code Editor will open.
   Copy following text and past it at the first line of the code page.
   Imports GEETMultiSheet Inside the Button1_click sub, insert following text
   ' with next two lines you will export data from your sqldatasource and gridview to Excel 2003 Dim G2003 As New GEETEasyResponse2003(Me.User.Identity.Name, Me.Page, "My Product table to Excel 2003", Me.SqlDataSource1, Me.GridView1) G2003.Execute()
9. Create a new Sub inside the code page using next code:
   Public Overrides Sub VerifyRenderingInServerForm(ByVal control As System.Web.UI.Control) 'MyBase.VerifyRenderingInServerForm(control) End Sub
10. Save All
11. Press Ctrl-F5 to run the web site. The web application will run and Internet Explorer will show following window:
    
12. Press the "Export to Excel 2003" Button. Next window will popup:
    
13. Press "Open" to open the Excel sheet and following Excel sheet will display:
    

Here we'll demonstrate how you can add the capability to export data to Excel 2007 by a few actions and adding two lines of code.

Inside the Solution Explorer double-click the default.aspx page.

1. To the default.aspx pagge add a new Button
2. Verify that its ID property is "Button2"
3. Set the "Text" property of the button to "Export to Excel 2007"
4. Double click Button2.The Code Editor will open.
   Inside the Button2_click sub, insert following text
   ' with next two lines you will export data from your sqldatasource and gridview to Excel 2007 Dim G2007 As New GEETEasyResponse2007(Me.User.Identity.Name, Me.Page, "My Product table to Excel 2007", Me.SqlDataSource1, Me.GridView1) G2007.Execute()
5. Save All
6. Press Ctrl-F5 to run the web site.The web application will run and Internet Explorer will show following window:
   
7. Press the "Export to Excel 2007" Button. Next window will popup:
   
8. Press "Open" to open the Excel sheet and following Excel 2007 (xlsx) sheet will display: