how to display the progress bar until sql procedure running in vb.net?

[bluesathish]

Dear All,
I want to display the Progress bar control in my vb.net application until my procedure runs at the backend. Please anyone help me to do this.


Regards,
Bluesathish

[Crusader2010]

Read on the Backgroundworker and you should be able to do it yourself. Some tips:

In the DoWork event run your procedure and call ReportProgress with a value related to how much of your data was loaded compared to the total amount (basically a percentage), and as well send any value you might also need(UserState parameter).

In the ProgressChanged event adjust the progressBar1.Value to the percentage(or a variation of it based on progressBar1.Maximum), by using e.ProgressPercentage, as well as do anything with the value from e.UserState if you need to.

In the RunWorkerCompleted event you can put the value of the progress bar to its maximum or display a message box that loading the data has finished, or whatever (like hide the progress bar).

Hope this helps

[sirasingh]

You can call report progress or even you can set the progress bar with timer.
If ProgressBar1.Value <= 32 Then

Label7.Text = "Initializing....."

ElseIf ProgressBar1.Value <= 52 Then

Label7.Text = "Loading components....."

ElseIf ProgressBar1.Value <= 72 Then

Label7.Text = "Integrating Database...."

ElseIf ProgressBar1.Value <= 100 Then

Label7.Text = "Please wait..."

End If

If ProgressBar1.Value = 100 Then

Timer1.Dispose()

Me.Visible = False

Dim cur As New FrmLogin()

cur.Show()

End If