Our Training Programs

All contents are copyright of their authors.

Display progressbar and percentage (%) while querying a data

Display progressbar and percentage (%) while querying a data

TAN WhoAMI

12yAsked Jan 9, 2014, 9:10 PM12.7kLINQ

when querying a database, I wish to display the progressbar and its percentage (10% interval till 100%) of completion.

How do I implement it? I refer to

http://www.c-sharpcorner.com/UploadFile/deepak.sharma00/how-to-show-progress-of-fetching-database-records-using-a-pr/

but it seems to me that I should not base the progressbar1.Maximum on the total records.

I think my code in the percentage progress is wrong too, what should it be based on?

code is as attached.

thanks.

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Abhay Shanker12y ago
Check below link can be helpful to you
http://www.codeproject.com/Articles/31406/Add-the-Percent-or-Any-Text-into-a-Standard-Progre
TAN WhoAMI12y ago
it depends...what is your definition of too much time?

on average, it says takes about a minutes once the Query button is pressed and the data is displayed on the ListBox.

Within that one minute interval, I wish to show its progress in % and progressbar, else user would keep waiting and wondering whether when the results would be displayed.

I hope I am clear.
Mahesh Chand12y ago
If your querying data taking too much time that you have to show a progress bar, you are querying it wrong. You don't need to query data in smaller chunks as much as you can display. For example, you may want to fetch 200 records and on next, get next batch and so on.

Is there anything I am missing?