i noticed a lot of timeout issues in my web app and am wondering if there's a better way to get the data. the basic code for pulling the data is
Dim dgTable As New DataTable
dg_AddressData.DataSource = dgTable
this is in a development enviornment and my connection string to SQL Server is explicit (that is, written out in code rather than referenced from web.config) and uses new SqlConnection. the connection works off a stored proc. when i run the same query directly in SQL Server Management Studio, it runs quickly, but ASP.NET is elderly and dim.