Hi,
I followed the below article nad made the sample on my project.
http://www.aspsnippets.com/Articles/AJAX-Cascading-DropDownList-using-jQuery-in-ASP.Net.aspx
Intially i didn't realize i will get 9000 recors of my second dropdown based on first dropdown selection.
the code on the above link work perect for the smaller set of records.
Here is my situation,
consider i have company dropdown and employee dropdown.
based on the company dropdown selection, the employee dropdwon will be filled. for one of my company i have 10000 empolyees and it takes huge time(i was waiting for 5 + min) and not even fills the data on employee dropdown. My table has index and i checked my query as well. if i execute my query, it works perfectly in milli seconds. but when it comes to front end, it's not even filling the data. for samller employees it works.
Not sure it is because of copying the data from datatable to arraylist?
Any suggestions please....