<div>
<asp:DropDownList ID="ddlCities" runat="server"
onselectedindexchanged="ddlCities_SelectedIndexChanged" AutoPostBack="true"></asp:DropDownList>
<asp:DropDownList ID="ddlEmployees" runat="server"></asp:DropDownList>
</div>
--------
private DataTable Employees
{
get
{
DataTable dt = new DataTable();
dt.Columns.Add("Id");
dt.Columns.Add("Name");
dt.Columns.Add("City");
dt.Rows.Add("1", "RkHirpara", "Mumbai");
dt.Rows.Add("2", "Mudassar Khan", "Mumbai");
dt.Rows.Add("3", "AashuSingh", "Mumbai");
dt.Rows.Add("4", "Dilip", "Hyd");
dt.Rows.Add("5", "Ramki", "Hyd");
dt.Rows.Add("6", "Mayur Rana", "Pune");
dt.Rows.Add("7", "Manoj Chauhan", "Pune");
dt.Rows.Add("8", "Imran Khan", "Pune");
return dt;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if(!this.IsPostBack)
{
var cities = (from DataRow dr in Employees.Rows
select dr["City"]).Distinct();
ddlCities.DataSource = cities;
ddlCities.DataBind();
}
}
protected void ddlCities_SelectedIndexChanged(object sender, EventArgs e)
{
string city = ddlCities.SelectedItem.Value;
DataTable tbl = (from DataRow dr in Employees.Rows
where dr["city"].ToString() == city
select dr).CopyToDataTable();
ddlEmployees.DataSource = tbl;
ddlEmployees.DataValueField = "Id";
ddlEmployees.DataTextField = "Name";
ddlEmployees.DataBind();
}
Thanks and Regards,
Rk_Hirpara