dropdownlist遇到一个很奇葩的错误

qile3897 2013-12-30 09:08:59

错误提示是 “ddlXCity”有一个无效 SelectedValue，因为它不在项目列表中。
参数名: value
出问题的代码

        

            DataSet ds = WebPubDB.DbHelper.Query("select organid,organname,organupid,schoolcities from dc_organ where organid=" + yixinUtils.GetSchoolID(openid, apid));   //根据openid，apid得到学校所在地市，区县，及学校id

            ddlCity.SelectedValue = ds.Tables[0].Rows[0][3].ToString();

            ddlCity_SelectedIndexChanged(this, null);

            ddlXCity.SelectedValue = ds.Tables[0].Rows[0][2].ToString();

            ddlXCity_SelectedIndexChanged(this, null);

            ddlSchool.SelectedValue = (ds.Tables[0].Rows[0][0].ToString());

            //绑定

看代码，三级dropdownlist 联动



        //绑定地市 运行上面那段代码之前，先执行下这个

        protected void bind()

        {

            DataSet ds = WebPubDB.DbHelper.Query("select OrganID,OrganFullName from dc_organ where organtypename='地市' order by organname");

            this.ddlCity.DataSource = ds.Tables[0]; 

            this.ddlCity.DataTextField = "OrganFullName";

            this.ddlCity.DataValueField = "OrganID";

            this.ddlCity.DataBind();

            ddlCity.Items.Add(new ListItem("请选择", "-1"));

            ddlCity.SelectedValue = "-1";

            ddlCity_SelectedIndexChanged(this, null);

        }

        //地市改变区县跟着改变

        protected void ddlCity_SelectedIndexChanged(object sender, EventArgs e)

        {

            DataSet ds = WebPubDB.DbHelper.Query("select qxno,qxname from dc_qxinfo where organupid='" + ddlCity.SelectedValue + "' order by qxname");

            ddlXCity.Items.Clear();

            ddlXCity.DataSource = ds.Tables[0];

            ddlXCity.DataTextField = "qxname";

            ddlXCity.DataValueField = "qxno";

            ddlXCity.DataBind();

            ddlXCity.Items.Add(new ListItem("请选择", "-1"));

            ddlXCity.SelectedValue = "-1";

            ddlXCity_SelectedIndexChanged(this, null);



        }

        //区县改变学校跟着改变

        protected void ddlXCity_SelectedIndexChanged(object sender, EventArgs e)

        {

            DataSet ds = WebPubDB.DbHelper.Query("select OrganID,OrganName from dc_organ where organtypename='学校' and  organupid='" + ddlXCity.SelectedValue + "' order by organname");

            ddlSchool.Items.Clear();

            ddlSchool.DataSource = ds.Tables[0];

            ddlSchool.DataTextField = "OrganName";

            ddlSchool.DataValueField = "OrganID";

            ddlSchool.DataBind();

            ddlSchool.Items.Add(new ListItem("请选择", "-1"));

            ddlSchool.SelectedValue = "-1";

        }

我将上面的代码改成下面这样不调用bind，和联动就没问题了



            DataSet ds = WebPubDB.DbHelper.Query("select organid,organname,organupid,schoolcities from dc_organ where organid=" + yixinUtils.GetSchoolID(openid, apid));

            DataSet dsd = WebPubDB.DbHelper.Query("select OrganID,OrganFullName from dc_organ where organtypename='地市' order by organname");

            this.ddlCity.DataSource = dsd.Tables[0];

            this.ddlCity.DataTextField = "OrganFullName";

            this.ddlCity.DataValueField = "OrganID";

            this.ddlCity.DataBind();

            ddlCity.SelectedValue = ds.Tables[0].Rows[0][3].ToString();

            DataSet dsx = WebPubDB.DbHelper.Query("select qxno,qxname from dc_qxinfo where organupid='" + ddlCity.SelectedValue + "' order by qxname");

            ddlXCity.Items.Clear();

            ddlXCity.DataSource = dsx.Tables[0];

            ddlXCity.DataTextField = "qxname";

            ddlXCity.DataValueField = "qxno";

            ddlXCity.DataBind();

            ddlXCity.SelectedValue = ds.Tables[0].Rows[0][2].ToString();

            DataSet dss = WebPubDB.DbHelper.Query("select OrganID,OrganName from dc_organ where organtypename='学校' and  organupid='" + ddlXCity.SelectedValue + "' order by organname");

            txtname.Text = yixinUtils.GetTel(openid, apid);

            ddlSchool.Items.Clear();

            ddlSchool.DataSource = dss.Tables[0];

            ddlSchool.DataTextField = "OrganName";

            ddlSchool.DataValueField = "OrganID";

            ddlSchool.DataBind();

            ddlSchool.SelectedValue = ds.Tables[0].Rows[0][0].ToString();