protected void LstAddState_SelectedIndexChanged(object sender, EventArgs e)
{
string state = LstAddState.SelectedItem.Value;
DataTable dt = tblcity(state);
LstAddCity.DataSource = dt;
LstAddCity.DataTextField = "city_name";
LstAddCity.DataValueField = "city_name";
LstAddCity.DataBind();
}
protected void BtnAddRst_Click(object sender, EventArgs e)
{
TxtAddName.Text = String.Empty;
TxtAddAddress.Text = String.Empty;
TxtAddContact.Text = String.Empty;
TxtAddDob.Text = String.Empty;
TxtAddEmail.Text = String.Empty;
TxtAddPin.Text = String.Empty;
LstAddCity.ClearSelection();
LstAddCountry.ClearSelection();
LstAddState.ClearSelection();
}
protected void Page_Load(object sender, EventArgs e)
{
Response.Cache.SetExpires(DateTime.Now.AddSeconds(-1));
Response.Cache.SetNoStore();
if (!Page.IsPostBack)
{
DataTable dt = tblCountry();
LstAddCountry.DataSource = dt;
LstAddCountry.DataTextField = "country_name";
LstAddCountry.DataValueField = "country_name";
LstAddCountry.DataBind();
string count = LstAddCountry.SelectedValue;
DataTable dt1 = tblstate(count);
LstAddState.DataSource = dt1;
LstAddState.DataBind();
DataTable dt2 = tblcity(LstAddState.SelectedValue);
LstAddCity.DataSource = dt2;
LstAddCity.DataBind();
}
}