将DropDownList控件的SelectedValue值设置为一个从数据库取出的值

Question

  string bb = reader["bigclass"].ToString().Trim();
  DropDownList1.SelectedValue=bb;
空格一定要去除
                

Answer 1

string name=sdr[0].ToString().Trim();

Answer 2

循环判断DropDownList.Item[i]索引值是否等于数据库里的值
代码：
     for (int i = 0; i < ddlPublisher.Items.Count; i++)
                {
                    if (ddlPublisher.Items[i].Value.Equals(book.PublisherId.ToString()))                                                  {
                        this.ddlPublisher.SelectedValue = this.ddlPublisher.Items[i].Value.Trim();
                        this.ddlPublisher.Text = this.ddlPublisher.Items[i].Text.Trim();
                        break;
                    }
                }
//如果DropDownList.Items[i]的值 等于数据库里book.PublisherId的值，那么条件成功

Answer 3

合理制定 DisplayMember 和 ValueMember 然后 确定 数据库的 字段是不是 ValueMember 的值 然后用 SelectedValue