On one of my web pages I'm dynamically creating, building and formatting a datagrid based on a table in an SQL Server 2000 database. The data source for the grid is a dynamically created datatable, populated by a query based on two date selection made by the user on the page. So, I'm happily creating etc. my datagrid, (between 6 & 40 columns dependant on user choice), which allows the user to view the data on-line, but they want to be able to then save this in a CSV format file.
I've looke dthrough the basic File IO type articles and tutorials but there's not really that much detail there. So, basically I want the user to be able to choose the location the file is saved to. Whether it's saved directly to a location of the users choice, or if it's saved on the server, downloaded to the users PC and then deleted from the server doesn't matter as long as they only have to push a button to get a save location dialogue, and choose their save location.
Never having looked at this from Web development or .Net before, how do I go about it???
Rhys Gravell