数据库信息绑定DropDownList控件的Item

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, "请选择文章类型...");