I need to create a virtual listview control...i.e. i have a BIG list of records in a database which i wish to show the user in a listview...but loading from database takes abt 50-60 seconds and on a network its even worse....So, i came across this code from Mvps.org which works great but sometimes it crashes the whole software...so, i am looking for alternatives...kindly reply if u have something in this reagrd...thanx in advance.

__________________
Amarjit Singh

hi

why u want to display the complete looooooong list to the user??????

instead give a SEARCH criteria to the user, and it will reduce the data

thanx for replying...

I am developing a Point of Sale software in which the user can search for the items using various criteria, like a particular supplier, barcode,refno etc.etc...

Earlier its written in VC++...which is very fast in such cases....but in that tooo i have used Virtual ListView...i.e. let the heing of listview control be sufficient to show 20 items then it will only retrieve 20 records from the recordset and thus is much much faster....when user scrolls down the listview it will retrieve the records as needed....there is a property called OWNER_DATA in VC++ which is not exactly in VB.

i m not sure why u wanna show a looooooooong list of records in a POS system. A POS is meant to be very fast and user does not hv time to scroll the list.

and whether its VC++ or VB, it will take same time in fetching the data as both use same tech. to manipulate data.

and if u r getting the long list after flitering the data then, u will hv to do wht u did using VC++
i.e display frst 20, then nxt 20 and so on.....

u can also try to optimize ur SQL

and can u post tht code???

Actually, its a complete POS Application and this part is required in the Inventory Module wherein the Admin users add/modify item details like price changes/Purchases/Inter Branch Transfers etc...so for that i need a gud search screen...but anyways, for the time being, i am showing the first 200 records...and if the user scrolls down and reaches the last 20 records i load another 200 records in the list... ;) this works fine...without compromising on the speed.

thankx for your reply neways..i really appreciate it.