Niral's blog

The following are the features installed by SharePoint 2010 Enterprise.  I frequently need to find what a feature is associated with a feature id during development, and hence the table.

As all feature titles and descriptions are localized, I have extracted the localized strings for each of the strings from english langauge installation.

Hope this helpful.

This is a simple code to create a SharePoint (MOSS) 2007 Publishing page with code. Hope this helps  

// Get the SPSite - getting the current site for examples sake
SPSite cursite = SPContext.Current.Site;

using (SPWeb curweb = cursite.OpenWeb())

{
    // Get the Pages library of the web
    SPList pagelist = curweb.Lists["Pages"];

    //content type assigned to the pages library
    SPContentType contentType = pubSite.ContentTypes["ContentType Name"];
 
    //page layouts for the content type
    PageLayoutCollection pageLayouts = pubSite.GetPageLayouts(contentType, true);

    Dictionary<string, PageLayout> dPageLayouts = new Dictionary<string, PageLayout>();

    foreach (PageLayout pageLayout in pageLayouts)
    {
        dPageLayouts.Add(pageLayout.Title, pageLayout);
    } 

    //page layout that is required for the new page
    PageLayout pageLayoutToUse = dPageLayouts["layoutName"];

    //publishing web from the currently open web
    PublishingWeb pubWeb = PublishingWeb.GetPublishingWeb(curweb);

    //add a new page
    PublishingPage newPubPage = pubWeb.GetPublishingPages().Add("newPageName.aspx", pageLayoutToUse);

    //put what ever content you want in the page.
    SPListItem newPage = newPubPage.ListItem;
    newPage["Title"] = "New Page Title";
    newPage["content"] = "<span><b>here's some new content</b></span>";
    newPage.Update();

    //check the file in and publish it
    newPage.File.CheckIn("Autocreated");
    newPage.File.Publish("Autocreated");

    try
    {
        //This will throw an exception if Approval is not enabled on the pages library
        newPage.File.Approve("Autocreated");
    }
    catch

    {       
    }
}

This is a simple query to get file sizes from a sharepoint database.  I know there are multiple ways of doing this, but I found this the easiest and also the fastest.

select [filename],

sum(CAST((CAST(CAST(filesize as decimal(38,2))/1024 As 

      decimal(38,2))/1024) AS Decimal(38,2))) AS 'Size in MB'

from (

    select dirname + '/' + leafname as [filename],

           size as filesize,

           siteid,

           webid,

             ExtensionForFile

    from alldocs

    union

    select d.dirname + '/' + d.leafname as [filename],

           v.size as filesize,

           d.siteid,

           d.webid,

             ExtensionForFile

    from alldocs d

    inner join alldocversions v on d.siteid = v.siteid

    and d.id = v.id

) as results

inner join webs s on s.siteid = results.siteid

and s.id = results.webid

where (filesize is not null

  and filesize > 0)

    and ExtensionForFile not like '%aspx%' -- Not Include Certian File Types

group by 

[Filename]

order by 2 desc

Setting field values of a list item in SharePoint is easy.  But when it comes to Multi-Choice fields, the code is a big different.  The following code shows how values can be added to a multi-choice field.

SPFieldMultiChoice choiceField = (SPFieldMultiChoice)myWeb.Fields["choiceFieldName"];

choiceField.Choices.Add("Value");

//Set PushChangesToLists to true if automatic update of List or Content types is required

choiceField.PushChangesToLists = false; 

choiceField.Upate();

One way to read the data from a list or a library is to iterate through it using the items collection of the list or library. But this is not the most efficient way to do it, specially if only few items are needed from this list. Enter CAML Queries. The following is the example query

<Where>

  <Eq>

    <FieldRef Name="Title" />

      <Value Type="Text">title</Value>

  </Eq>

</Where>

One thing to note in the CAML Query is that there is <query> start and end tag.  It is required that the query string does not have starting and ending <query> tag, otherwise the SPQuery will always return a empty dataset. And here is the code:

SPList mylist = web.Lists["MyList"];

SPQuery spQuery = new SPQuery();

spQuery.Query = "" //CAML Query String;

SPListItemCollection queryitems = mylist.GetItems(spQuery);

That is it, as simple as that. There as a great tool to build CAML Queries at http://www.u2u.info/SharePoint/U2U%20Community%20Tools/Forms/AllItems.aspx called U2U Caml Query Builder.  It is worth checking this tool out.