SharePoint Classes

SPException
The SPException object represents an exception thrown by SharePoint.
Properties: ErrorCode, NativeErrorMessage (error from unmanaged code) andNativeStackTrace (error from unmanaged code)
SPUtility
SPUtility object has a ton of useful static methodsthat you can use in your SharePoint solution>
Useful static method in Sputility: Redirect(), SendEmail(), GetGenericSetupPath(), CreateISO8601DateTimeFromSystemDateTime(), Rsolveprincipals(), HandleAccess-Denied(), GetLocalizedString(), FormatDate(), ParseDate(), AlternateServerURLFromHttpRequestUrl()
SPQuery
The SPQuery object allows you to construct queries to return specific items in a list.Use CAML.you have to come up with a Query string and the language the query is defined in is a SharePoint specific language called CAMLE.g., search our announcements lists for items with a title that contains “Test” :

<OrderBy>
<FieldRef name=”Title”>
</OrderBy>
<Where>
<Contains>
<FieldRef name=”Title”>
<Value Type=”Text”/>Test</Value>
</Contains>
</Where>
The <Contain> can be replaced with:

<EQ>, <NEQ>, <GT>, <GEQ>, <LT>, <IsNull> and <BeginsWith>
Sample code:
SPQuery query = new SPQuery();
Query.Query=”{The above mentioned CAML code}”SPListItemCollection items = list.Getitems(query);
SPSiteDataQuery
SPSiteDataQuery is like a powered up version of SPQuery. It can execute across multiple lists.
SPQuery can only execute in one particular list.
Sample code:

SPSiteDataQuery query = new SPSiteDataQuery();
query.Lists = “<Lists BaseType=’0′>”;
query.Query ==”{The above mentioned CAML code}”query.Webs=”<Websope=’SiteCollection’/>”;
query.ViewFields=”<FieldRef Name=”Title”/>;
query.RowLimit=10;
using (SPWeb web=SPContext.Current.Web) {
System.Data.DataTable table=web.getSiteData(query);
//… other things
}

SPUser
SPUser.UserToken and SPUser.Sid not availble in sanbox solution.
public override void ItemUpdating(SPItemEventProperties properties) {
SPWeb = properties.Web;
SPUser user=web.AllUsers[@”DOMAIN\ecrater”];
user.email=”xxxxxxx”;
user.Notes = “CCCCCC”;

User.Update();
Base.ItemUpdating(properties);
}