如何添加静态项和结果数据绑定到 DropDownList 控件

方法一:

1. using System;
2. using System.Collections;
3. using System.ComponentModel;
4. using System.Data;
5. using System.Drawing;
6. using System.Web;
7. using System.Web.SessionState;
8. using System.Web.UI;
9. using System.Web.UI.WebControls;
10. using System.Web.UI.HtmlControls;
11. using System.Data.SqlClient;
15. private void Page_Load(object sender, System.EventArgs e)
16.         {
17.             if(!IsPostBack)
18.             {
19.                 SqlConnection myConn = new SqlConnection(
20.                     "Server=localhost;Database=Pubs;Integrated Security=SSPI");
21.                 SqlCommand myCmd = new SqlCommand(
22.                     "SELECT au_id, au_lname FROM Authors", myConn);
23.                 myConn.Open();
24.                 SqlDataReader myReader = myCmd.ExecuteReader();
25.             
26.                 //Set up the data binding.
27.                 AuthorList.DataSource = myReader;
28.                 AuthorList.DataTextField = "au_lname";
29.                 AuthorList.DataValueField = "au_id";
30.                 AuthorList.DataBind();
31.             
32.                 //Close the connection.
33.                 myConn.Close();
34.                 myReader.Close();
36.                 //Add the item at the first position.
37.                 AuthorList.Items.Insert(0, "<-- Select -->");
38.                 
39.             }
41.         }

 

方法二:

 

1. string sql="select 字段名 from 表 ";
2.            SqlCommand cmd = new SqlCommand(sql,conn);
3.            SqlDataReader dr=cmd.ExecuteReader();
4.            DropDownList1.DataSource=dr;
5.            DropDownList1.DataBind();
6.            dr.Close();
7.            if (DropDownList1.Items.Count==0)
8.               {
9.                  DropDownList1.Items.Add(new ListItem("请选择省",""));
10.               }
11.            else{
12.                  DropDownList1.Items.Insert(0,new ListItem("请选择省",""));
13.                }

 

 

自己看着办,自由发挥,呵呵!