I have a browser application using c# in code behind and ASP.Net. Using VS 2005 on .net framework v2.0. One of my stored procedure is taking time to process because of several joins files from separate database from where the stored procedures and other files are stored for the application. Not really very long but will seemed to be long to the user.

I would like to display a splash screen or another aspx page over the current aspx page at the start of the setting up to call to the stored procedure. After the stored procedure runs than would like to close the screen or page.

What would be the easiest/simplest way to do accomplish this task.