Grid View and recordSet

3 May 2006 1:43 PM

Ed

hi everyone, maybe someone can give me a hand here.

I am working with vb 2005 and i have a gridview that i am loading data from a recordset. I have the recordset returned from the query and i am loading the data, but the problem is... this recordset is going to hold about 25,000+ records and the grid view and form "goes to sleep" and i can click on anything. I would like the user to be able to scroll the grid view and maybe min and max the form while the data is being loaded. i have tried grid.refresh() and me.refresh() but it jsut refreshed the data, it does not let the user scroll the grid view

any ideas?

Thanks!!!!

3 May 2006 4:29 PM

VJ

You will ahve to use Threads...and do the DataSet reading, in a Thread other
than UI thread, once the ds is available, you can set it to the grid... The
other option is to set grid rows from thread.. Read the below article it is
very helpful.., but it is 2003 and 1.1. I belivie in 2005 there is much
better option of using, but the below articles are a good start, so when you
see 2005 methods you will understand..

http://msdn.microsoft.com/msdnmag/issues/04/01/NET/default.aspx

http://www.devx.com/dotnet/Article/11358/1954?pf=true

http://msdn.microsoft.com/msdnmag/issues/03/02/Multithreading/default.aspx

VJ

Show quoteHide quote

<Ed> wrote in message news:O9jFBerbGHA.3388@TK2MSFTNGP05.phx.gbl...
> hi everyone, maybe someone can give me a hand here.
>
> I am working with vb 2005 and i have a gridview that i am loading data
> from a recordset. I have the recordset returned from the query and i am
> loading the data, but the problem is... this recordset is going to hold
> about 25,000+ records and the grid view and form "goes to sleep" and i can
> click on anything. I would like the user to be able to scroll the grid
> view and maybe min and max the form while the data is being loaded. i have
> tried grid.refresh() and me.refresh() but it jsut refreshed the data, it
> does not let the user scroll the grid view
>
> any ideas?
>
>
> Thanks!!!!