Also, I recheck the code and I guess it is running in the main thread only.
If it is running in the main thread then is there any solution to it
kaufmed
I suppose that depends on how you want to solve it. If you want to run it on the main thread, then your user's browser window is going to sit there spinning until the operation completes--assuming it completes before your configured timeout period. Otherwise, I *think* you would need to make the thread a background thread in order to allow ASP.NET to return a response to the client browser, yet still continue processing the DB inserts. This foregos returning a response to the browser in that request. You would have to work some AJAX magic in order to see a response from the background thread's work.
e.g.
Open in new window