How to display "loading" spinner while a query is executing

Question

How to display 'loading' spinner while a query is executing in window application in asp.net c#

pritaeas · Answer

try { Cursor = Cursors.WaitCursor; // your query } finally { Cursor = Cursors.Default; }

pritaeas · Answer

Is it possible your process is so resource intensive, the picturebox has no time to update? Try putting Application.DoEvents in between, just to see what happens.

Rahul Singh · Answer

I also tried picture box and set gif in it and it visible = true while executing code but its not showing gif....but when i display another dialog box using 'MessageBox.Show("hi")' then the gif is visible on the previous win form...

pritaeas · Answer

You can put a PictureBox on your form with a GIF in it, and then set that Visible = true; while processing.

Rahul Singh · Answer

Thanks ,pritaeas your code is working, but i want to display gif spinner.

Jay Stewart · Answer

Check out background worker :D public partial class Form1 : Form { BackgroundWorker _worker = new BackgroundWorker(); SynchronizationContext _syncContext; public Form1() { InitializeComponent(); _syncContext = SynchronizationContext.Current; } private void btnLoadForm_Click( object sender, EventArgs e) { _worker.WorkerReportsProgress = true ; _worker.WorkerSupportsCancellation = true ; _worker.DoWork += new DoWorkEventHandler(HandleDoWork); _worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(HandleWorkerCompleted); _worker.ProgressChanged += new ProgressChangedEventHandler(HandleProgressChanged); _worker.RunWorkerAsync(); } private void btnCancel_Click( object sender, EventArgs e) { if (_worker.WorkerSupportsCancellation) { _worker.CancelAsync(); } } private void HandleDoWork( object sender, DoWorkEventArgs e) { // DO Any work to instantiate the form System.Threading.Thread.Sleep(2000); if (_worker.CancellationPending) { e.Cancel = true ; } else { Form2 newForm = new Form2(); newForm.ShowDialog(); } } private void HandleProgressChanged( object sender, ProgressChangedEventArgs e) { // DO Progress Bar Updates Here SendOrPostCallback callback = new SendOrPostCallback((o) => { label1.Text = "This is my Async content" ; }); _syncContext.Send(callback, null ); } private void HandleWorkerCompleted( object sender, RunWorkerCompletedEventArgs e) { // DO Any completed step items here } }

Vivek Kumar · Answer

Have a look into the below links https://stackoverflow.com/questions/9007152/showing-a-spinner-while-a-windows-forms-program-is-processing-similar-to-ajax https://stackoverflow.com/questions/1918158/how-do-i-show-a-loading-please-wait-message-in-winforms-for-a-long-loadi

How to display "loading" spinner while a query is executing

Answers (7)