Sean的分享空間

2008-10-01

SPQuery時間

摘要:SPQuery時間

一般我們可能都會用DateTime.Now

但這是無法Query得到，一定要用SPUtility.CreateISO8601DateTimeFromSystemDateTime(DateTime.Now)

這是在Microsoft.SharePoint.Utilities的namespace

using System;
using System.Collections.Generic;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using Microsoft.SharePoint;
using Microsoft.SharePoint.Utilities;
using System.Data;

namespace MyWebPart
{
    public class List5 : WebPart
    {
        protected override void RenderContents(HtmlTextWriter writer)
        {
            using (SPSite site = new SPSite("http://MySharePoint/"))
            {
                using (SPWeb web = site.OpenWeb())
                {
                    SPListCollection lists = web.Lists;
                    SPList list = lists["Item"];  //your list

                    SPQuery query = new SPQuery();
                    //view.RowLimit = 10;
                    query.Query = string.Format("<Where><Geq><FieldRef Name='Expires'/><Value Type='DateTime'>{0}</Value></Geq></Where><OrderBy><FieldRef Name='StartDate' /></OrderBy>", SPUtility.CreateISO8601DateTimeFromSystemDateTime(DateTime.Now));
                    
                    SPListItemCollection items = list.GetItems(query);

                    int i = 1;
                    while (i <= 5)
                    {
                        DateTime date = (DateTime)items[iIndex]["開始日期"];

                        writer.Write(date.ToString());
                        i++;
                    }
                }
            }
        }
    }
}