Get all Custom Site Templates from Site collection

using (SPSite newSite = new SPSite(SiteURL))
{
using (SPWeb newWeb = newSite.OpenWeb())
{
SPWebTemplateCollection customTempCollection = newSite.GetCustomWebTemplates((uint)newWeb.Locale.LCID);
}
}

Get Discussion List Items from SharePoint Discussion Forum

If you are trying to retrieve all the root items of the Discussion List this way , it's not going to work :
SPSite site = new SPSite("Site URL");
SPWeb web = site.OpenWeb();
SPList list1 = web.Lists["DiscussionListName"];
SPListItemCollection coll = list1.Items ;



Well Here is the right way of doing it :-)
SPSite site = new SPSite("Site URL");
SPWeb web = site.OpenWeb();
SPList list1 = web.Lists["DiscussionListName"];
SPListItemCollection coll =list1.Folders ;

Sharepoint ListTemplateId

GenericList 100
DocumentLibrary 101
Survey 102
Links 103
Announcements 104
Contacts 105
Events 106
Tasks 107
DiscussionBoard 108
PictureLibrary 109
DataSources 110
WebTemplateCatalog 111
UserInformation 112
WebPartCatalog 113
ListTemplateCatalog 114
XMLForm 115
MasterPageCatalog 116
NoCodeWorkflows 117
WorkflowProcess 118
WebPageLibrary 119
CustomGrid 120
DataConnectionLibrary 130
WorkflowHistory 140
GanttTasks 150
Meetings 200
Agenda 201
MeetingUser 202
Decision 204
MeetingObjective 207
TextBox 210
ThingsToBring 211
HomePageLibrary 212
Posts 301
Comments 302
Categories 303
IssueTracking 1100
AdminTasks 1200

Setting Site Theme Programmatically

SPSite site = new SPSite("");
SPWeb web = site.OpenWeb();
web.ApplyTheme("");

Granular Level Export/Import of data MOSS

Have you ever wondered what if u have to migrate just a list between servers ,do you need to buy third party tool . Nopes...

Just create a tool using API from Microsoft.SharePoint.Deployment Namespace and it's not as complex as you might think .


Check this great article with samples :

http://blogs.technet.com/stefan_gossner/archive/2007/08/30/deep-dive-into-the-sharepoint-content-deployment-and-migration-api-part-1.aspx

Happy Coding and New Year!!!

MOSS 2007 Site Object Model in NUTSHELL