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();
     }
 }