Using the term "stuck" is is a bit vague.

From what I can gather, running a query from an ASP.NET page causes issues on the SQL Server?

If that is the case, I'd check the Windows Application Logs for the Web Server hosting the application to start with.

Have you set connection and query timeouts in Web.config?

Hope this gives you something to start with.