public partial class ContentSliderUserControl : UserControl { string Qry = " <where><geq><fieldref name="Expires" /><value includetimevalue="FALSE" type="DateTime">{0}</value></geq></where>"; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DisplayAnnouncements(); } } private void DisplayAnnouncements() { SPSecurity.RunWithElevatedPrivileges(delegate() { using (SPSite site = new SPSite(SPContext.Current.Site.ID)) { using (SPWeb web = site.OpenWeb(SPContext.Current.Web.ID)) { SPList list = web.Lists["Announcements"]; SPQuery query = new SPQuery(); query.RowLimit = 10; query.Query = string.Format(Qry, DateTime.Now.ToString("yyyy-MM-dd")); rep1.DataSource = list.GetItems(query).GetDataTable(); rep1.DataBind(); } } } ); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)