i have a dropdown of country.i want to get selected country id and on its behalf want to bid state drop down
my Controller code is:
DataTable dt = new DataTable();
dt = cs.GetCountry();
List<SelectListItem> iliSLI = new List<SelectListItem>();
if (dt.Rows.Count > 0)
{
for (Int32 i = 0; i <dt.Rows.Count; i++)
{
SelectListItem sli = new SelectListItem();
sli.Text = dt.Rows[i]["Name"].ToString();
sli.Value = dt.Rows[i]["id"].ToString();
sli.Selected = true;
iliSLI.Add(sli);
}
}
ViewData["SecretQuestion"] = iliSLI;
view code is:
<%= Html.DropDownList("SecretQuestion") %>
Models code is:
public DataTable GetCountry()
{
SqlConnection con;
con = new SqlConnection( ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlDataAdapter adp = new SqlDataAdapter("select * from CountryTable", con);
DataTable dt = new DataTable();
adp.Fill(dt);
return dt;
}