Show 'Retrieving Data' Message while filling the Datatable

Question

I want to show message on datagrid like 'Retrieving Data' while filling the datatable. Is there any chance to make it happen ?

Here is my code that filling the datatable;

public void getAlertGrid()

    {
            odaAlert = new OracleDataAdapter(getAlert, oradb); //odaAlert is Adapter
            odaAlert.Fill(dtAlert);  // dtAlert is Datatable
            ugAlert.DataSource = dtAlert;
    }

Answer 1

As @IkramTurgunbaev said you need to load data asynchronously and update the status bar. In the place where you call your getAlertGrid method do something like this:

private void MethodThatCallsGetAlertGrid()
{
    // Show the progress bar and set the style of progress bar to Marquee. This will show continiously scrolling block across progress bar, as you cannot know the current progress percent
    this.progressBar1.Visible = true;
    this.progressBar1.Style = ProgressBarStyle.Marquee;

    // Start loading the data source async
    Task.Factory.StartNew(() =>
        this.getAlertGrid())
   .ContinueWith((antecedent) =>
    {
        // Set data source on UI thread. Remove the same row from your getAlertGrid method
        ugAlert.DataSource = dtAlert;

        // Hide the progress bar
        this.progressBar1.Visible = false;
    }, TaskScheduler.FromCurrentSynchronizationContext());