Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Lookup Information

Reply
Thread Tools

Lookup Information

 
 
Madison
Guest
Posts: n/a
 
      01-27-2010
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.
 
Reply With Quote
 
 
 
 
Alexey Smirnov
Guest
Posts: n/a
 
      01-27-2010
On Jan 27, 9:19*pm, Madison <(E-Mail Removed)> wrote:
> 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.
 
Reply With Quote
 
 
 
 
Vince Xu [MSFT]
Guest
Posts: n/a
 
      01-28-2010
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/AjaxControlT...e/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/subs...#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/subs.../aa948874.aspx
==================================================

 
Reply With Quote
 
Mr. Arnold
Guest
Posts: n/a
 
      01-28-2010
Madison wrote:
> 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.
 
Reply With Quote
 
Vince Xu [MSFT]
Guest
Posts: n/a
 
      02-02-2010

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 <(E-Mail Removed)>
| Subject: Lookup Information
| Date: Wed, 27 Jan 2010 12:19:01 -0800
| Lines: 7
| Message-ID: <(E-Mail Removed)>
| 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.
|



 
Reply With Quote
 
Alexey Smirnov
Guest
Posts: n/a
 
      02-02-2010
On Jan 28, 5:07*am, "Mr. Arnold" <(E-Mail Removed)> wrote:
> Madison wrote:
> > 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.


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

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
signer information does not match signer information of other classes in the same pac lerenard001 Java 0 07-07-2008 03:46 PM
Information technology is incomplete without information security alannis.albert@googlemail.com Computer Support 0 04-14-2008 06:42 AM
More Information than just IIS Log Information subrato ASP .Net 8 03-14-2006 09:59 PM
signer information does not match signer information of other classes in the same package clercmedia Java 2 12-09-2005 03:14 PM
strange information from asp.net trace / getting performance information using WebRequest and StreamReader z. f. ASP .Net 0 02-03-2005 11:23 AM



Advertisments