title: saving dataset in excel and allow user to download it in the client machine
body: <p>I am developing an application where i want i am displaying a dataset in the datagrid view for the user.Now the user wants to download the data in the datagridview in an excel format.How can i do it ?</p>
  
  <p>1) should i write the dataset in the excel and save it the server before the user download the file ?</p>
  
  <p>2) Can i use a hyper link and set the path of the file that is saved in the server to the hyper link hRef property , so that the user can click and download the file ?</p>
  
  <p>I am using C# ASP.net 2.0</p>
  
  <p>Please help !</p>