DropDownList 如何顯示出數據庫中的數據

Question

your tables["Summary"] must like:
  strValue,strText.then:
CimPmis.PurchasingDB purlist= new CimPmis.PurchasingDB(GetConnString());
DataView myDV = purlist.GetPurchasing().Tables["Summary"].DefaultView;
DropList.DataSource=myDV;
DropList.DataBind();
orCimPmis.PurchasingDB purlist= new CimPmis.PurchasingDB(GetConnString());
DataTable myDV = purlist.GetPurchasing().Tables["Summary"].DefaultView;//modify the interfac
                       
foreach(DataRow dr in myDV.Rows)
{
ListItem curItem=new ListItem(); 
curItem.Value =dr[1].ToString ();
curItem.Text =dr[0].ToString ();
DropList.Items.Add(curItem);
}
good luck

Answer 1

使用数据绑定：
this.comboBox1.DataSource =dt;
this.comboBox1.DisplayMember = "customerID"
this.comboBox1.ValueMember = "custoerId"