Show status of loading DataSet by Progress Bar
Posted on 2004-11-02
I have to present the status of loading data into a data grid by progress bar.
I have a SQL query that executes for about one minute. During that time (and loading data into grid), I need to present percentage of loaded data (or executed SQL) by progress bar. I do not know how many records will be returned from the query (nor want to execute somethink like "select count(*) from ....").
I have VB code like this :
Dim ds As DataSet
Dim da As OleDb.OleDbDataAdapter
Dim sql_query, DB_Connection_String As String
ds = New DataSet
da = New OleDb.OleDbDataAdapter(sql_query, DB_Connection_String)