SqlConnection conn = new SqlConnection(妳的sql連接串);
DataSet ds = new DataSet();
try
{
conn.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from datafile", conn);
da.Fill(ds);
}
catch
{
}
finally
{
conn.Close();
}
DropDownList1.DataSource = ds;
DropDownList1.DataTextField = "城市";
DropDownList1.DataValueField = "天氣";
DropDownList1.DataBind();
在DropDownList1的DropDownList1_SelectedIndexChanged 事件裏寫
TextBox1.Text = DropDownList1.SelectedValue.ToString();
當然 妳也可以取DropDownList1的value 或text 然後再從數據庫取 壹對壹的話著樣相對簡單點