We're getting a problem here where out application occassionally slows to a crawl and we start getting loads of time out issues. Anecdotally it looks like this might be assosciated with a user doing a large export. I want to eliminate this as a possibility.

The code to get the data to be exported uses the SQLHelper.FillDataset method to populate a dataset. It then loops through the dataset and writes the records out to a file. That's fine if the recordset's detached but I can imagine it would be a major problem if it's attached. How can I check this in .net? How can I specify it as detached? (I used to be happy with the ado parameters to specifiy this but I can't find how to do it in .net)

Thanks as always,
Dec