c# ComboBox 控件 用数据库填充 绑定

省市选择 练习题： 用DataSet方法。

using(SqlConnection conn = new SqlConnection(connStr))
            {
                conn.Open();
                /* 用DattaSet方法  */
                using(SqlDataAdapter ad = new SqlDataAdapter("Select * from promary order by ProID asc",conn))
                {
                    using(DataSet ds = new DataSet())
                    {
                        ad.Fill(ds, "promary");
                        cbProvince.DataSource = ds.Tables[0];
                        cbProvince.DisplayMember = "ProName";
                        cbProvince.ValueMember = "ProID";
                    }
                }
               
             }