I am creating an application (adp project) which is connected to SQL Server. I need to run a stored procedure which takes appx. 2min and in the meanwhile I need to show to user that it is running (progress bar, time etc).
The problem is that "adoCommand.Execute" which runs that stored procedure is just one line. Is it possible to do that somehow?
My second question is whether it is possible to have a button on the form which would cancell that process (stored procedure).