如何将Dataset中某列数据赋给combox.item项？

Question

我想将dataset中login数据表的姓名列赋给combox的下拉菜单中？请问如何实现？

combox1.item.add(?)?应该如何填写？

Answer 1

Combobox1.Items.Add("字符串");

从DataSet.Tables[0-based index].Rows[0开始的索引][0开始的索引].ToString()中读取，循环添加即可。

---

If you think one reply solves your problem, please mark it as An Answer, if you think someone's reply helps you, please mark it as a Proposed Answer

Help by clicking：
Click here to donate your rice to the poor
Click to Donate
Click to feed Dogs & Cats

Answer 2

你好，你可以Bind comboBox 去 Dataset 其中一個 column，

ComboBox1.DataSource = ds.Tables(0)
ComboBox1.ValueMember = "id"
ComboBox1.DisplayMember = "name"

這裡也有一些code sample，你可以去參考一下
http://vb.net-informations.com/dataset/bind-combobox.htm
http://www.thescarms.com/dotnet/BindCombobox.aspx

---

大家一齊探討、學習和研究，謝謝！
MCSD, MCAD, MCSE+I, MCDBA, MCDST, MCSA, MCTS, MCITP, MCPD,
MCT, Microsoft Community Star(TW & HK),
Microsoft MVP for VB.NET since 2003
My MSMVP Blog