fetch state and city from database and set in cascading ddl

Itsme

7y1.1k.NET

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.

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Itsme7y ago
Not Working

System.FormatException: 'Input string was not in a correct format.'
Priyanka Jain7y ago
You can bind it in view like below code
"DropDownList1" runat="server" DataSourceID="SqlDataSource1" DataTextField="Test" DataValueField="AutoId" SelectedIndex='<%# (Convert.ToInt32(ViewState["value"])) %>'>
                 << Select >>
You just need to pass your dropdown value to view using viewstate or other technique like below,
ViewState["value"] = dr["state"].toString();
Itsme7y ago
Thanks But not working giving me error

Object reference not set to an instance of an object.
Amit Mohanty7y ago
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;
Brajesh Kumar7y ago
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
Itsme7y ago
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 Jain7y ago
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='<%# Eval("statekey_Id").ToString() %>' Enabled="false">

here statekey_id should be the id value which is return by database.
Itsme7y ago
Thanks ... But not working.
Priyanka Jain7y ago
Try using,
state.SelectedIndex = state.Items.IndexOf( state.Items.FindByText( dr["stateText"].toString()));
Itsme7y ago
I have tried Selected value but it is giving me error and in selected index I dont know how to implement it.
Priyanka Jain7y ago
Try using SelectedIndex or SelectedValue property for your solution