Populate 15000 Item in dropdownlist

Question

1.00/5 (2 votes)

See more:

VS2013

hello guys ,
i am developing MVC Website for online ordering , i have about 15000 items will be loaded to manage the user to choose the his/her order item

after loading these huge items my web site seems very slow ,

how can i make a server side filtering ... what i mean user type 3 characters then i go to my DB Select items that contains these 3 characters and show them in the dropdownlist how can i do that ?

thanks in advance

Posted 27-Jun-14 9:52am

Yasser El Shazly

Updated 27-Jun-14 13:04pm

v2

Add a Solution

Comments

[no name] 27-Jun-14 16:05pm

Put yourself in your user's shoes for just a second..... would you want to scroll through 15000 items looking for the one thing that you want? Bad design.

Yasser El Shazly 27-Jun-14 16:19pm

i am trying to give the user the power of filtering the comboBox to fetch required item faster , but i didnt knew how can i do that?

[no name] 27-Jun-14 16:47pm

Why can't you let the user select from a category of items? Then show the items that fit into that category?

Yasser El Shazly 27-Jun-14 16:20pm

you are right but what is the good design in your point of view

Sergey Alexandrovich Kryukov 27-Jun-14 16:43pm

We don't know your ultimate goals. Besides, if you don't feel insanity of your idea, you first need to fix your thinking; no design ideas can help you.
—SA

[no name] 27-Jun-14 16:45pm

Well gee... based on what we know of your website? Don't try and show 15000 items to the user all at once is about all we could tell you.

Yasser El Shazly 27-Jun-14 18:35pm

how can i make a server side filtering ... what i mean user type 3 characters then i go to my DB Select items that contains these 3 characters and show them in the dropdownlist how can i do that ?

[no name] 27-Jun-14 18:49pm

It's called "autocomplete"

Yasser El Shazly 27-Jun-14 19:07pm

how can i make autocomplete ?

[no name] 27-Jun-14 20:08pm

http://www.google.com/search?q=c%23+autocomplete followed by doing some research how to tie autocomplete to whatever database you are using.

4 solutions

Solution 3

You could offer various checkbox/radio button filtering controls to limit the data returned. Combine that with a "paging" effect to only return (e.g.) the first 100 items in the list... load data on demand

Posted 27-Jun-14 13:51pm

CHill60

Solution 2

Browsers cannot handle that much data in one load. You'll want to allow searching/filtering first or create a menu structure so that they can browse. And then whatever type of repeater control you decide to use you'll want to implement paging.

Posted 27-Jun-14 10:59am

ZurdoDev

Comments

Yasser El Shazly 27-Jun-14 17:01pm

yes Exactly i want to Searching/Filtering First but i didn't knew how can i do that with DropDownlistFor , can you help me ?

Solution 1

None of the users except the most insane ones will get enough patience to choose an item from 15000 in the same list box. You need to radically review your UI design.

—SA

Posted 27-Jun-14 10:42am

Sergey Alexandrovich Kryukov

Comments

Yasser El Shazly 27-Jun-14 16:45pm

Ok, but My question was what is the best way to do that ?
and i wanna make Server Filtering Over DropDownListFor and i didnt knew how can i do server filtering ... any help ?

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

nrgjack · Accepted Answer · 2014-06-28T05:17:00

Solution 4

15k items in a dropdown?
this is very bad...

use an autocomplete [^]
that retrieves items when at least a couple of char are inserted...

Posted 28-Jun-14 5:17am

nrgjack

Updated 28-Jun-14 5:18am

v2

Comments

Yasser El Shazly 30-Jun-14 19:50pm

How can i use this Jquery AutoComplete With .Net MVC 4

nrgjack 1-Jul-14 4:37am

well i used AjaxControlToolkit in the past that have an autocomplete that works with ASMX webservice in order to load items, otherwise you can check jquery ui autocomplete : http://api.jqueryui.com/autocomplete/