Visual Basic

KreativeKai wrote:

The server does not have Excel on it

KreativeKai wrote:

Is there a way to get around loading Excel on the server?

' Setup the BackgroundWorker object and start the work somewhere...
BackgroundWorker1.WorkerReportsProgress = True
BackgroundWorker1.WorkerSupportsCancellation = True
BackgroundWorker1.RunWorkerAsync()
 
Private Sub BackgroundWorker1_DoWork(ByVal sender As Object, ByVal e As DoWorkEventArgs) Handles BackgroundWorker1.DoWork()
    ' Get a reference to the BGW that called this
    Dim bgw As BackgroundWorker = CType(sender, BackgroundWorker)
 
    ' Do some long running task about a million times...
    For I As Integer = 1 to 1000000
        ' Check to see if we've been cancelled
        If bgw.CancellationPending Then
            e.Cancel = True
            Exit For
        End If
 
        ' Do something useful here...
 
        bgw.ReportProgress(i / 10000)   ' Reduce i to the range of 0 to 100.
    Next
    e.Result = whatever ' Return whatever the result of this work is supposed to be.
End Sub
 
Private Sub BackgroundWorker1_ProcessChanged(ByVal sender As Object, ByVal e As ProgressChangedEvent) Handles BackgroundWorker1.ProgressChanged
    ' Do something usefull with the progress
    ProgressBar1.Value = e.ProgressPercentage
End Sub

Dave Kreskowiak wrote:

What Framework restriction???

varmag wrote:

1) If so how to destroy the thread object once its state is "Stopped".

varmag wrote:

2) The other issue is how to restart a thread which is in stopped state.