Using ProgressBar or ProgressArea with executing an SQL statement

[Keith]

I have an ASP.Net page that uses the ProgressBar when user clicks on EXPORT button to export data to an Excel (.xlsx) file.  It works great.

Now the question is that is there a way to use that ProgressBar or the ProgressArea when executing a long running SQL statement?

When the user clicks on the EXPORT button, the VB code-behind looks at the RadRadioButtonList to determine which was selected and run the appropriate Export process.  The RadRadioButtonList has EXCEL, PDF, and TABLE.  When EXCEL is selected, the ProgressBar is used to show progress of exporting data to an Excel file.  Exporting to PDF does not use the ProgressBar.  I would like to have a way to show the ProgressBar or use the ProgressArea when exporting to a TABLE which basically means it using the SQL INSERT statement to insert records from a SELECT statement into another table.

Please help!

Thanks!

Sincerely,

Keith Jackson

[Marin Bratanov]

Hello,

The following code library offers an example that uses client-side code to poll the server for the process status and puts the response in the progress bar: http://www.telerik.com/support/code-library/track-long-running-server-operation-with-radprogressbar.

This is the approach RadProgressArea uses internally, and you can see it in action here: http://demos.telerik.com/aspnet-ajax/progressarea/examples/customprogress/defaultcs.aspx.

An alternative you can consider is using tools like SignalR to create events in the browser from the server operation where you can use the same client-side approach to change the value of the RadProgressBar.

Regards,

Marin Bratanov
Telerik by Progress

[Keith]

Thanks Marin!  I will look into that.