怎样将数据绑定到DropDownList?在线等候

[Truly]

我希望在页面载入时自动读取数据库Info中Area字段的记录作为下拉表MyDropDownList中的选项，如何实现？

[panyee]

读出DataSet

dropdownlist1.DataSource = ds.Tables[0].DefaultView;
dropdownlist1.DataTextFiled = "Area";
dropdownlist1.DataValueFiled = "Area";
dropdownlist1.DataBind();

[dongchuanlu]

MyDropDownList.DataSource=yourdatatable.DefaultView;;
MyDropDownList.DataTextField="Area";
MyDropDownList.DataValueField="Area";
MyDropDownList.DataBind();

[acewang]

将数据读出来绑定
DropDownList1.DataSource=ds.Tables[0].DefaultView;;
DropDownList1.DataTextField="Textxxx";
DropDownList1.DataValueField="valuexxx";
DropDownList1.DataBind();

[johnlenfu]

Dim DT As DataTable
Dim DR As DataRow
DT = New DataTable("DT")
DT.Columns.Add("key", GetType(String))
DT.Columns.Add("value", GetType(String))

DR = DT.NewRow
Dim strSQL As String = “your sql string ”
conn.Open()
Dim sqlDBcmd As SqlCommand = New SqlCommand
sqlDBcmd.Connection = conn
sqlDBcmd.CommandText = strSQL
Dim DBreader As SqlDataReader = sqlDBcmd.ExecuteReader()
While DBreader.Read()
DR(0) = DBreader.Item(0)
DR(1) = DBreader.Item(1)
DT.Rows.Add(DR)
DR = DT.NewRow
End While
DBreader.Close()

MyDropDownList.DataSource=DT
'to dongchuanlu(匡奇),这里无需.defaultview
MyDropDownList.DataTextField="key";
MyDropDownList.DataValueField="value";
MyDropDownList.DataBind();

[lwgj]

可以在属性栏里制定DataTextField与DataValueField绑定数据
然后
DropDownList1.DataSource=ds.Tables[0].DefaultView;;
DropDownList1.DataBind();
就可以了

[Truly]

谢谢各位，搞定了。给分

[mostice]

MyConnection8 = New SqlConnection(dbconn)
VoteItemStr = "SELECT * FROM play_voteItem"
VoteItemCmd = New SqlDataAdapter(VoteItemStr,MyConnection8)
DS8 = New DataSet()
VoteItemCmd.Fill(DS8,"items")
VoteItemDataList.DataSource = DS8.Tables("items").DefaultView
VoteItemDataList.DataBind()
MyConnection8.Close()

[Truly]

30,10,0,0,10,0
贴子回复次数大于跟给分次数 ？