hi all,

is it possible to use backgroundworker when loading database data / filling datatables?

i did the ff: codes below but it doesn't work right... myDataTable is not being filled and the progressbar doesn't do anything.

Code:

Private Sub vo01_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.BackgroundWorker1.RunWorkerAsync()
End Sub

Private Sub BackgroundWorker1_DoWork(ByVal sender As System.Object, ByVal e As System.ComponentModel.DoWorkEventArgs) Handles BackgroundWorker1.DoWork
Me.myTableAdapter.Fill(Me.DataSet.myDataTable)
End Sub

Private Sub BackgroundWorker1_ProgressChanged(ByVal sender As Object, ByVal e As System.ComponentModel.ProgressChangedEventArgs) Handles BackgroundWorker1.ProgressChanged
ProgressBar1.Value = e.ProgressPercentage
End Sub
please help... thanks.