Dhanaji Chavan

Dhanaji Chavan

  • 1.9k
  • 6
  • 290

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

Jul 9 2019 12:46 AM
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;

Brought to you by: JavaScript SDK for Bold BI dashboard and analytics embedding. Free trial.

Answers (5)