Force Screen Refresh during initial page load

I have a asp.net 3.5 (vb.net) application that after the user authenticates loads a large chunk of data, the issue is the screen just freezes until the data load is completed. This makes it look to the user like it has hung and they are closing the browser.  Is there a way to force the application screen to finish loading prior to making the call to the database or somehow thread the request so the page renders while its loading the data.  I know this must be a common problem but googling hasn't yeilded anything usable. Your advise is greatly appreciated.
LVL 1
clintnashAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
silemoneConnect With a Mentor Commented:
How are you pulling your data?

Have you tried using a dataset object?  

And are you using stored procedures?  Are you queries efficient?  If so, have you used indexes on your tables?

Can you show code?
0
 
clintnashAuthor Commented:
Once the user authenticates the page is redirected to a different aspx page.  In the page load event the following code is run.

<code>

        If Not IsPostBack Then
            Dim myreader As SqlDataReader = CType(SqlDS_SyncDB.Select(DataSourceSelectArguments.Empty), SqlDataReader)

            If Not (myreader Is Nothing) Then
                If myreader.Read() Then
                    loadsuccessfull = myreader("Returned").ToString()
                Else
                End If
            End If
        End If

</code>

The SQL Data Object is running a stored procedure which is copying data from a MySQL server setup as a view inside our MS SQL 2005 server (technically that procedure truncates a table, inserts roughly 400 to 1000 rows from the MySQL view, then runs updates based on values in a sql table) .  The MySQL server is a 3rd party applications database.  This update has to occur each time the application loads to refresh the data attempts to code directly against the MySQL Server yeilded results that we unusable because of speed. We are working to improve the performance of the load on the database side, but its server to server and is just going to be slow.

Ideally before the code above is executed the page would finish rendering and somehow using AJAX render with an updating notice.  Not concerned if the user is unable to do anything until the data is loaded, just want them to see something that confirms that application is still working...

Thanks for you help...
0
All Courses

From novice to tech pro — start learning today.