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

Dhanaji Chavan

7y1.2k.NET

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();

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Faisal Pathan7y ago
you should bind a limited number of records and on a scroll or click bind other limited records.
Subbarao A7y ago
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 Shekar7y ago
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 Chavan7y ago
Thanks, Rajnikant for the response.
I know this is not a good way but this is client requirement.
Rajanikant Hawaldar7y ago
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