SqlConnection conn = DBLink.GetConnection();
conn.Open();
SqlCommand cmd = new SqlCommand("select TypeID,TypeName from ArticleType", conn);
if (ddltype.Items.Count != 0) //如果DropDownList里面原有项目则清空
ddltype.Items.Clear();
SqlDataReader sdr = cmd.ExecuteReader();
ddltype.DataSource = sdr;
ddltype.DataTextField = "TypeName"; //数据库包含两个字段,TypeName和TypeID
ddltype.DataValueField = "TypeID";
ddltype.DataBind();
conn.Close();
ddltype.Items.Insert(0, "请选择文章类型...");
conn.Open();
SqlCommand cmd = new SqlCommand("select TypeID,TypeName from ArticleType", conn);
if (ddltype.Items.Count != 0) //如果DropDownList里面原有项目则清空
ddltype.Items.Clear();
SqlDataReader sdr = cmd.ExecuteReader();
ddltype.DataSource = sdr;
ddltype.DataTextField = "TypeName"; //数据库包含两个字段,TypeName和TypeID
ddltype.DataValueField = "TypeID";
ddltype.DataBind();
conn.Close();
ddltype.Items.Insert(0, "请选择文章类型...");