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();
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();