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.