R – how to change SharePoint search page URL

Developing for SharePoint is a big leap - for example, the official scenario is doing your development directly on a server. So most SP devs end up building a virtual machine for their development.

Creating an SP dev environment.

Creating a custom web part for SP2007.

Personally, I use the VSeWSS add-in (version 1.3, March CTP) for developing sharepoint "solutions" (really, cab files that wrap up functionality) that contain "features." Many devs prefer other tools, such as STSDEV or WSPBuilder.

Once you get that far creating the web part you need should be simple.

If you're using server (i.e., not client) dlls, you can use SPList.GetItems Method with SPQuery as a parameter:

SPSite oSiteCollection = SPContext.Current.Site;
SPList oList = oSiteCollection.AllWebs["Site_Name"].Lists["List_Name"];
SPQuery oQuery = new SPQuery();
oQuery.Query = "<Where><Eq><FieldRef Name='Schedule'/>" +
        "<Value Type='CHOICE'>2 weeks</Value></Eq></Where>";
SPListItemCollection collListItems = oList.GetItems(oQuery);

foreach (SPListItem oListItem in collListItems)
{
    Label1.Text += SPEncode.HtmlEncode(oListItem["Title"].ToString()) 
        + " -- " + SPEncode.HtmlEncode(oListItem["EndDate"].ToString())   
        + "<BR>";
}

Note that foreach part of this example code which displays data in HTML format, is provided only for example. You may use the same rendering as you use at present. The key is to use SPQuery and .GetItems(...).

If you use client dlls, see this link and others from MSDN (this link is only an example, it is relevant for SharePoint Team Services Client API).