怎么数据库连接实现和DropDownList一样的效果

Question

SqlConnection conn = new SqlConnection("Server=.;Database=master;Integrated Security=SSPI");
            SqlDataAdapter da = new SqlDataAdapter("SELECT *FROM TEST", conn);
            DataSet ds = new DataSet();
            da.Fill(ds);                      cboshow.DataSource = ds.Tables[0]; 
            cboshow.DisplayMember = "B";        
     cboshow.ValueMember = "A";

Answer 1

SqlConnection con = new sqlconnection("server=.;database=数据库名;uid=sa;pwd=;");
        con.Open();
        SqlCommand cmd =new SqlCommand("select part from yiyuan", con);
   //yiyuan表中存的是你要在DropDownList中显示的数据；
        SqlDataReader sdr=cmd.ExecuteReader();
        this.ddlSSFQ.DataSource=sdr;
        this.ddlSSFQ.DataTextField="part";
        this.ddlSSFQ.DataValueField="part";
        this.ddlSSFQ.DataBind();不知道是否是要这样的答案？