Design help please

  • Thread starter Thread starter john
  • Start date Start date
J

john

Hello,

We have a site that needs a combobox that links to a dataset that has up
to 4000 records in it. We are coding in vb.net. We have tried the one from
metabuilder but the combobox displays a text box and drop down on the
autopost back. We also tried http://www.codeproject.com/aspnet/combobox.asp
but couldn't get it to work for vb.net with a dataset, the data just
displays over the entire page. I have seen some commercial ones however they
seem to hit the database each time thus destroying performance. Does anyone
know of a good solid commercial or non-commercial combobox that could work
without destroying performance? Thanks in advance.

John
 
One you write yourself?

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
 
Kevin,

Unfortunately I am not sure how to go about this. That is why I was look
for either a sample in vb.net or a commercial product.

John
 
you are not going to find a browser solution for this. in a windows app you
implement a databased combo by taking over the rendering of the dropdown.
you catch the scroll events and display/llokup the data as needed.

in a browser based combo, you have to download all the data to the browser
at page load (commonally to a hidden div), as it can not maintain a
connection to the server to get just the data its wants. downloading and
rendering 4k rows is really slow.

you could write a java applet, or active/x control that maintained a
connection to you server to implement this.

-- bruce (sqlwork.com)
 
Back
Top