How do I bind 60000 rows to dropdown list in ASP.NET

Question

Hi All, While binding more than 600000 rows into the drop-down list then the page is hanged up. I have tried: DataTable dt; dt = GetDataTable(sqlQuery); lb.DataSource = dt; lb.DataTextField = Display; lb.DataValueField = Value; lb.DataBind();

Faisal Pathan · Answer

you should bind a limited number of records and on a scroll or click bind other limited records.

Subbarao A · Answer

Hi user experience and performance wise select the value from the drop-down with more than 600000 rows is not good.Try to autocomplete with dropdown

Madan Shekar · Answer

you can try this one . "Output Caching in MVC" We need caching in many different scenarios to improve the performance of an application. For example, you have an ASP.NET MVC application, which displays a list employees. Now when these records are retrieved from the database by executing a database query each and every time a user invokes the controller action it returns the Index view. Hence you can take advantage of the output cache to avoid executing a database query every time a user invokes the same controller action. In this case, the view will be retrieved from the cache instead of being regenerated from the controller action. Caching enables you to avoid performing redundant work on the server. [OutputCache(Duration = 60)] public ActionResult Index(){ var employees = from e in db.Employees orderby e.ID select e; return View(employees); } More info go through bellow link. https://www.tutorialspoint.com/asp.net_mvc/asp.net_mvc_caching.htm 2 option you can do one thing json zipping .

Dhanaji Chavan · Answer

Thanks, Rajnikant for the response. I know this is not a good way but this is client requirement.

Rajanikant Hawaldar · Answer

Hi Dhanaji Chavan, No good, did you ever get that to work without the .net frame work? I doubt it. That amount of data causes the browser's buffers to overflow and/or causes exessive traffic between the client and the webserver where the slow-up may initially begin. What you need is some kind of pager function for the drop down in which users can choose what part of the list to view. Better yet, why not just use a text box an search and make good use of the %like% fuction? https://forums.asp.net/t/1233859.aspx https://forums.asp.net/t/1229305.aspx Hope you understand Thanks