Niral.Net

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

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();

<Where>

  <Eq>

    <FieldRef Name="Title" />

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

  </Eq>

</Where>

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

SPQuery spQuery = new SPQuery();

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

SPListItemCollection queryitems = mylist.GetItems(spQuery);

using (SPSite p_site = new SPSite(urlToSite))

{

    using (SPWeb p_web = p_site.OpenWeb())

    {

        SPContentType CustomContentType = new

                SPContentType(p_web.AvailableContentTypes["ParentContentType"],

                p_web.ContentTypes, "MyContentType");

        // A string Field

        p_web.Fields.Add("NumberColumn", SPFieldType.Number);

        SPFieldLink fLink1 = new SPFieldLink(p_web.Fields["NumberColumn"]);

        CustomContentType.FieldLinks.Add(fLink1);

        // A required number field

        p_web.Fields.Add("StringColumn", SPFieldType.Text, true);

        SPFieldLink fLink2 = new SPFieldLink(p_web.Fields["StringColumn"]);

        CustomContentType.FieldLinks.Add(fLink2);

        //A Choice Field

        p_web.Fields.Add("ChoiceColumn", SPFieldType.Choice, false);

        SPFieldChoice choicefield = (SPFieldChoice)p_web.Fields["ChoiceColumn"];

        // Add a group to the filed

        choicefield.Group = "MyGroup";

        // Add choices

        choicefield.Choices.Add(string.Empty);

        choicefield.Choices.Add("Yes");

        choicefield.Choices.Add("No");

        // Set the default choice

        choicefield.DefaultValue = string.Empty;

        choicefield.Update();

        SPFieldLink fLink3 = new SPFieldLink(choicefield);

        CustomContentType.FieldLinks.Add(fLink3);

        p_web.Fields.Add("LookupColumn", SPFieldType.Lookup, false);

        SPFieldLookup lookupfield = (SPFieldLookup)p_web.Fields["LookupColumn"];

        // Set the remote lookup list

        lookupfield.LookupList = new Guid("guidofremotelist");

        // Set the remote field

        lookupfield.LookupField = "remotefieldname";

        lookupfield.Update();

        SPFieldLink fLink4 = new SPFieldLink(lookupfield);

        CustomContentType.FieldLinks.Add(fLink4);

        CustomContentType.Update();

    }

}