Dropdownlist Performance issue while binding more than 15000

Question

Hello While binding more than 15000 rows into dropdownlist then page is hanged up. I am using the mentioned below code for this. ddlList1.DataSource = ds.Tables[0]; ddlList1.DataTextField = EmpID; ddlList1.DataValueField = EmpName; ddlList1.DataBind(); Can anyone please help me for trouble out this problem.

Riyaz Akhtar · Answer

I am agree with Mr. Raj. Loading 1500 record in dropdownlist will cause performance issue. No user wants to select from such huge record.s According to me you can use autocomplete see some example in below link http://www.aspdotnet-suresh.com/2012/09/9-top-ajax-jquery-autocomplete.html OR Dont use dropdownlist use readonly textbox for employe and give a option(button/iamge) to select the employee . Open a popup page and use grid with search emplyee functionality. give option here to select the employee.

Iftikar Hussain · Answer

Hi It is not a good idea to load so many records into dropdown. Even though it loads it will be difficult to user to select particular value from the dropdown. I suggest you can use autocomplete ajax textbox. Please refer the below link http://www.asp.net/ajaxLibrary/AjaxControlToolkitSampleSite/AutoComplete/AutoComplete.aspx http://www.asp.net/ajaxlibrary/act_autocomplete.ashx Regards Iftikar

Raj Bandi · Answer

Hi Chetan 15000 items in a dropdown?. My advice is not to load so many items in it at a time. It degrades browser performance. Try to use load on demand technique like an auto complete textbox from AjaxControlToolKit. or Build your own control that loads subset of items from server on some scroll change event (ajax ) Cheers Raj