省市县三级联动（第三种方法）的优化

namespace 省市县三级联动
{
    public partial class 优化 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                Province();
            }
        }
        private void LoadData(string id, DropDownList ddl)
        {
            string constr = ConfigurationManager.ConnectionStrings["ConStr"].ConnectionString;
            SqlConnection conn = new SqlConnection(constr);
            conn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = "SELECT A_Id,A_Name FROM T_Arear WHERE A_ParentId=@pid ORDER BY A_Id ";
            cmd.Parameters.AddWithValue("@pid",id);
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            adapter.Fill(dt);
            cmd.Dispose();
            conn.Dispose();

            ddl.DataSource = dt;
            ddl.DataTextField = "A_Name";
            ddl.DataValueField = "A_Id";
            ddl.DataBind();
            if(id=="0")
            {
                ListItem item = new ListItem("---请选择---","0");
                ddl.Items.Insert(0,item);
            }
        }
        private void Province()
        {
            LoadData("0",this.ddlProvince);
        }

        protected void ddlProvince_SelectedIndexChanged1(object sender, EventArgs e)
        {
            string id = this.ddlProvince.SelectedItem.Value;
            if (id != "0")
            {
                LoadData(id, this.ddlCity);
                string sid = ddlCity.SelectedItem.Value;
                LoadData(sid, this.ddlArear);
            }
            else
            {
                ddlCity.Items.Clear();
                ddlArear.Items.Clear();
            }
        }

        protected void ddlCity_SelectedIndexChanged1(object sender, EventArgs e)
        {
            string id2 = this.ddlCity.SelectedItem.Value;
            LoadData(id2,ddlArear);
        }
    }
}