Using ProgressBar or ProgressArea with executing an SQL statement

3 posts, 1 answers
  1. Keith
    Keith avatar
    93 posts
    Member since:
    Mar 2015

    Posted 19 Jul Link to this post

    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!



    Keith Jackson

  2. Answer
    Marin Bratanov
    Marin Bratanov avatar
    3562 posts

    Posted 21 Jul Link to this post


    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:

    This is the approach RadProgressArea uses internally, and you can see it in action here:

    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.


    Marin Bratanov
    Telerik by Progress
  3. DevCraft R3 2016 release webinar banner
  4. Keith
    Keith avatar
    93 posts
    Member since:
    Mar 2015

    Posted 21 Jul in reply to Marin Bratanov Link to this post

    Thanks Marin!  I will look into that.
Back to Top