c#查询数据库表某一列··怎么添加到下拉列表去···

2025-01-21 06:09:25

推荐回答（3个）

回答（1）：

SqlConnection con = new SqlConnection("Data Source=LIXIAOPING-PC\\SQLSERVER2000;Initial Catalog=userdb;User ID=sa;Password=880905");
SqlCommand cmd = new SqlCommand("select book_name from bookinfo",con);
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(ds);
this.comType.DataSource = ds.Tables[0];
this.comType.DisplayMember = "book_name";
this.comType.ValueMember = ""; //System.Data.DataRowViewcomboBox1.DataSource = dataSet1.Tables["Suppliers"];
//comboBox1.DisplayMember = "数据表列名";
//comboBox1.valueMember = "列名对应的值";

上面是WinForm下面是WebFormSqlConnection con = new SqlConnection("Data Source=LIXIAOPING-PC\\SQLSERVER2000;Initial Catalog=userdb;User ID=sa;Password=880905");
SqlCommand cmd = new SqlCommand("select book_name from bookinfo", con);
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(ds);
this.ddlBookName.DataSource = ds.Tables[0];
this.ddlBookName.DataTextField = "book_name";
this.ddlBookName.DataValueField = "";
this.ddlBookName.DataBind();

回答（2）：

查询的先存一个表中，然后用combox的items的add方法就可以啊！

回答（3）：

把 result 赋值给 select 具体怎么搞不记得了