I Need Progressbar With Sqlbulkcopy

I need progress bar for my application. I am uploading data through text file into SQL Server but it takes a lot of time and also i used background worker for the same but that's n

Solution 1:

You need to handle the SqlBulkCopy.SqlRowsCopied event which

Occurs every time that the number of rows specified by the NotifyAfter property have been processed.

I would also use Async Await and use a Progress<T> instead of a background worker