Dhanaji Chavan

Dhanaji Chavan

  • 1.8k
  • 6
  • 161

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;
lb.DataBind();

Answers (5)