I'm trying to implement the progress bar for an application that uploads files and stores them in a SQL Server database. The update calls a single stored procedure but the files being uploaded can be quite large (up to 60mb) so I want to use the progress bar to show that something is happening.

I've looked at the code on the help system but as there's only a single call to the stored procedure, it's not clear to me how to invoke the progress bar, i.e. the VB example shows a For/Next loop but I only have a single statement to execute inside this loop.

My code creates a new Command object, sets the name of the stored procedure, adds a few parameters and then calls the ExecuteScalar method to upload the file. This is in ASP.NET 1.1 application and I've downgraded to the version 8 controls for compatibility.

Can you provide me with an example of how I can call and move the progress bar in this situation? I'm using the server-side version because the update function runs on the server.

Thanks and best regards

Peter