How to calculate the time it would take to fill a dataset vb.net 2003??
Posted on 2007-03-23
Experts, is there anyway to calculate the time it would take to connect to a database and fill a dataset using vb.net?
What I am trying to do is use a progress bar to show the progress of a database connect and retrieval of data, what I would need is to know how long before hand it would take to execute this line of code
Once I got the "time" I could set a timers intervals based on the "time" divided by the max value of the progress bar. Any ideas on how to do this?
Dim ssql As String = "select [Part#] as PartNumber, SerialNumber, AutoNumberID, Quantity from DailyBuildList " & _
"Where Uploaded = 0"
Dim ora As OleDbDataAdapter = New OleDbDataAdapter(ssql, accessconn)
Dim org, status As Integer
Dim dr As DataRow