I am trying to export a datagrid to Excel using ASP.NET & C#. I found sample code that shows how to do it, but if the datagrid contains a large amount of data, the app times out right in the middle of the export. Can someone provide suggestions on the best method for doing exports to Excel.

If the app is timing out, there are a couple of things you could try. You could try setting the script timeout to a higher value (in seconds), for example

Server.ScriptTimeout = 500

for up to 10 minutes. You can also do this in the web.config:

<configuration>
   <system.web>
      <httpRuntime maxRequestLength="8096" executionTimeout="500"/>
    </system.web>
</configuration>

Hi,
i am trying to do the same unsucessfuly, could u post the code that u have working.
many thanks
ben