I have a standard .NET Datagrid (Databound to a SQL Dataset), and I need to
select all rows of the datagrid when a button is clicked, to allow a user to
copy the data, and then paste it into Excel or another application. They
need to be able to do this because the application is running on a Terminal
Server in Application Server Mode, and they need to copy the data to an
Excel worksheet on their local computer.
I can do this manually by Clicking on the first row, and then scrolling
through the Datagrid and Shift-Clicking the last row, then using Ctrl-C and
Ctrl-V to copy and paste. But the Datagrid is very large (5-10,000 rows),
and it takes an unacceptable amount of time for the users to scroll through
the entire Datagrid to Shift-Click the last row.
Does anyone have any suggestions on how to do this?
Thanks