dropdownlist 动态绑定数据

SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ElfinNetDBConnString"].ToString());<br> string strSql = "select * from MarketingType";<br> SqlDataAdapter adp = new SqlDataAdapter(strSql, Conn);<br> Conn.Open();<br> DataSet dt = new DataSet();<br> adp.Fill(dt, "MyTable");<br><br> ddlCardId.AppendDataBoundItems = true;<br> ddlCardId.Items.Add(new ListItem("-- 请选择 --", "0"));<br> ddlCardId.DataSource = dt.Tables["MyTable"].DefaultView;<br> ddlCardId.DataTextField = "TypeTitle";<br> ddlCardId.DataValueField = "TypeId";<br><br> ddlCardId.DataBind();<br><br> Conn.Close();