Displaying Custom Progress Bar while Fetching Data From The C# Database [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 10 years ago.

Improve this question

I use the below code to fetch the data from database and display the data on dataGrid now How to Display Custom Progress bar while fetching the data from the database ?

private void ReadRecords(){
        using (SqlConnection c = new SqlConnection(Properties.Settings.Default.Database1ConnectionString)) {
            try{
                c.Open();
                if (c.State == ConnectionState.Open) {
                    using (SqlDataAdapter a = new SqlDataAdapter("SELECT * FROM Items ORDER BY item_id", c)) {
                        try {
                            DataTable t = new DataTable();
                            a.Fill(t);
                            dataGridView1.DataSource = t;
                        }

                        catch(Exception ex){
                            MessageBox.Show("Failed Fill Data :." + ex);
                            return;

                        }
                    }
                }
            }

            catch (Exception ex)
            {
                MessageBox.Show("Failed To Open Connection :." + ex);
                return;
            }
        }

    }

SO won't, or rather shouldn't, just blindly give you code. What I would suggest, since it's a new topic for you, is to take the database out of the equation. Search around on how to get a progress bar on it's own, then work out how to integrate it within your database app. — Arran
– Arran, Commented Dec 20, 2014 at 15:40
You could display a spinner or wait cursor, but something showing percent complete would be difficult. For that you would need to know how long the query will take, and I don't think that information is available. — hatchet - done with SOverflow
– hatchet - done with SOverflow, Commented Dec 20, 2014 at 15:43
possible duplicate of Implement progress bar on SQLite database read C# — hatchet - done with SOverflow
– hatchet - done with SOverflow, Commented Dec 20, 2014 at 15:47

Community · Accepted Answer · 2017-05-23 11:52:49Z

1

The "trick" here is using the UI thread appropriately, if you are loading your data from the DB using the UI thread (typically resulting from a click or load event) then any animation or progress indicator would be frozen because the UI thread is busy with the data operation. What you need to do is thread out or via the TPL "task" out the data loading operation and when that op is complete Invoke a method to turn off the progress indicator.

By threading out the data op to a non-UI thread the UI thread is available to perform your animation. Here is a link that details how to invoke the UI thread:

Execute a delegate in the ui thread (using message pump)

edited May 23, 2017 at 11:52

CommunityBot

11 silver badge

answered Dec 20, 2014 at 15:50

T McKeown

12.9k1 gold badge27 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

opewix · Accepted Answer · 2014-12-20 15:45:52Z

0

The simplest solution is to show loading indicator without any progress values.

ShowProgressIndicator();
ReadRecords()
HideProgressIndicator();

If you want to show real progress, you must determine amount of work. For example let's say total rows count is whole work. You can calculate % of progress by dividing fetched rows / total rows count. You should make several requests to database to implement such progress bar.

First - request total rows count. Then - fetch rows by portions, say 500 rows per request until all rows fetched.

answered Dec 20, 2014 at 15:45

opewix

5,1031 gold badge22 silver badges43 bronze badges

5 Comments

Muhammad Younas Over a year ago

i want to do like that but how to show ShowProgressIndicator(); and HideProgressIndicator(); is that built in functions or we have to write it ?

opewix Over a year ago

What technology do you use? WPF, Silverlight, WinForms, ConsoleApp or WebApplication (MVC, WebForms)?

Muhammad Younas Over a year ago

Windows Forms desktop application with local database.....

opewix Over a year ago

You have to write own methods to animate and stop progress bar. In ShowProgressIndicator() method, set progressbar visible and progressbar Style property to Marquee.

opewix Over a year ago

@YounasBangash I'm not familiar with WinForms, I've just explained the theory of displaying work progress. Add progress bar control to your form and try to indicate intermediate status setting it's style to Marquee

Collectives™ on Stack Overflow

Displaying Custom Progress Bar while Fetching Data From The C# Database [closed]

2 Answers 2

Comments

5 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Linked

Related