How can I construct a progress bar that will show percentage for DB updating?

Well,
If you are in a batch, I think you can show the percentage in progressbar by separating each individual steps of the whole batch, and then calculate the percentage of individual item out of the whole batch.

Like say you have 20 statements, and you are running the 2nd item, you will do

percentage = (2/20) *100

You better do the calculation during batch work using a new Thread, and invoke an event from that thread to update the progress bar. Using a new thread will make the UI thread smooth.

As Christian suggested, you might also try to make it indeterminate, and for that too, you need to use a separate thread, so that the progressbar doesnt stop while you are running database updates.

Say you are updating 1 million records. Create a loop to update those records in your stored procedure (doing them in small batches of, say, 10,000 at a time). During each iteration of that loop, also update another table to indicate the progress through the loop. Then, have your C# program poll that progress table to check what percent complete it is.

The only way to 'connect' your progress bar to a process, is to make that process occur in lots of small steps, which, with a DB update, is very likely to slow it down. Show an indeterminate progress bar, in cases where you can't easily track progress.

Well guys thank you, your answers were more than sufficient!:thumbsup: