<asp:CheckBoxList ID="cblqf" ForeColor="#4d6fc8" runat="server" RepeatColumns="10">
</asp:CheckBoxList>

string sqlqf = @" select UserName,userTalbe.ID from UserTalbe
inner join sf_bmgl on sf_bmgl.id = userTalbe.ssdw
where sf_bmgl.id in ('017FDD9A-B4A3-4EC2-ADBF-5BC390CF5E6F','9CEFC7B9-BBCB-4258-84F8-95081FFCD18E')
order by sf_bmgl.id desc ";//获取董事长、总经理信息
DataSet dsqf = DbHelperSQL.Query(sqlqf);//获取董事长的信息
cblqf.DataSource = dsqf.Tables[0];
cblqf.DataTextField = "UserName";
cblqf.DataValueField = "ID";
cblqf.DataBind();