fetch state and city from database and set in cascading ddl

Question

When user will login first time then user will fill his profile details and when he login next time then all the filled details will be shown to the user by fetching from database and user can update particular value.. but value of state and city is being fetched in code behind but it is not setting the value in dropdownlist. why?

help me please.

Priyanka Jain · Answer

You can bind it in view like below code "DropDownList1" runat= "server" DataSourceID= "SqlDataSource1" DataTextField= "Test" DataValueField= "AutoId" SelectedIndex=' ' > > You just need to pass your dropdown value to view using viewstate or other technique like below, ViewState[ "value" ] = dr[ "state" ].toString();

Brajesh Kumar · Answer

Hi You can go through following snippet ,Hope it will work for you https://www.aspsnippets.com/Articles/Cascading-DropDownList-for-CountryStateCity-in-ASPNet.aspx https://www.c-sharpcorner.com/UploadFile/8a67c0/cascading-dropdownlist-in-Asp-Net/ https://www.c-sharpcorner.com/UploadFile/009464/cascading-one-dropdownlist-with-other-dropdownlist-in-asp-ne/ Happy Coding

Priyanka Jain · Answer

Try using SelectedIndex or SelectedValue property for your solution

Itsme · Answer

Not Working System.FormatException: 'Input string was not in a correct format.'

Itsme · Answer

Thanks But not working giving me error Object reference not set to an instance of an object.

Amit Mohanty · Answer

Hey try this in your code State.ClearSelection(); State.Items.FindByText(dr[ "State" ].ToString()).Selected = true ; city.ClearSelection(); city.Items.FindByText(dr[ "City" ].ToString()).Selected = true ;

Itsme · Answer

It is giving me error-- Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control.

Priyanka Jain · Answer

You need to pass your values on View and bind it to the dropdown using Selected value as below, "state" runat= "server" DataSourceID= "sqlDatasource1" DataTextField= "statename" DataValueField= "state_key" SelectedValue= ' ' Enabled= "false" > here statekey_id should be the id value which is return by database.

Itsme · Answer

Thanks ... But not working.

Priyanka Jain · Answer

Try using, state.SelectedIndex = state.Items.IndexOf( state.Items.FindByText( dr[ "stateText" ].toString()));

Itsme · Answer

I have tried Selected value but it is giving me error and in selected index I dont know how to implement it.

fetch state and city from database and set in cascading ddl

Answers (11)