How to Improving performance of nested dropdownlist in asp.net

Question

I am having nested dropdown list in my page, based on the selection in any of the dropdown list other dropdowns will also be changed(post back is handled in page load),But this affects the performance a lot .
I have also use update panel but i think it is not run properly.
Is there any work around to improve the performance??,

Help me with this,Thanks

Sukesh Marla · Answer

Okk i got it now You might be maintaining some kind of Huge ViewState Data Then it happens. same code works in other page but not in this means this is the problem Try to minimize Viewstate you are maintaining Check this is correct answer if it helepd

Tushar Pawar · Answer

Hello sir good morning Here is my db code in LINQ and districts my be 20+ and when i write same code for dropdownlist on another page it work fine. public IList GetAllDistrictByStateId(int stateId) { return db.Districts.OrderBy(o => o.DistrictName).Where(o => o.StateId==stateId).ToList(); }

Sukesh Marla · Answer

Is this is the only code How many Districts you are gettig in result By be your database script is slow if yes try to optimize that. Check this is correct answer if it helped

Tushar Pawar · Answer

hi Sukesh Thanks for quick reply.... and my is here but it takes time when i publish my website on server.. OnSelectedIndexChanged=ddlPatientState_SelectedIndexChanged TabIndex=11> ControlToValidate=ddlPatientState Display=Dynamic ErrorMessage=Please Select State ForeColor=Red InitialValue=-1 SetFocusOnError=true ToolTip=Please Select State> -------------------------------------------------------------------------------------------- protected void ddlPatientState_SelectedIndexChanged(object sender EventArgs e) { ddlPatientDistrict.Items.Clear(); ddlPatientDistrict.DataSource = objDataAccess.GetAllDistrictByStateId(Convert.ToInt32(ddlPatientState.SelectedValue)); ddlPatientDistrict.DataTextField = DistrictName; ddlPatientDistrict.DataValueField = DistrictId; ddlPatientDistrict.DataBind(); ddlPatientDistrict.Items.Insert(0 new ListItem(Please Select -1)); ddlPatientTahsil.Items.Clear(); ddlPatientTahsil.Items.Insert(0 new ListItem(Please Select -1)); }

Sukesh Marla · Answer

Update Panel is more preferred Let me knw what error ur getting Go throgh this article to understand how to use updatepanel http://www.c-sharpcorner.com/UploadFile/SukeshMarla/ajax-asynchronous-javascript-and-xml/ Check this is correct answer if it helped