Пример #1
0
        public void BindCity()
        {
            int StateID;

            int.TryParse(DrpState.SelectedValue, out StateID);

            DataTable dtCity = HRMWcfService1.BALDropDownList.CityList(StateID);

            DrpCity.DataSource     = dtCity;
            DrpCity.DataTextField  = "CityName";
            DrpCity.DataValueField = "CityID";
            DrpCity.DataBind();
            DrpCity.Items.Insert(0, new ListItem("---Select City---"));
        }
Пример #2
0
 protected void DrpState_SelectedIndexChanged(object sender, EventArgs e)
 {
     if (DrpState.Text.Length > 0)
     {
         DataTable dt = MDC.getDataTable("select distinct City from RTO where State='" + DrpState.Text + "'");
         if (dt.Rows.Count > 0)
         {
             DrpCity.DataSource     = dt;
             DrpCity.DataTextField  = "City";
             DrpCity.DataValueField = "City";
             DrpCity.DataBind();
         }
     }
 }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            con.Open();
            SqlCommand    cmd = new SqlCommand("select * from city", con);
            SqlDataReader rdr = cmd.ExecuteReader();

            DrpCity.DataSource     = rdr;
            DrpCity.DataTextField  = "Name";
            DrpCity.DataValueField = "id";
            DrpCity.DataBind();
            rdr.Close();
        }
    }