PRB: "Request Timed Out" Error Occurs When You Use the DataAdapter Method in an ASP.NET Application (825739)

MORE INFORMATION

Steps to Reproduce the Behavior

1. Start Microsoft Visual Studio .NET version 2002.
2. On the File menu, point to New, and then click Project.
3. Click Visual Basic Projects under Project Types, and then click ASP.NET Web Application under Templates. By default, WebForm1.aspx is created.
4. In Design view, right-click WebForm1, and then click View Code.
5. To add the database connection and the DataAdapter method to fill the dataset, replace the existing code with the following code:

   Imports System.Data.SqlClient
   Public Class WebForm1
      Inherits System.Web.UI.Page
   
   #Region " Web Form Designer Generated Code "
   
      'The Web Form Designer requires this call.
      <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
   
      End Sub
   
      Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
         'CODEGEN: The Web Form Designer requires this method call 
         'Do not modify it using the code editor.
         InitializeComponent()
      End Sub
   
   #End Region
   
      Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
         Try
            Dim sConnectionString As String
            sConnectionString = "server=servername;uid=sa;pwd=password;database=testdatabase;"
            Dim objConn As SqlConnection
            objConn = New SqlConnection(sConnectionString)
            objConn.Open()
   
            Dim daAuthors As SqlDataAdapter
   
            'Increase the no.of records from existing value, if execution time is less than 90 sec.
            daAuthors = New SqlDataAdapter("Select top 60000 * From timelog (nolock)", objConn)
            Dim myDs As DataSet
            myDs = New DataSet("testTimelog")
            Dim dt As DateTime
            dt = New DateTime()
            dt = dt.Now
            Response.Write("StartTime of DataAdapter fill - " + dt)
            daAuthors.Fill(myDs, "testTimelog")
   
            dt = New DateTime()
            dt = dt.Now
            Response.Write("<br>EndTime of DataAdapter fill - " + dt)
            Response.Write("<br>No of Rows = " + myDs.Tables(0).Rows.Count.ToString())
   
         Catch ex As Exception
            Response.Write(ex.ToString())
         End Try
   
      End Sub
   
   End Class
   

6. Open the Web.config file in Notepad, and then set the value for the Debug attribute to false as follows:

   <configuration>    
     <system.web>
       <compilation defaultLanguage="vb" debug="false" />
    </system.web>
   </configuration>    

7. Set the application to build in release mode. To do this, follow these steps:
   1. In Solution Explorer, right-click your project.
   2. Click Properties, and then click Configuration Manager.
   3. Click Release under Active Solution Configuration, and then click Close.
   4. Click OK.
8. On the Debug menu, click Start to build and run the project. You may receive the error message that the "Symptoms" section describes.