Interrupting a data load

[Frank]

I have made an application that loads data through an
OleDbDatareader. I would like the user to be able to
interupt the load.

Now, I could of course include an interrupt button in the
form. However, once the load starts program excution will
be in the object of my dataload class. And so I suspect
that the users interaction with an interrupt button
(which could set a flag in the load object) will not be
handled.

Instead of a lot of experimenting, I thought that I would
ask for some hints, from those who might already know how
to do this.
Regards,

Frank

[Fergus Cooney]

Hi Frank,

Sorry, I'm busy on another query and then off to bed, so ...

The quick answer (ie. not telling you exactly how) is to spin off a Thread
to do the load. If the User hits that [Interrupt] button, then abort the
Thread.

You'll have to have a Try .. Catch ex As ThreadAbortException so that your
app doesn't fall over.

Regards,
Fergus

[Herfried K. Wagner [MVP]]

* "Frank" <an*******@discussions.microsoft.com> scripsit:

I have made an application that loads data through an
OleDbDatareader. I would like the user to be able to
interupt the load.

Now, I could of course include an interrupt button in the
form. However, once the load starts program excution will
be in the object of my dataload class. And so I suspect
that the users interaction with an interrupt button
(which could set a flag in the load object) will not be
handled.

Instead of a lot of experimenting, I thought that I would
ask for some hints, from those who might already know how
to do this.

I think you got very good answers in your previous thread.

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

[Frank]

Hi Fergus,

Thanks, I'll work out how. Just needed to know, if
threading was neccesary or there was another way. I'll
read up on handling threads and then get to it.

Regards,

Frank

-----Original Message-----
Hi Frank,

Sorry, I'm busy on another query and then off to bed, so ...
The quick answer (ie. not telling you exactly how) is to spin off a Threadto do the load. If the User hits that [Interrupt] button, then abort theThread.

You'll have to have a Try .. Catch ex As ThreadAbortException so that yourapp doesn't fall over.

Regards,
Fergus
.

[Herfried K. Wagner [MVP]]

* "Frank" <an*******@discussions.microsoft.com> scripsit:

threading was neccesary or there was another way. I'll
read up on handling threads and then get to it.

Notice that msdn contains a big chapter about threading of you want to
know the background information:

Threading (.NET Framework Developer's Guide)
<http://msdn.microsoft.com/library/en-us/cpguide/html/cpconthreading.asp>

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

[Franks]

Thanks, this looks good!

Frank

-----Original Message-----
* "Frank" <an*******@discussions.microsoft.com> scripsit:

threading was neccesary or there was another way. I'll
read up on handling threads and then get to it.
Notice that msdn contains a big chapter about threading

of you want toknow the background information:

Threading (.NET Framework Developer's Guide)
<http://msdn.microsoft.com/library/en- us/cpguide/html/cpconthreading.asp>
--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>
.

[Robin Tucker]

In general I don't like the idea of Aborting a thread too much - it would be
much better to stick a flag in the thread main loop to terminate cleanly.

"Frank" <an*******@discussions.microsoft.com> wrote in message
news:08****************************@phx.gbl...

I have made an application that loads data through an
OleDbDatareader. I would like the user to be able to
interupt the load.

Now, I could of course include an interrupt button in the
form. However, once the load starts program excution will
be in the object of my dataload class. And so I suspect
that the users interaction with an interrupt button
(which could set a flag in the load object) will not be
handled.

Instead of a lot of experimenting, I thought that I would
ask for some hints, from those who might already know how
to do this.
Regards,

Frank