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

Rahul Singh

9y16.3kWindows Forms

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

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Guest User9y ago
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.
0
Rahul Singh9y ago
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...
0
Guest User9y ago
You can put a PictureBox on your form with a GIF in it, and then set that Visible = true; while processing.
0
Rahul Singh9y ago
Thanks ,pritaeas your code is working, but i want to display gif spinner.
0
Jay Stewart9y ago
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
    }

}
0
Vivek Kumar9y ago
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
0
Guest User9y ago
try
{
Cursor = Cursors.WaitCursor;

// your query
}
finally
{
Cursor = Cursors.Default;
}
+1