Lookup Information

[Madison]

Hi there,

I'm writing web application that allow users to pick the providers from
dropdownlist. The providers list getting longer (>2000 names) and in the page
has other dropdownlists too. Sometime page need to re-load, it takes long
time to refresh the page. Have ideas to handle the dropdownlist (pull the
data from database)? Thanks.

 

[Guest]

Hi there,

I'm writing web application that allow users to pick the providers from
dropdownlist. The providers list getting longer (>2000 names) and in the page
has other dropdownlists too. Sometime page need to re-load, it takes long
time to refresh the page. Have ideas to handle the dropdownlist (pull the
data from database)? Thanks.

I would replace it by a popup div with a gridview in it. The gridview
can be paged, sorted, and filtered. The filter can be implemeted as a
textbox above gridview where you can enter first letters and it will
filter the grid based on what you have given it. It should
significantly improve the performance and improve UI.

 

[Vince Xu [MSFT]]

Hi,

What about the data of the DropDownList?
To reduce the workload of the datasource reading, you can use Ajax to
handle this. Please check this:
http://www.asp.net/AJAX/AjaxControlToolkit/Samples/AutoComplete/AutoComplete
.aspx


This control will render some related items in the list after you type some
words. It will call web service when the textbox value is changed and just
return the related item to the client. It will be more efficient.


--
Sincerely,

Vince Xu

Microsoft Online Support


==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.

MSDN Managed Newsgroup support offering is for non-urgent issues where an
initial response from the community or a Microsoft Support Engineer within
2 business day is acceptable. Please note that each follow up response may
take approximately 2 business days as the support professional working with
you may need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx
==================================================

 

[Mr. Arnold]

Hi there,

I'm writing web application that allow users to pick the providers from
dropdownlist. The providers list getting longer (>2000 names) and in the page
has other dropdownlists too. Sometime page need to re-load, it takes long
time to refresh the page. Have ideas to handle the dropdownlist (pull the
data from database)? Thanks.

Pull the data from the database and cache the data in memory. You load
the data from memory into the list to be used by all users of the
application.

 

[Vince Xu [MSFT]]

Hello,

Since I haven't seen your reply after I last posted my reply. Did you
resolve this?

--
Sincerely,

Vince Xu

Microsoft Online Support

--------------------
| Thread-Topic: Lookup Information
| thread-index: Acqfjfa5GhaOLUMxTki+gVQ4/8XPrQ==
| X-WBNR-Posting-Host: 165.189.6.46
| From: Madison <[email protected]>
| Subject: Lookup Information
| Date: Wed, 27 Jan 2010 12:19:01 -0800
| Lines: 7
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.4325
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl
microsoft.public.dotnet.framework.aspnet:96083
| NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| Hi there,
|
| I'm writing web application that allow users to pick the providers from
| dropdownlist. The providers list getting longer (>2000 names) and in the
page
| has other dropdownlists too. Sometime page need to re-load, it takes long
| time to refresh the page. Have ideas to handle the dropdownlist (pull the
| data from database)? Thanks.
|

 

[Guest]

Pull the data from the database and cache the data in memory. You load
the data from memory into the list to be used by all users of the
application.

A dropdown with more than 2000 names is not a good idea at all. No
matter if it's cached or not.