DropDownList绑定数据

动态绑定方法一：动态绑定数据库中的字段。

SqlConnection conn = UtilitySqlClass.OperateDataBase.ReturnConn();string strSQL = "select * from CompanyType";SqlDataAdapter ada = new SqlDataAdapter(strSQL, conn);DataSet ds = new DataSet();ada.Fill(ds, "CompanyType");DropDownList1.DataSource = ds.Tables["CompanyType"].DefaultView;DropDownList1.DataValueField = ds.Tables["CompanyType"].Columns[1].ColumnName;DropDownList1.DataTextField = ds.Tables["CompanyType"].Columns[1].ColumnName;DropDownList1.DataBind();ds.Dispose();

动态绑定方法二：利用DropDownList.Items.Add方法。

protected void Page_Load(object sender, EventArgs e){if (!IsPostBack){SqlConnection conn = UtilitySqlClass.OperateDataBase.ReturnConn();try{conn.Open();this.DropDownList1.Items.Add("");string strSQL = "select CompanyType from CompanyType";SqlCommand com = new SqlCommand(strSQL, conn);SqlDataReader dr = com.ExecuteReader();while (dr.Read()){this.DropDownList1.Items.Add(dr["CompanyType"].ToString());}}catch (Exception ex){Response.Write("<scirpt>alert('" + ex.Message.ToString() + "')</script>");}finally{conn.Close();}}}