Using ASP.NET with C# and VS2010, how would you write code on a button click to export over 5,000 records to an Excel 2003 file using Web forms?
Posted on 2013-12-08
I am writing my first ASP.NET application using C# with VS2010 and Web forms.
What code would you write for a button click event to transfer the records from either a Stored Procdure or a GridView to export over 5,000 rows to an Excel 2003 file.
For a field record layout example:
SELECT transferdate, processdate, Bank, Type, Office, CheckNo, RefNo, Description
export to file Clients.xls