dropdownlist 动态绑定数据

  SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ElfinNetDBConnString"].ToString());
        string strSql = "select * from MarketingType";
        SqlDataAdapter adp = new SqlDataAdapter(strSql, Conn);
        Conn.Open();
        DataSet dt = new DataSet();
        adp.Fill(dt, "MyTable");

        ddlCardId.AppendDataBoundItems = true;
        ddlCardId.Items.Add(new ListItem("-- 请选择 --", "0"));
        ddlCardId.DataSource = dt.Tables["MyTable"].DefaultView;
        ddlCardId.DataTextField = "TypeTitle";
        ddlCardId.DataValueField = "TypeId";
      
        ddlCardId.DataBind();

        Conn.Close();