如何在 C# 中使用后台辅助角色类执行存储过程

我在 C# 中有以下代码，我尝试使用后台工人类来显示存储过程的执行进度。

或者（非常感谢任何输入如何在通过 c# 执行存储过程时显示进度消息）

问题是当我单击按钮时，代码中没有执行进度，不知道问题发生在哪里。如果有人有一些想法，请告诉我。

谢谢

//Butoon click code
 private void button_executeBL_Click(object sender, EventArgs e)
    {
        if (!backgroundWorker1.IsBusy)
        {
            backgroundWorker1.RunWorkerAsync();
        }
        else
        {
            label1.Text = "Busy Processing, Please wait";
        }
    }
    //background worker class process...
   private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
    {
        Thread.Sleep(200);
        int count =1;
        string connectionString = "Data Source=.;Initial     Catalog=VegetablesCoSD;Integrated Security=True";
        string commandText = "CoSD.BusinessLogic";
        using (SqlConnection conn = new SqlConnection(connectionString))
        {
            SqlCommand cmd = new SqlCommand(commandText, conn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandTimeout = 600;
            try
            {
                conn.Open();
                //count will be the number of rows updated. will be zero if no rows updated.
                 backgroundWorker1.ReportProgress( count = cmd.ExecuteNonQuery());
                if (backgroundWorker1.CancellationPending)
                {
                    e.Cancel = true;
                    backgroundWorker1.ReportProgress(0);
                    return;
                }
                e.Result = count;
            }
            catch (SqlException ex)
            {
                MessageBox.Show("Update Failed coz.. " + ex.Message);
            }
            finally
            {
                conn.Close();
            }
        }

    }
    private void backgroundWorker1_ProgressChanged(object sender, ProgressChangedEventArgs e)
    {
        progressBar1.Value = e.ProgressPercentage;
        label1.Text = e.ProgressPercentage.ToString();
    }
    private void backgroundWorker1_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
    {
        if (e.Cancelled)
        {
            label1.Text = "Process Cancelled";
        }
        else if (e.Error != null)
        {
            label1.Text = e.Error.Message;
        }
        else
        {
            MessageBox.Show("Business Rules Executed Successfully!!!");
            label1.Text = "Total Records Inserted" + e.Result.ToString();
        }
    }
    private void button_Cancel(object sender, EventArgs e)
    {
        if (backgroundWorker1.IsBusy)
        {
            backgroundWorker1.CancelAsync();
        }
        else
        {
            label1.Text = " No Operation in progress to cancel";
        }

    }

private async void button_executeBL_Click(object sender, EventArgs e)
{
    if (!backgroundWorker1.IsBusy)
    {
        await backgroundWorker1.RunWorkerAsync();
    }
    else
    {
        label1.Text = "Busy Processing, Please wait";
    }
}