473,322 Members | 1,610 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Pagination of data in listbox

I need some resources to understand best practices when filling a listbox
with a large datatable. I've got the basics down of making calls to the
database returning a couple hundred rows at a time on a separate thread, but
I still get a flickery listbox as each new page is added to the underlying
datasource.

Surely, I'm not the first to do this, so where can I read more about it?

Thanks in advance...
--
--Zorpie
Nov 21 '05 #1
5 1211
Zorpiedman,

How do you fill it now because there are so many options in that?

Best practise does not exist in dotNet, it is not Ms-Access, when there was
a best practise there was only one method.

Cor
Nov 21 '05 #2
I forgot, what is your database because that is as well important, Access by
instance is very slow when you compare it with SQL(MSDE) when you use huge
amounts of data.

And why the multithreading, seems to me crazy. I nowhere saw that that is
adviced to get data into an application from a database. That is in my
opinion sure no best practise.

Don't forget that when there is not a multiprocessing environment (more
processors or hyperthreading) there is never more than one thread working at
the same time. That has to be processed than extra to give every thread
entrance too the processor.

Cor
Nov 21 '05 #3
Cor -

It must be a language translation thing, but your responses always seem so
rude! We are not all idiots, you know!

Anyway, I have a MSSQL back end, and the list box is filled with the
datasource property.

I'm sorry you think this is so _crazy_, but it is the precise method I was
shown at a trainins session I took at the Microsoft campus in Redmond,
Washington. Yes, we all know it still takes as long (in fact a little
longer) since I don't have any extra processors, but the PRECEIVED speed is
what we are after. Get the data on the screen foer the user, than continue
filling it while they are deciding what to do.
Nov 21 '05 #4
Zorpiedoman,

I did not see before I wrote this message that this was a message repeating
another message before this one from you where it seems you did not even
look or paid attention to the answer.

http://groups-beta.google.com/group/...2aa9685ef99f69

This is in my opinion in contradiction with this reply from you.

A lot of success with your (standard) solution of the problem.

Cor
Nov 21 '05 #5
Cor -

Please do not respond to any more of my posts. I find your
condensending remarks unproductive, and not appropriate for this forum. If
you have useful information to share with people, than share it, otherwise
keep your snide remarks to yourself. Many times people have to ask questions
more than once in different ways to try and get an answer. Becides, if YOU
really were paying attention, you would have seen that it was ME that
responded to my own question on the other thread once I found an answer to
that question. The problem has not gone away, and this new question is
trying to get more info.

If you don't have an solution, then just don't respond. I don't have
time to argue with someong over the quality or quantity of my questions.

Thank you.

-Zorpy

"Cor Ligthert" wrote:
Zorpiedoman,

I did not see before I wrote this message that this was a message repeating
another message before this one from you where it seems you did not even
look or paid attention to the answer.

http://groups-beta.google.com/group/...2aa9685ef99f69

This is in my opinion in contradiction with this reply from you.

A lot of success with your (standard) solution of the problem.

Cor

Nov 21 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Faree | last post by:
I am workign on a news portal which needs paginaiton as usual.but all the code i got depends on the number of records that will come from database :( .it is working well too. But i need...
1
by: Kruq | last post by:
Is it possible to use pagination with DataList? Can't find it.. :( Kruq
1
by: Henrik | last post by:
Hello all. I'm after some sort of pagination function. One that takes some in data that I provide, and returns an array of controls, pointing to page 2, page 3 etc. Trying to mimic the way that...
1
by: OceanBreeze | last post by:
I am new to .Net. I am using ASP 2.0 and C#. I want to pupolate a data grid programatically using the values obtained from a list conating domain objects. E.g., DAL.GetEmployee() returns a...
2
by: s4lin | last post by:
problem is pagination not retaining data field i have form with general data field, and i need to select some option which is store in database, so i open another page with retrieving data from...
1
by: shalini jain | last post by:
Hi, I want to know how can we do pagination using XSL. There are number of tutorials available on pagination using PHP but nothing with XSL. i am really stuck with my code. Below is the code that...
3
by: gagonm | last post by:
Hi All I have an urgent issue where I m transforming an xml structure into html page using xslt . since data is more , I need to do Pagination .Also there is an option to do sorting of ...
16
by: gnawz | last post by:
I have a pagination function I am using in a file called functions.php as below<? //Pagination functions function getPagingQuery($sql, $itemPerPage = 10) { if (isset($_GET) && (int)$_GET > 0) ...
1
markrawlingson
by: markrawlingson | last post by:
Hello, For starters: Yes, I am new to asp.net, however I hold a good 9-10 years of experience working with classic asp and am only just now upgrading my skills. I'm picking asp.net up pretty...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.