how to add a progress bar or loading bar or time of loading data for t

Question

how to add a progress bar or loading bar or time of loading data for this code ,it will be possible to use backgroundworker for it ,because we don't use loop

private void BtnBrowse_Click(object sender, EventArgs e)
{
    using (OpenFileDialog openFileDialog = new OpenFileDialog() { Filter = "Excel 97-2003 Workbook|*.xls|Excel Workbook|*.xlsx" })
    {
        if (openFileDialog.ShowDialog() == DialogResult.OK)
        {
            txtFilename.Text = openFileDialog.FileName;
            using (var stream = File.Open(openFileDialog.FileName, FileMode.Open, FileAccess.Read))
            {
                using (IExcelDataReader reader = ExcelReaderFactory.CreateReader(stream))
                {
                    DataSet result = reader.AsDataSet(new ExcelDataSetConfiguration()
                    {
                        ConfigureDataTable = (_) => new ExcelDataTableConfiguration() { UseHeaderRow = true }
                    });
                    tableCollection = result.Tables;
                    cboSheet.Items.Clear();
                    foreach (DataTable table in tableCollection)
                        cboSheet.Items.Add(table.TableName);//add sheet to combobox
                }
            }
        }
    }
}

Mohammad Hussain · Answer

private BackgroundWorker backgroundWorker; public YourForm() { InitializeComponent(); // Initialize the BackgroundWorker backgroundWorker = new BackgroundWorker(); backgroundWorker.WorkerReportsProgress = true; backgroundWorker.DoWork += BackgroundWorker_DoWork; backgroundWorker.ProgressChanged += BackgroundWorker_ProgressChanged; } private void BtnBrowse_Click(object sender, EventArgs e) { using (OpenFileDialog openFileDialog = new OpenFileDialog() { Filter = "Excel 97-2003 Workbook|*.xls|Excel Workbook|*.xlsx" }) { if (openFileDialog.ShowDialog() == DialogResult.OK) { txtFilename.Text = openFileDialog.FileName; // Start the BackgroundWorker to load data backgroundWorker.RunWorkerAsync(openFileDialog.FileName); } } } private void BackgroundWorker_DoWork(object sender, DoWorkEventArgs e) { string fileName = e.Argument as string; using (var stream = File.Open(fileName, FileMode.Open, FileAccess.Read)) { using (IExcelDataReader reader = ExcelReaderFactory.CreateReader(stream)) { DataSet result = reader.AsDataSet(new ExcelDataSetConfiguration() { ConfigureDataTable = (_) => new ExcelDataTableConfiguration() { UseHeaderRow = true } }); tableCollection = result.Tables; } } } private void BackgroundWorker_ProgressChanged(object sender, ProgressChangedEventArgs e) { // Update the progress bar or loading indicator here // You can use e.ProgressPercentage to set the progress value } private void BackgroundWorker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { // Data loading is complete, update the UI or perform any other actions }

muha · Answer

Mohammad Hussain thank you for the response but progress bar value doesn't work