Display Data in Gridview and Export To Excel

.NET
1

I have data from multiple tables that I would like to display in a gridview via a stored procedure. I need to select the data based on a date range and display it. Once displayed I need to include a button that would allow the user to export the gridview data to an excel spreadsheet. Does anyone have an out of the box solution or know of a tutorial I can use to accomplish this feat? I am currently using 2.0 for this project. I am newish to .net. Thanks in advance.

Here is my stored procedure that calls the data from multiple tables.


USE [DATABASENAME]
GO
/****** Object:  StoredProcedure [dbo].[GetUsersAll]    Script Date: 09/03/2010 08:20:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[GetUsersAll]
AS
	SELECT          aspnet_Users.UserName, 
					aspnet_Membership.Email, 
					Team.Name, 
					MemberTeamRole.InsertDate,
					MemberTeamRole.ManagerApprovedDate,
					MemberTeamRole.RegistrarApprovedDate,
					MemberTeamRole.RoleName, 
					MemberInfo.firstname, 
					MemberInfo.lastname
					
FROM                     aspnet_Membership INNER JOIN
                         aspnet_Users ON aspnet_Membership.UserId = aspnet_Users.UserId INNER JOIN
                         MemberInfo ON aspnet_Users.UserId = MemberInfo.memberid LEFT OUTER JOIN
                         MemberTeamRole ON aspnet_Membership.UserId =  MemberTeamRole.MemberID LEFT OUTER JOIN
                         Team ON MemberTeamRole.TeamID = Team.TeamID


ORDER BY 
				MemberInfo.firstname, MemberInfo.lastname
						
RETURN
2

Create Stored Procedures for multiple table:
CREATE PROCEDURE spSomeStoredProcedure AS
BEGIN
SELECT CategoryName FROM Categories ORDER BY CategoryName
SELECT Top 10 CompanyName FROM Customers ORDER BY CompanyName
SELECT LastName FROM Employees ORDER BY LastName
SELECT Top 10 ProductName FROM Products ORDER BY ProductName
END
GO

Using SqlDataAdapter.Fill() to access all of your returned tables in ADO.NET:

SqlConnection conn = new SqlConnection(connection);
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand(“exec spSomeStoredProc”, conn);
adapter.Fill(dataset);

For more information follow that link:http://www.codeproject.com/KB/reporting-services/ReportExporters_WinForms.aspx