Show Loading animation during loading data in other thread

by

When the form is frozen, it means the UI thread is too busy and so even if you try to show a loading animation, it will not animate. You should load data asynchronously.

You can have an async method which returns Task<DataTable> like the GetDataAsync method which you can see in this post. Then call it in an async event handler. In the event handler, first show the loading image, then load data asynchronously and at last hide the loading image.

You can simply use a normal PictureBox showing a gif animation as loading control. Also you may want to take a look at this post to show a trasparent loading image.

enter image description here

public async Task<DataTable> GetDataAsync(string command, string connection)
{
    var dt = new DataTable();
    using (var da = new SqlDataAdapter(command, connection))
        await Task.Run(() => { da.Fill(dt); });
    return dt;
}

private async void LoadDataButton_Click(object sender, EventArgs e)
{
    loadingPictureBox.Show();
    loadingPictureBox.Update();
    try
    {
        var command = @"SELECT * FROM Category";
        var connection = @"Your Connection String";
        var data = await GetDataAsync(command, connection);
        dataGridView1.DataSource = data;
    }
    catch (Exception ex)
    {
        //Handle Exception
    }
    loadingPictureBox.hide();
}

More Related Contents:

  1. Question about terminating a thread cleanly in .NET
  2. How do I update the GUI from another thread?
  3. Cross-thread operation not valid [duplicate]
  4. Multi-threaded splash screen in C#?
  5. How to handle click event in Button Column in Datagridview?
  6. List vs BindingList Advantages/DisAdvantages
  7. DataGridView bound to a Dictionary
  8. Refresh DataGridView when updating data source
  9. How to invoke a UI method from another thread
  10. how to bind datatable to datagridview in c#
  11. CRUD Operations using DataGridView, DataTable and DataAdapter – Cannot add new row to DataGridView
  12. How to change the color of winform DataGridview header?
  13. Index of Currently Selected Row in DataGridView
  14. Show row number in row header of a DataGridView
  15. How to filter data using Entity Framework in a way that DataGridView be editable and context track changes?
  16. Adding Text to DataGridView Row Header
  17. C# Windows Forms Application – Updating GUI from another thread AND class?
  18. DataGridView keydown event not working in C#
  19. How to create a Button that can send keys to a conrol without losing focus – Virtual Keyboard
  20. DataGridView with Button Control – Delete Row
  21. Why is my bound DataGridView throwing an “Operation not valid because it results in a reentrant call to the SetCurrentCellAddressCore function” error?
  22. WinForms DataGridView – databind to an object with a list property (variable number of columns)
  23. How to exit all running threads?
  24. Avoiding the woes of Invoke/BeginInvoke in cross-thread WinForm event handling?
  25. Populating a DataGridView with Text and ProgressBars
  26. How to refresh datagridview when closing child form?
  27. DataGridView Image for Button Column
  28. How to create a Button that can send keys to a control without stealing the focus – Virtual Keyboard
  29. Add vertical scroll bar to panel
  30. How to eliminate flicker in Windows.Forms custom control when scrolling?

Leave a Comment