Category: ASP.NET

28 Mar 2019 17:16

Joined:	14/05/2014
Level:	Silver
Points:	101

Points:	3

Page stuck while large amount of data bind in drop down list c# (Web)

Hello

I have created one web application and facing problem of bind the large amount of data in drop-down ( 15000 rows )

Can you please help me what are the alternative solution for the same

PS : We do not want to replace c# drop down because its selected value used in whole application

Thanks in advance

#769858

02 Apr 2019 12:49

Joined:	06/04/2012
Level:	Gold
Points:	4230

Points:	3

Hi Bhavik,

First of all why do you use Drop down for 15K items.

Based on my experience, I have had drop down lists with thousands of options and it wasn't ideal though because who wants to scroll through all of those? This is why an auto-complete of some type is more desirable for numerous reasons, especially at the end user's experience. You can use textbox and auto fill it when user enters any input. That's the alternative of it.

Regards,
Nirav Lalan
DNS Gold Member
"If you can dream it, you can do it."

#769874

02 May 2019 11:36

Joined:	06/10/2010
Level:	Gold
Points:	634

Points:	2

Hi,

For DropDownlist 15000 rows its large amount of Data. It will affect performance. you can use textbox auto fill options.

https://stackoverflow.com/questions/1357853/autocomplete-textbox-control

Gothrough this link its usefull for your requirement.

Regards
Sriram.R

#769946

05 Aug 2019 12:15

Joined:	28/09/2005
Level:	Gold
Points:	637

Points:	3

I suggest to use 2 approaches to achieve the performance

1 .fill the drop down values on drop down scrolling event using jquery
2. make seperate Ajax hit after page load and fill the values

i think , 1st approach is good and it will avoid the performance issue and only loads when user scroll down the drop down values and it s dynamic content loading. refer below link for more details

https://stackoverflow.com/questions/21302989/asp-net-mvc-dropdownlist-add-items-on-scrolling

Thanks!
B.Ramana Reddy

Page stuck while large amount of data bind in drop down list c# (Web)

About dotnetspider.com

Quick Links

General

Services