Re: getrows and progress bar



Your English is completely understandable. Your design has issues, but the
words are fine.
I just looked up Asynchronous Operations in my latest (albeit kinda old now)
ADO.NET book. There are many conditions that have to be right to get async
notifications (progress notifications) to work. However, you can (try to)
run the GetRows method on a separate thread. You might also try executing
the query so it only returns a few rows at a time and loop through until you
get them all. The real question is why are you bringing so many rows to the
client. They belong on the server.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
www.sqlreportingservices.net
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________


"PiantoTardivo" <aaaaa@xxxxxxx> wrote in message
news:Q6LCe.4772$a5.68580@xxxxxxxxxxxxxxxxxxxxx
> Hi,
> first of all, sorry for my bad english...
> So...go on...
> I've to load a recordset in an array with getrows.
> My recordset is quite big and the getrows take few time to load the
> recordest. I would like to show a progressbar during the
> getrows process.
> But I don't know how to do that...
>
> Any suggestion will be very appreciated...
>
> Thank you ery much
>
> IAK
>


.



Relevant Pages

  • getrows
    ... I've to load a recordset in an array with getrows. ...
    (microsoft.public.de.vb)
  • getrows
    ... I've to load a recordset in an array with getrows. ...
    (microsoft.public.vb.database)
  • getrows and progress bar
    ... I've to load a recordset in an array with getrows. ...
    (microsoft.public.vb.database.ado)
  • Re: GetRows Method
    ... The performance benefit that's talked about has to do with how long it takes ... as well as time to retrieve the fields once. ... then you're better off using the recordset as is. ... data, etc, then consider using GetRows, as that's its main performance ...
    (microsoft.public.vb.database.ado)
  • Re: GetRows Method
    ... I have read suggest using GetRows instead of a Recordset. ... using it and accessing something in the variant array. ... >> Dim cnADO As ADODB.Connection ...
    (microsoft.public.vb.database.ado)