showing progress of a running Query
-
Hi every buddy, Well I was thinking abt building some kind of a mechanism that gives progress in a progressBar while we access some information from the Database. So the core issue is, how to get the progress information from a query while it is running on a database. Lets say you’re making a long calculation from a ledger Table Cust_Ledger(ID, , account_ID ,CustID, Debit, credit, t_date) And u execute the query using the SqlDataAdapter or TableAdapter or whatever the case maybe, then how can u show the progress… Thanks in advance, Rocky
-
Hi every buddy, Well I was thinking abt building some kind of a mechanism that gives progress in a progressBar while we access some information from the Database. So the core issue is, how to get the progress information from a query while it is running on a database. Lets say you’re making a long calculation from a ledger Table Cust_Ledger(ID, , account_ID ,CustID, Debit, credit, t_date) And u execute the query using the SqlDataAdapter or TableAdapter or whatever the case maybe, then how can u show the progress… Thanks in advance, Rocky
You can't.
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
-
Hi every buddy, Well I was thinking abt building some kind of a mechanism that gives progress in a progressBar while we access some information from the Database. So the core issue is, how to get the progress information from a query while it is running on a database. Lets say you’re making a long calculation from a ledger Table Cust_Ledger(ID, , account_ID ,CustID, Debit, credit, t_date) And u execute the query using the SqlDataAdapter or TableAdapter or whatever the case maybe, then how can u show the progress… Thanks in advance, Rocky
Instead of a progress bar try another progress indicator, if your idea is showing activity to the user. Otherwise, I dont know any way of doing what you're asking.
-
You can't.
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
Only thing I can think of would be to break the query down and loop through the broken down bits, but it would probably have a fair performance hit, though...