progress when i am updating a table?

[alim]

Hey, can i show .. backgroundworker progress when i am updating a table..

Private Sub BackgroundWorker1_DoWork(ByVal sender As System.Object, ByVal e As System.ComponentModel.DoWorkEventArgs) _
		Handles BackgroundWorker1.DoWork

Adp.Update(Table)
End Sub

How can i show the process of updating records everytime.. .please help me .. urgent

 

[cjard]

You can't show the progress of an update operation on a database (you cannot show the progress of UPDATE table SET x = y WHERE ID BETWEEN 1 and 1000).

If youre trying to send 1000 rows to a database for update, then you should send them yourself, one at a time, using the TableAdapter.Update(DataRow) overload.
Then you can use this pseudocode:

loop{
ta.Update(row)
bgw.ReportProgress(rownum/rowcount * 100)
}

 

[alim]

thanks
it helps me a lot