Question

下拉框如何绑定数据库的列名

我想用一个下拉框把数据库的某个表的每一列都绑定到下拉框里

Answer 1

winform comboBox 绑定数据方法

//C#

private void BindComboBox()
{
comboBox1.DataSource = dataSet1.Tables["Suppliers"];
comboBox1.DisplayMember = "数据表列名";
comboBox1.valueMember = "列名对应的值";
}

//VB

Private Sub BindComboBox()
ComboBox1.DataSource = DataSet1.Tables("Suppliers")
ComboBox1.DisplayMember = "数据表列名"
ComboBox1.DisplayMember = "列名对应的值"
End Sub

webform DropDownList 绑定方法：

private void BindDropDownList1()
{
DataTable dt = dataSet1.Tables["Suppliers"];
this.DropDownList1.DataSource = dt;
this.DropDownList1.DataTextField = "name";
this.DropDownList1.DataValueField = "fid";
this.DropDownList1.DataBind();
｝

Answer 2

读取数据库的一列数据，
通过循环一个一个加入到下拉框中