You didn't call DataBind()
after setting datasource.
protected void Ddl_SelectedIndexChanged(object sender, EventArgs e) {
String sqlQuery="select SM.StateId,StateName From StateMast SM,CityMast CM where CM.StateId=SM.StateId AND CM.CItyId='"+ Convert.ToInt16(DdlCity.SelectedValue.ToString())+"'";
DdlState.DataSource = cls.Select(sqlQuery);
DdlState.DataTextField = "StateName";
DdlState.DataValueField = "StateId";
DdlState.DataBind();
}
EDIT (with validator):
ASPX:
<body>
<form id="form1" runat="server">
<div>
<asp:DropDownList ID="ddlCity" runat="server" AutoPostBack="true"
onselectedindexchanged="ddlCity_SelectedIndexChanged">
</asp:DropDownList>
<asp:RequiredFieldValidator ID="rfvCity" runat="server" ErrorMessage="City is required" ControlToValidate="ddlCity" InitialValue="0" Display="Dynamic"></asp:RequiredFieldValidator>
<br />
<asp:DropDownList ID="ddlState" runat="server" AutoPostBack="true">
</asp:DropDownList>
<asp:Button ID="Button1" runat="server" Text="Button" />
</div>
</form>
</body>
.cs:
public partial class ChildDDL : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack)
return;
ddlCity.Items.Add(new ListItem("Select One", "0"));
ddlCity.Items.Add(new ListItem("City 1", "1"));
ddlCity.Items.Add(new ListItem("City 2", "2"));
ddlCity.Items.Add(new ListItem("City 3", "3"));
List<State> lstState = new List<State>();
lstState.Add(new State() { StateID = 1, StateName = "State 1", CityID = 1 });
lstState.Add(new State() { StateID = 2, StateName = "State 2", CityID = 1 });
lstState.Add(new State() { StateID = 3, StateName = "State 3", CityID = 1 });
lstState.Add(new State() { StateID = 4, StateName = "State 4", CityID = 2 });
lstState.Add(new State() { StateID = 5, StateName = "State 5", CityID = 2 });
lstState.Add(new State() { StateID = 6, StateName = "State 6", CityID = 2 });
lstState.Add(new State() { StateID = 7, StateName = "State 7", CityID = 3 });
lstState.Add(new State() { StateID = 8, StateName = "State 8", CityID = 3 });
Session["lstState"] = lstState;
}
protected void ddlCity_SelectedIndexChanged(object sender, EventArgs e)
{
List<State> lstState = (List<State>)Session["lstState"];
ddlState.DataSource = lstState
.Where(state => state.CityID == Convert.ToInt32(ddlCity.SelectedValue)); ;
ddlState.DataTextField = "StateName";
ddlState.DataValueField = "StateID";
ddlState.DataBind();
}
public class State
{
public int StateID { get; set; }
public string StateName { get; set; }
public int CityID { get; set; }
}
}
The page works well with validator.