Index
A
accessing
document libraries, 84
Feature collections, 26
lists, 206-209
BDC data in, 59-62
item values, 53
site collection information, 41
web information, 45
activating Features, 25, 29-30
Add Reference dialog box, 19
Add( ) method
EventReceivers collection, 77
Solutions collection, 32
SPFeatureDefinitionCollection class, 31
SPMeeting class, 103
AddCollegue( ) method, 308
Added property (SPSolution class), 33
AddGroup( ) method, 315
AddGroupToRole( ) method, 315
adding
Assemblies to GAC, 181
Global Assembly Cache, 236
JavaScript to Web Parts, 204
record routing rules, 370
setup projects, 235
Web controls to Web Parts, 199
Web Custom Controls, 166
Web Parts to Web Part pages, 339-341
web references, 287
user profiles to groups, 145
AddLink( ) method, 308
AddMeeting( ) method, 298
AddMeetingFromiCal( ) method, 299
AddMembership( ) method, 308
AddPinnedLink( ) method, 308
AddRole( ) method, 315
AddRoleDef( ) method, 315
AddUserCollectionToGroup( ) method, 315
AddUserCollectionToRole( ) method, 315
AddUserToGroup( ) method, 315
AddUserToRole( ) method, 315
AddWebPart( ) method, 338
AddWebPartToZone( ) method, 338
AddWorkflowAssociation( ) method, 55
AdventureWorks SQL database, 113
AfterProperties property (SPItemEventProperties class), 74
AfterUrl property (SPItemEventProperties class), 74
agenda fields (Meeting Workspaces), 304
alerts, viewing, 379-382
Alerts property (SPWeb class), 42
Alerts Web Service, 379-382
AlertTemplate property (SPList class), 48-49
AllowAnonymousAccess property (SPWeb class), 42
AllowContentTypes property (SPList class), 48
AllowDeletion column (lists), 275
AllowDeletion property (SPList class), 48
AllowEveryoneViewItems property (SPList class), 48
AllowMultiResponse property (UpdateList( ) method), 278
AllowMultiResponses column (lists), 275
AllowMultiResponses property (SPList class), 48
AllowRssFeeds property
SPList class, 48
SPSite class, 36
SPWeb class, 42
AllowUnsafeUpdates property
SPSite class, 36
SPWeb class, 42
AllProperties property (SPWeb class), 42
AllUsers property (SPWeb class), 42
AllWebs property (SPSite class), 36
AlternateCssUrl property (SPWeb class), 42
AlternateHeader property (SPWeb class), 42
AlterTask( ) method, 365
AlterToDo( ) method, 360
AnonymousPermMask column (lists), 274
AnonymousState property (SPWeb class), 42
APIs (Application Programming Interfaces)
BDC administration, 121-123
BDC runtime, 124
data access, 126-131
direct method execution, 131-132
metadata, querying, 124-126
AppearanceEditorPart control, 174
applications
alerts viewing, 379-382
BDC, configuring, 111-114
console
creating, 21-22
deploying, 22-23
ExcelServicesHelloWorld, 326-328
Feature Enumerator, 29
list items, 281-282
ListRetriever, 276-277
photo album browser, 267-272
reading/writing ranges and saving temporary workbooks, 329-332
remote, 18
server, 17-18
web
hierarchy, 36
site collections, listing, 35
Windows Forms
DocLibPicker.cs, 89-90
Form1.cs, 86-88
ApplyTheme( ) method, 44
ApplyWebTemplate( ) method, 44
approval workflows, 148
Approve( ) method, 94
approving files, 94
architecture (Excel Services), 323
Calculation Services, 324
Web Access, 324
Web service, 325
hello world example, 326-328
methods, 325-326
multiple named ranges client application example, 328-329
reading/writing ranges and saving temporary workbooks application, 329-332
trusted locations, configuring, 326
ASP.NET
server controls
building, 166-168
extending, 168-172
saving to ViewState, 170-172
user controls, compared, 163-166
user/server control integration, 184
Web Parts
accessing lists, 206-209
attributes, 194-195
connected. See connected Web Parts
controls, 173
creating, 178-181
debugging, 234
design mode, 177
entering data into lists, 210
functionality, 197
HelloWorld example, 179-180
importing, 188
integration, 174
JavaScript, adding, 204
layout, 197
managing, 175-176
postbacks, 203
properties, 191-196
providers, 217
rendering in browsers, 199
SharePoint integration, 185-188
SharePoint Web Parts, compared, 185
SimpleLoanCalculator, 192-194
SQLExecute example, 197-203
System.Web.dll file reference, 178
template, 198-199
testing, 181-183
third-party tools, 183
time sheet list example, 205
Timesheet Entry Web Part example listing, 210-213
updating lists, 209-215
web controls, adding, 199
zones, 178
assemblies
adding to GAC, 181
PublicKeyToken, retrieving, 186
references, testing, 21-22
strong naming, 180
AssociateWorkflowMarkup( ) method, 338
associations
BDC entities, 110
workflows, 150
Attachments property (SPListItem class), 51
attendance (meetings), 302-303
attendee responses (meetings), 105
attributes
ConnectionConsumer, 223
ConnectionProvider, 220
Web Part properties, 194-195
Audit property
SPFolder class, 86
SPList class, 48
SPListItem class, 51
SPSite class, 36
SPWeb class, 42
authentication
BDC, 110-111
web services, 299
AuthenticationMode property (SPWeb class), 42
Author column (lists), 274
Author property
SPFile class, 84
SPWeb class, 42
AvailableContentTypes property (SPWeb class), 42
B
BackColor property (TextBox class), 168
BaseTemplate property (SPList class), 48
Basetype column (lists), 274
BaseType property (SPList class), 48
batch file for installation, 158-159
BDC (Business Data Catalog), 59, 109, 347
administration API, 121-123
applications, 111-114
authentication, 110-111
benefits, 111
columns in custom lists, 118-119
compatible web services, 132
disadvantages, 111
entities, 110
actions, 117-118
associations, 110
enumerating, 350-351
methods, 110
Field Resolver Web Service, 355-356
fields, enumerating, 355-356
filter descriptors, enumerating, 354
ID enumerators, 110
Line of Business system
enumerating, 349
properties, 348
lists, 59-62
metadata, querying, 124-126
methods
enumerating, 352-353
instances, 351
overview, 347-348
relational data, exposing, 133
runtime API, 124
data access, 126-131
direct method execution, 131-132
metadata, querying, 124-126
Web Parts, 114-116
Web Service, 348
entities, enumerating, 350-351
filter descriptors, enumerating, 354
Line of Business systems, 348-349
methods, 351-353
BeforeProperties property (SPItemEventProperties class), 74
BeforeUrl property (SPItemEventProperties class), 74
BehaviorEditorPart control, 174
binary representations (files), 94
breakpoints (Web Parts), 231-233
BreakRoleInheritance( ) method
SPList class, 55
SPListItem class, 57
btnExecuteSQL control, 202
building
BDC compatible web services, 132
consumer Web Parts, 221-223
document library explorer, 86
DocLibPicker.cs, 89-90
Form1.cs, 86-88
provider Web Parts, 217
data interface, 218
Web Part, creating, 21-220
server controls, 166-168
workflows, 150
designing forms, 151-153
modeling, 153-155
typical roadmap, 150
built-in style sheets, 213
Business Data Actions Web Part, 114
Business Data Catalog. See BDC
Business Data Item Builder Web Part, 115
Business Data Item List Web Part, 114
Business Data Item Web Part, 114
Business Data Related List Web Part, 115
C
Calculate( ) method (Excel Services Web Services), 325
CalculateA-1( ) method (Excel Services Web Service), 325
CalculateWorkbook( ) method (Excel Services Web Service), 325
calendar events, 105
CAML (Collaborative Application Markup Language), 5
comparison operators, 6
FieldRef extraction utility, 7-8
list items, querying, 8-11, 62-64, 287-288
queries, creating, 6
U2U CAML Query Builder, 11
Cancel( ) method, 104
Cancel property
SPItemEventProperties class, 74
SPListEventProperties class, 71
CancelRequest( ) method, 325
CanCreateDwsUrl( ) method, 242
CanReceiveEmail property (SPList class), 48
CatchAccessDeniedException property (SPSite class), 36
CertificationDate property (SPSite class), 36
change log query for user profiles, 140-142
change tokens (user profiles), 314
CheckedOutBy property (SPFile class), 84
CheckedOutDate property (SPFile class), 84
CheckForPermissions( ) method, 38
CheckInComment property (SPFile class), 84
checking in/out files, 91-94
CheckOutExpires property (SPFile class), 84
CheckOutStatus property (SPFile class), 84
CheckSubWebAndList( ) method, 257
child/parent relationships (lists), 64
content types, creating, 65
hierarchical, traversing, 66-67
choice list properties (user profiles), 144
claiming workflow tasks, 366
ClaimReleaseTask( ) method, 360, 366
classes
document libraries, 84
ExpandingTextBox, 170
Features, 26
GenericWebPart, 184
ListMetaLogger, 72-73
MembershipManager, 145
object model, 16
ProfilePropertyCollection, 143
SPChangeToken, 314
SPContext, 21
SPEventReceiverBase, 70
SPFarm, 27-29
SPFeatureDefinitionCollection, 31
SPFile
CheckIn( ) method, 91
CheckOut( ) method, 91
methods, 94
properties, 84-85
SaveBinary( ) method, 93
submitting files to records repositories, 373-374
SPFolder
methods, 94
properties, 86
SPItemEventProperties, 74
SPItemEventReceiver, 69
SPList
enumerating lists, 50-51
methods, 55
properties, 48-50
SPListEventProperties, 71
SPListEventReceiver, 70
list contents, viewing, 52
list item values, accessing, 53
methods, 57
properties, 51
Update method, 214
SPMeeting, 99
Add( ) method, 103
Cancel( ) method, 104
LinkWithEvent( ) method, 105
SetAttendeeResponse( ) method, 105
Update( ) method, 104-105
SPSite, 35-36
accessing site collection information, 41
creating site collections, 39-41
Features property, 27
instance of, creating, 27-29
methods, 38
properties, 36-38
updating site collections, 42
SPSiteCollection, 35-36
SPSolution, 32
deploy methods, 34
properties, 33
accessing webs information, 45
creating webs, 44-45
Delete method, 99
Features property, 27
methods, 44
properties, 42-43
updating webs, 46
SPWebApplication, 35-36
SPWebPartManager, 185
SPWorkflow, 365
TextBox, 166
WebControl, 166
WebPart, 185
WebPartManager
static connection properties, 224
Web Parts, connecting, 223
WebPartZone, 185
Close( ) method
SPSite class, 38
SPWeb class, 44
CloseWorkbook( ) method, 325
coding workflows, 155-156
Collaborative Application Markup Language. See CAML
collections
EventReceivers, 77
Features, 26
Solutions, 32
SPFeaturePropertyCollection, 30
columns
custom BDC lists, 118-119
lists, 274-275
Meeting Series, 300
comparison operators (CAML), 6
Compatibility( ) method, 338
compiling setup projects, 237
compliance. See records repositories
configuring
BDC applications, 111-114
development environment, 18-19
local, 19-20
remote, 20-21
domain-level trusts, 151
Excel Services trusted locations, 326
feature.xml file, 156-157
install.bat file, 158-159
Records Center connections, 370
setup projects, 236
workflow.xml file, 157
ConfirmUsage( ) method, 38
connected Web Parts
connecting, 223-226
consumers, 221-223
providers, 217-220
ConnectionConsumer attribute (SetCustomer( ) method), 223
ConnectionProvider attribute (GetCustomerID( ) method), 220
console applications
creating, 21-22
deploying, 22-23
consumer Web Parts, 221-226
ConsumerConnectionPoint property (WebPartManager class), 224
ConsumerID property (WebPartManager class), 224
ContainingDocumentLibrary property (SPFolder class), 86
Contains element, 6
ContainsCasPolicy property (SPSolution class), 33
ContainsGlobalAssembly property (SPSolution class), 33
ContainsWebApplicationResource property (SPSolution class), 33
creating, 65
event receivers, deploying, 81
hierarchical list items, querying, 283-285
Order Item, 65
Order Parent, 65
ContentDatabase property (SPSite class), 36
ContentType property (SPListItem class), 51
ContentTypes property
SPList class, 48
SPWeb class, 42
ContentTypesEnabled property (SPList class), 48
Context property (SPItemEventProperties class), 74
controls
server, 184
ASP.NET integration, 184
building, 166-168
extending, 168-172
saving to ViewState, 170-172
user controls, compared, 163-166
SQLExecute Web Part, 202
user
ASP.NET integration, 184
information collection user control, 164-165
server controls, compared, 163-166
Web Part, 173
adding, 199
CatalogZone, 178
WebPartManager, 175-176
WebPartZones, 178
Convert( ) method, 94
converting files, 94
ConvertWebPartFormat( ) method, 338
Copy( ) method, 57
CopyDestinations property (SPListItem class), 51
copying files/folders, 94
CopyTo( ) method, 94
core objects, 207
CorrelationToken property, 155
Create( ) method, 143
Create New Item interface, 210
Create, Retrieve, Update, and Delete (CRUD), 274
CreateChildControls( ) method, 199, 202-203
Created column (lists), 274
Created property
SPList class, 48
SPWeb class, 42
CreateDws( ) method, 242
CreateMemberGroup( ) method, 308
CreateNewFolder( ) method, 257, 263-264
CreateUserProfile( ) method, 143
CreateUserProfileByAccountName( ) method, 308
CRUD (Create, Retrieve, Update, and Delete), 274
Current property (SPContext object), 207
CurrentChangeToken property
SPList class, 48
SPSite class, 36
CurrentUser( ) method, 315
CurrentUser property (SPWeb class), 43
CurrentUserId property (SPItemEventProperties class), 74
CustomerID property (ISelectedCustomer interface), 218
customizing. See modifying
D
data entry (lists), 210
DataSourceControl( ) method, 338
DateRangesOverlap element, 6
deactivating Features, 29-30
DeadWebNotificationCount property (SPSite class), 37
debugging Web Parts, 229-230
breakpoints, setting, 231-233
common SharePoint server, 234
development workstations, 229-230
local SharePoint server, 234
Visual Studio 2005, 230-231
Web Part library, compiling, 231
without SharePoint or WSS, 233
decision fields (Meeting Workspaces), 304
DeclarativeCatalogPart control, 174
DefaultItemOpen property (SPList class), 48
DefaultView property (SPList class), 48
DefaultViewUrl column (lists), 274
DefaultViewUrl property (SPList class), 48
Delete( ) method
SPFile class, 94
SPFolder class, 94
SPList class, 55
SPListItem class, 57
SPSite class, 38
DeleteWebPart( ) method, 338
DeleteWorkspace( ) method, 297
deleting
Document Workspaces, 243-244, 248
Feature definitions, 31
files, 94
folders, 94
images, 263
lists, 53-55
Meeting Workspaces, 296-297
Solutions, 32
views, 289
Deny( ) method, 94
denying files, 94
Deploy( ) method, 34
Deployed property (SPSolution class), 33
DeployedServers property (SPSolution class), 33
DeployedWebApplications property (SPSolution class), 33
deploying
console application, 22-23
event receivers
content types, 81
Features, 77-79
programmatically, 77
Solutions, 34
Web Parts, 235
compiling setup project, 237
configuring setup project, 236
MSI-based, 235
setup projects, adding, 235
workflows, 156-159
DeploymentState property (SPSolution class), 33
Description column (lists), 274
Description property
SPList class, 48
SPWeb class, 43
UpdateList( ) method, 278
designing workflow forms, 151-153
development environment
configuring, 18-19
local, 19-20
remote, 20-21
Direction column (lists), 274
Direction property
SPList class, 48
UpdateList( ) method, 278
DisplayName property (SPListItem class), 51
Dispose( ) method, 38
DocLibPicker.cs Windows Forms application, 89-90
DocTemplates property (SPWeb class), 43
DocTemplateUrl column (lists), 274
document libraries
accessing, 84
classes, 84
documents, 84
explorer, building, 86
DocLibPicker.cs, 89-90
Form1.cs, 86-88
overview, 83
SPFile class, 84-85
SPFolder class, 86
uploading documents, 84
Document Workspaces
creating, 242-244
data, retrieving, 244-246
deleting, 243-244
document ID storage, 251-252
folders, 248
metadata, retrieving, 246-247
overview, 241
URLs, validating, 242
users, managing, 253
documents
uploading to document libraries, 84
versioning, 91-93
DoesUserHavePermissions( ) method
SPList class, 55
SPListItem class, 57
SPSite class, 38
domain-level trusts, 151
downloading images to picture libraries, 262
DraftVersionVisibility property (SPList class), 48
E
ECS (Excel Calculation Services), 324
Edit in DataSheet interface, 210
EditorZone control, 174
elements
Contains, 6
DateRangesOverlap, 6
Eq, 6
FieldRef, 6-8
Geq, 6
IsNotNull, 6
IsNull, 6
Leq, 6
Lt, 6
Neq, 6
Elements.xml file, 78-79
EmailAlias column (lists), 275
EmailAlias property (SPList class), 48
EmailInsertsFolder column (lists), 275
EnableAssignedToEmail property (UpdateList( ) method), 278
EnableAttachments column (lists), 275
EnableAttachments property
SPList class, 49
UpdateList( ) method, 278
EnableFolderCreation property (SPList class), 49
EnableMinorVersions property (SPList class), 49
EnableMinorVersoin column (lists), 275
EnableModeration column (lists), 275
EnableModeration property
SPList class, 49
UpdateList( ) method, 278
EnableVersioning column (lists), 275
EnableVersioning property
SPList class, 49
UpdateList( ) method, 278
entities
BDC, 110
actions, 117-118
associations, 110
methods, 110
LOB, enumerating, 350-351
EntityStruct struct, 350
enumerating
Feature definitions lists, 27-29
Features, 27-29
fields, 355-356
filter descriptors, 354
Line of Business systems, 349
lists, 48-51
contents, 51-53
item values, 53
LOB system entities, 350-351
methods, 352-353
picture libraries, 258
Solutions, 32-33
Eq element, 6
ErrorMessage property
SPItemEventProperties class, 74
SPListEventProperties class, 71
Event property (SPList class), 49
EventReceivers collection, 77
EventReceivers property
SPFile class, 85
SPWeb class, 43
events
calendar, 105
handlers, 69
receivers
creating, 70
deploying, 77-81
lists, 70-76
EventSinkAssembly column (lists), 275
EventSinkClass column (lists), 275
EventSinkData column (lists), 275
EventType property
SPItemEventProperties class, 74
SPListEventProperties class, 71
EWA (Excel Web Access), 324
Excel Services
application logic, 322
architecture, 323-325
business intelligence, 322
Calculation Services (ECS), 324
overview, 322
user-defined functions, creating, 332-335
user-defined libraries, 334
Web Services, 325
hello world example, 326-328
methods, 325-326
multiple named ranges client application example, 328-329
reading/writing ranges and saving temporary workbooks application, 329-332
trusted locations, configuring, 326
workbook management, 322
Excel Web Access (EWA), 324
ExcelServicesHelloWorld application, 326-328
ExecuteProxyUpdates( ) method, 338
Exists( ) method, 38
Exists property
SPFile class, 85
SPFolder class, 86
expanding TextBox control listing, 169-170
ExpandingTextBox class, 170
extending server controls, 168-172
extracting fields from lists, 7-8
F
Feature definitions, 30
compared, 27
deleting, 31
enumerating, 27-29
installing, 31
properties, 30-31
Feature Enumerator application, 29
FeatureDefinitions property (SPFarm class), 27
FeatureId column (lists), 274
Features
activating/deactivating, 25, 29-30
classes, 26
collections, accessing, 26
defined, 25
enumerating, 27-29
packaging, 26
properties, 30-31
Features property
FetchLegalWorkflowActions( ) method, 338
Field property (SPListEventProperties class), 71
FieldAdded event, 71
FieldAdding event, 71
FieldDeleted event, 71
FieldDeleting event, 71
FieldName property (SPListEventProperties class), 71
FieldRef element, 6
FieldRef extraction utility, 7-8
fields (lists), 7-8
Fields property
SPList class, 49
SPListItem class, 51
FieldUpdated event, 71
FieldUpdating event, 71
FieldXml property (SPListEventProperties class), 71
File property (SPListItem class), 51
files
approving, 94
binary representation, 94
checking in/out, 91-94
converting, 94
copying, 94
deleting, 94
denying, 94
Elements.xml, 78-79
install.bat, 158-159
moving, 94
Program.cs, 21-22
publishing, 94
restoring to checked-in state, 94
saving, 94
sending to Recycle Bin, 94
submitting to records repositories, 373-374
System.Web.dll, 178
taking offline, 94
transform states, 94
updating, 94
workflow.xml, 157
Files property
SPFolder class, 86
SPWeb class, 43
filters
descriptors, 354
Finders, 128-129
lists, 287-288
FindDwsDoc( ) method, 251
finding BDC entities, 117
direct method execution, 131-132
filter Finders, 128-129
specific Finders, 126-128
wildcard Finders, 130-131
Flags column (lists), 274
Folder property (SPListItem class), 51
folders
copying, 94
deleting, 94
Document Workspace, 248
Global Assembly Cache, 236
moving, 94
picture libraries, 263-264
sending to Recycle Bin, 94
updating, 94
Folders property
SPList class, 49
SPWeb class, 43
Form1.cs Windows Forms application, 86-88
Forms property (SPList class), 49
G
GenericWebPart class, 184
Geq element, 6
GetAlerts( ) method, 381
GetAllChanges( ) method, 314
GetAllUserCollectionFromWeb( ) method, 315
GetApiVersion( ) method, 325
GetAssemblyMetaData( ) method, 338
GetBindingResourceData( ) method, 338
GetCatalog( ) method
SPSite class, 38
SPWeb class, 44
GetCell( ) method, 325
GetCellA1( ) method, 325
GetChanges( ) method
SPList class, 55
SPWeb class, 44
User Profile Web Change Web Service, 314
GetCommonColleagues( ) method, 308
GetCommonManager( ) method
MembershipManager class, 145
User Profile Web Service, 308
GetCommonMemberships( ) method
MembershipManager class, 145
User Profile Web Service, 308
GetConversionState( ) method, 94
GetConvertedFile( ) method, 94
GetCurrentChangeToken( ) method, 314
GetCustomControlList( ) method, 338
GetCustomerID( ) method, 220
GetCustomListTemplates( ) method, 38
GetCustomWebTemplates( ) method, 38
GetDataFromDataSourceControl( ) method, 338
GetDocDiscussions( ) method, 44
GetDwsData( ) method, 244-246
GetDwsMetaData( ) method, 246-247
GetFile( ) method, 44
GetFolder( ) method, 44
GetFormCapabilityFrom( ) method, 338
GetGroupCollection( ) method, 315
GetGroupCollectionFromRole( ) method, 315
GetGroupCollectionFromSite( ) method, 315
GetGroupCollectionFromUser( ) method, 315
GetGroupCollectionFromWeb( ) method, 315
GetGroupInfo( ) method, 315
GetInCommon( ) method, 309
GetItemById( ) method, 55
GetItemByUniqueId( ) method, 55
GetItems( ) method, 55
GetItemsByIds( ) method, 257, 260
GetItemsXMLData( ) method, 257, 260
GetList( ) method, 44
GetListFromUrl( ) method, 44
GetListItem( ) method, 44
GetListItems( ) method, 257-258
GetListsOfType( ) method, 44
GetPropertyChoiceList( ) method, 309
GetRange( ) method, 325
GetRangeA1( ) method, 325
GetRecycleBinItems( ) method
SPSite class, 38
SPWeb class, 44
GetRecycleBinStatistics( ) method, 38
GetRoleCollection( ) method, 315
GetRoleCollectionFromGroup( ) method, 315
GetRoleCollectionFromUser( ) method, 315
GetRoleCollectionFromWeb( ) method, 315
GetRoleInfo( ) method, 315
GetRolesAndPermissionsFor( ) method, 315
GetSafeAssemblyInfo( ) method, 338, 345
GetServerInfo( ) method, 376
GetSessionInforamtion( ) method, 325
GetSiteData( ) method, 44
GetTemplatesForItem( ) method, 360, 366
GetToDosForItem( ) method, 360
GetUsageData( ) method, 44
GetUserAllChanges( ) method, 314
GetUserChanges( ) method, 314
GetUserColleagues( ) method, 309
GetUserCollection( ) method, 315
GetUserCollectionFromGroup( ) method, 315
GetUserCollectionFromRole( ) method, 315
GetUserCollectionFromSite( ) method, 315
GetUserCollectionFromWeb( ) method, 315
GetUserCurrentChangeToken( ) method, 314
GetUserInfo( ) method, 316
GetUserLinks( ) method, 309
GetUserLoginFromEmail( ) method, 316
GetUserMemberships( ) method, 309
GetUserPinnedLinks( ) method, 309
GetUserProfileByGuid( ) method, 309
GetUserProfileByIndex( ) method, 309
GetUserProfileByName( ) method, 309
GetUserProfileSchema( ) method, 309
GetView( ) method, 55
GetWebPart( ) method, 338, 344
GetWebPart2( ) method, 338
GetWebPartCrossPage( ) method, 338
GetWebPartPage( ) method, 338
GetWebPartPageConnectionInfo( ) method, 338
GetWebPartPageDocument( ) method, 338
GetWebPartProperties( ) method, 338
GetWebPartProperties2( ) method, 338
GetWebTemplates( ) method, 38
GetWorkbook( ) method, 325
GetWorkflowDataForItem( ) method, 360
GetWorkflowTaskData( ) method, 360
GetXmlDataFromDataSource( ) method, 338
Global Assembly Cache
assemblies, adding, 181
folders, adding, 236
verifying, 237
groups
security principles, enumerating, 316-318
User Group Web Service, 315-316
user profiles, adding, 145
Groups property (SPWeb class), 43
gvResults control, 202
H
HasPublishedVersion property (SPListItem class), 51
HasUniqueScopes column (lists), 275
hello world Excel Services example, 326-328
HelloWorld Web Part, 179-180
HelloWorldSequentialWorkflow Assembly
features.xml file, 156-157
install.bat file, 158-159
workflow designer, 155
workflow.xml file, 157
Hidden column (lists), 275
Hidden property
SPList class, 49
UpdateList method, 278
hierarchical list items, querying, 283-285
hierarchy
site collections, 36
web applications, 36
websites, 36
HostHeaderIsSiteName property (SPSite class), 37
HTML (Hypertext Markup Language), 213
I
IconUrl property (SPFile class), 85
ID enumerators, 110
ID property
SPListItem class, 51
SPSolution class, 33
SPWeb class, 43
WebPartManager class, 224
IDs
document ID storage, 251-252
picture library images, retrieving, 260
IISAllowsAnonymous property (SPSite class), 37
images (picture libraries)
deleting, 263
downloading, 262
photo browser example, 266-272
renaming, 263
retrieving from
IDs, 260
lists, 258-260
XML data, 260-261
uploading, 261-262
ImageUrl column (lists), 274
ImageUrl property (SPList class), 49
Imaging Web Service, 256-257, 266-272
Impersonating property (SPSite class), 37
ImportCatalogPart control, 174
importing Web Parts, 188
InDocumentLibrary property (SPFile class), 85
InfoPath, 152
information collection user control, 164-165
install.bat file, 158-159
installing
Feature definitions, 31
Solutions, 32
WF templates, 147-148
instances (workflows), 150
interfaces
Create New Item, 210
Edit in DataSheet, 210
IPostBackDataHandler, 170-172
ISelectedCustomer, 218-220
provider Web Part data interface, 218
IPostBackDataHandler interface, 170-172
ISelectedCustomer interface, 218-220
IsIRMed property (SPFile class), 85
IsNotNull element, 6
IsNull element, 6
IsRootWeb property (SPWeb class), 43
IsWebPartPackage property (SPSolution class), 33
Item property
SPFile class, 85
SPFolder class, 86
ItemAdded event, 75
ItemAdding event, 75
ItemAttachmentAdded event, 75
ItemAttachmentAdding event, 75
ItemAttachmentDeleted event, 75
ItemAttachmentDeleting event, 75
ItemCheckedIn event, 75
ItemCheckedOut event, 75
ItemCheckingIn event, 75
ItemCheckingOut event, 75
ItemCount column (lists), 274
ItemCount property (SPList class), 49
ItemDeleted event, 75
ItemDeleting event, 75
ItemFileConverted event, 75
ItemFileMoved event, 75
ItemFileMoving event, 75
items (lists)
event receivers, creating, 73-76
events, 75
filtering, 287-288
hierarchical
querying, 283-285
traversing, 66-67
querying, 62-64
retrieving, 275-277
revision control, 286
values, accessing, 53
Items property (SPList class), 49
ItemUncheckedOut event, 75
ItemUncheckingOut event, 75
ItemUpdated event, 75
ItemUpdating event, 75
J–K
JavaScript, 204
KPIs (Key Performance Indicators), 322
L
Language property (SPWeb class), 43
LastContentModifiedDate property (SPSite class), 37
LastDeleted column (lists), 274
LastItemDeletedDate property (SPList class), 49
LastItemModifiedDate property (SPList class), 49
LastOperationDetails property (SPSolution class), 33
LastOperationEndTime property (SPSolution class), 33
LastOperationResult property (SPSolution class), 33
LastSecurityModifiedDate property (SPSite class), 37
layout (Web Parts), 197
LayoutEditorPart control, 174
lblError control, 202
Length property (SPFile class), 85
LengthByUser property (SPFile class), 85
Leq element, 6
Level property (SPFile class), 85
libraries
document
accessing, 84
classes, 84
explorer, building, 86-90
overview, 83
SPFile class properties, 84-85
SPFolder class properties, 86
uploading documents, 84
deleting images, 263
downloading images, 262
enumerating, 258
folders, creating, 263-264
Imaging Web Service, 256-257
photo browser example, 266-272
renaming images, 263
retrieving images, 258-261
uploading images, 261-262
Unclassified Records, 370, 375
user-defined, 334
Line of Business systems
entities, 350-351
enumerating, 349
properties, 348
LinkWithEvent( ) method, 105
.List object, 207
List property (SPListEventProperties class), 71
ListId property
SPItemEventProperties class, 74
SPListEventProperties class, 71
listings
alerts viewing application, 379-382
BDC
data in lists, accessing, 60
Field Resolver Web Service, 355-356
metadata, querying, 125
consumer Web Part, 221-222
document library explorer
DocLibPicker.cs, 89-90
Form1.cs, 86-88
Document Workspaces
creating/deleting, 243-244
document ID storage, 251-252
Elements.xml file, 78-79
Excel Services user-defined functions example, 333-334
ExcelServicesHelloWorld application, 326-328
expanding TextBox control, 169-170
Features and Feature Definitions, enumerating, 27-29
filter descriptors, enumerating, 354
finding BDC entities
direct method execution, 131-132
filter Finders, 128-129
specific Finders, 127-128
wildcard Finders, 130-131
GetDwsData method, 244-245
HelloWorld Web Part, 179-180
information collection user control, 164-165
install.bat file, configuring, 158-159
IPostBackDataHandler interface implementation, 170-172
Line of Business systems, 349-351
list items
creating/deleting, 281-282
event receiver, 72-76
hierarchical, querying, 284-285
hierarchical, traversing, 66
manipulation, 54-56
querying, 62-63
updating, 281-282
values, accessing, 53
ListRetriever application, 276-277
LOB system and entity, creating, 122-123
Meeting Workspaces, creating, 98
meetings, creating, 102-103
methods, enumerating, 352-353
numeric textbox server control, 167-168
Official File Web Service, querying, 374
photo album browser application, 267-272
Program.cs file for testing Assembly references, 21-22
provider Web Part, 219-220
reading/writing ranges and saving temporary workbooks, 329-332
SDK sample DWS utility methods, 249-250
SimpleLoanCalculator Web Part, 192-194
Spell Checker Web Service, 378
SQLExecute Web Part, 199-202
submitting files to records repositories with SPFile class, 373
Timesheet Entry Web Part, 210-213
user profiles
change history, 312-313
change log query, 140-142
properties, retrieving, 137-138, 310-311
retrieving, 136-137
versioning example, 91-93
Versions Web Service, 383
Web Parts
adding to Web Part pages, 339-341
connecting, 225-226
debugging, 230-231
list access, 208-209
Manager, 175-176
pages, querying, 344-345
template, 198-199
updating, 342-343
workflow tasks, retrieving, 362-363
workflow.xml file, configuring, 157
WPF data binding to data from User Group Web Service, 316-318
ListItem property (SPItemEventProperties class), 74
ListItemId property (SPItemEventProperties class), 74
ListItems property (SPListItem class), 51
ListMetaLogger class, 72-73
ListPictureLibrary( ) method, 257-258
ListRetriever application, 276-277
lists
accessing, 206-209
BDC
custom, columns, 118-119
data, accessing, 59-62
columns, 274-275
contents, viewing, 51-53
creating, 53-55
data entry, 210
deleting, 53-55
enumerating, 48-51
events, 71
handlers, 69
receivers, 70-73
fields, extracting, 7-8
hierarchy, 206
items
event receivers, creating, 73-76
events, 75
filtering, 287-288
hierarchical, querying, 283-285
hierarchical, traversing, 66-67
querying, 62-64
retrieving, 275-277
revision control, 286
values, accessing, 53
lookup data, 58
managing, 47
manipulation listing, 54
Meeting Series, 100-101
parent/child relationships
content types, creating, 65
creating, 64
hierarchical list, traversing, 66-67
picture library images, retrieving, 258-260
querying, 8-11
retrieving, 275-277
schema changing code, testing, 279
schemas, 277
Site Feature, 79
templates, 80
updating, 53-55, 209-210-215
cautions, 214
data entry functionality, 213
Lists Web Service, 278-281
Timesheet Entry Web Part example, 210-213
views, 289
Web Part property values, selecting, 195-196
Lists property
SPList class, 49
SPWeb class, 43
Lists Web Service, lists, 273
creating, 281-282
deleting, 281-282
filtering, 287-288
hierarchical, querying, 283-285
retrieving, 275-277
revision control, 286
updating, 278-282
ListTemplates property (SPWeb class), 43
ListTitle property
SPItemEventProperties class, 74
SPListEventProperties class, 71
LoadPostBackData( ) method, 170-172
LOB system and entity, creating, 122-123
LobSystemInstanceStruct structure properties, 348
local development environment, 19-20
Locale property (SPWeb class), 43
lookup data (lists), 58
Lt element, 6
M
MajorVersion property (SPFile class), 85
MajorVersionLimit column (lists), 275
MajorVersionLimit property (SPList class), 49
MajorwithMinorVersionLimit column (lists), 275
MajorWithMinorVersionsLimit property (SPList class), 49
MakeFullUrl( ) method, 38
managing
Document Workspace users, 253
Excel workbooks, 322
lists, 47
Web Parts, 175-176
MasterUrl property (SPWeb class), 43
Meeting Series columns, 300
Meeting Series list, 100-101
Meeting Workspaces, 291
available, listing, 293-294
deleting, 296-297
details, modifying, 297
lists, 100
Meeting Series list, 100-101
meetings
attendance, 302-303
attendee responses, 105
calendar events, linking, 105
lists, 304
modifying, 104
restoring, 302
updating, 301
sites, creating, 292
templates, 295
meetings
attendance, 302-303
attendee responses, 105
calendar events, linking, 105
lists, 304
modifying, 104
recurring, 101
restoring, 302
updating, 301
MembershipManager class
GetCommonManager( ) method, 145
GetCommonMemberships( ) method, 145
metadata
BDC, 124-126
Document Workspace, 246-247
methods
Add( )
EventReceivers collection, 77
Solutions collection, 32
SPFeatureDefinitionCollection class, 31
SPMeeting class, 103
AddMeetingFromiCal( ), 299
AlterTask( ), 365
BDC entities, 110
Cancel( ), 104
CanCreateDwsUrl( ), 242
CheckIn( ), 91
CheckOut( ), 91
ClaimReleaseTask( ), 366
Create( ), 143
CreateChildControls( ), 199, 202-203
CreateDws( ), 242
CreateUserProfile( ), 143
ddMeeting( ), 298
Delete( ), 99
DeleteWorkspce( ), 297
Deploy( ), 34
enumerating, 352-353
Excel Services Web Service, 325-326
FindDwsDoc( ), 251
GetAlerts( ), 381
GetCommonManager( ), 145
GetCommonMemberships( ), 145
GetCustomerID( ), 220
GetDwsData( ), 244-246
GetDwsMetaData( ), 246-247
GetSafeAssemblyInfo( ), 345
GetServerInfo( ), 376
GetTemplatesForItem( ), 366
GetWebPart( ), 344
Imaging Web Service, 256
instance structures (BDC), 351
LinkWithEvent( ), 105
LoadPostBackData( ), 170-172
PostBacks( ), 170-172
RaisePostDataChangedEvent( ), 170-172
Remove( ), 32
RemoveDwsUser( ), 253
RemoveMeeting( ), 300
Render( )
ExpandingTextBox class, 170
Web Parts, 199
Resolve( ), 356
RestoreMeeting( ), 302
Retract( ), 34
SaveBinary( ), 93
SendToOfficialFile( ), 373
SetAttendeeResponse( ), 105
SetCustomer( ), 223
SetWorkspaceTitle( ), 297
SpellCheck( ), 378
SPFile class, 94
SPFolder class, 94
SPList( ), 55
SPList class, 55
SPListItem class, 57
SPSite class, 38
SPWeb class, 44
StartWorkflow( ), 367
SubmitFile( ), 375
Update( )
SPListItem class, 214
SPMeeting class, 104-105
UpdateList( ), 278
UpdateMeetingFromICal( ), 301
User Group Web Services, 315-316
User Profile Web Change Web Service, 312-314
User Profile Web Services, 308-309
Web Part Pages Web Service, 337-339
MethodStruct structure, 351
Microsoft Office SharePoint Server (MOSS), 15
Microsoft.Office.Server namespace, 16
Microsoft.SharePoint namespace, 16
MinorVersion property (SPFile class), 85
MobileDefaultViewUrl property (SPList class), 49
modeling workflows, 153-155
Modified column (lists), 274
modifying
list data, 213-215
Meeting Workspace details, 297
meetings, 104
records centers, 372
user profiles, 140
Web Parts. See also properties, Web Parts
JavaScript, adding, 204
postbacks, 203
rendering in browsers, 199
SQLExecute example, 199-203
template, 198-199
web controls, 199
workflow tasks, 365-366
ModifyUserPropertyByAccountName( ) method, 309
MOSS (Microsoft Office SharePoint Server), 15
MoveTo( ) method, 94
moving files/folders, 94
MSI-based Web Part deployment, 235
MulitpleDataList column (lists), 275
MultipleDataList property
SPList class, 49
UpdateList( ) method, 279
multivalued properties, 144
N
Name column (lists), 274
Name property
SPFile class, 85
SPFolder class, 86
SPListItem class, 51
SPSolution class, 33
SPWeb class, 43
naming images, 263
Navigation property (SPWeb class), 43
Neq element, 6
NoCrawl property (SPList class), 49
Northwind database, 219-220
numeric textbox server control, 167-168
O
object models
applications on the server, developing, 17-18
BDC
administration, 121-123
runtime. See BDC, runtime API
classes, 16
console application
creating, 21-22
deploying, 22-23
document libraries support, 84
Features
activating/deactivating, 29-30
classes, 26
collections, accessing, 26
enumerating, 27-29
Feature definitions, 27-31
properties, 30-31
namespaces, 16
remote applications, developing, 18
Solutions
deleting, 32
deploying, 34
enumerating, 32-33
installing, 32
user profiles
change log history query, 140-142
common data, retrieving, 145-146
creating, 143
groups, adding, 145
modifying, 140
properties, 143-144
property retrieval, 137-139
retrieving, 135-137
Web Parts, developing, 18
objective fields (Meeting Workspaces), 304
objects
core, 207
.List, 207
.Site, 207
SPContext, 207-209
SPFeatureProperty, 30
SPQuery, 7
.Web, 207
Official File Web Service
querying, 374-375
record repositories, creating, 375-376
Records Center, 370
offline files, 94
OpenBinary( ) method, 94
OpenWeb( ) method, 38
OpenWorkbook( ) method, 325
Order Item content type, 65
Order Parent content type, 65
Ordered column (lists), 275
Ordered property (UpdateList( ) method), 279
Owner property (SPSite class), 37
P
packaging Features, 26
PageCatalogPart control, 174
parent/child relationships (lists), 64
content types, creating, 65
hierarchical list, traversing, 66-67
ParentFolder property
SPFile class, 85
SPFolder class, 86
ParentList property (SPListItem class), 51
ParentListId property (SPFolder class), 86
ParentWeb property
SPFolder class, 86
SPList class, 49
SPWeb class, 43
ParentWebUrl property (SPList class), 49
Passthrough authentication mode (BDC), 110
Personalization attribute, 194
photo album browser application, 267-272
photos. See images
picture libraries, 94, 255-256
enumerating, 258
folders, creating, 263-264
images
deleting, 263
downloading, 262
renaming, 263
retrieving, 258-261
uploading, 261-262
Imaging Web Service, 256-257
photo browser example, 266-272
Port property (SPSite class), 37
PortalMember property (SPWeb class), 43
PortalName property (SPWeb class), 43
PortalSubscription property (SPWeb class), 43
PortalUrl property
SPSite class, 37
SPWeb class, 43
postbacks (Web Parts), 203
PostBacks( ) method, 170-172
posting data back to servers, 170-172
PresenceEnabled property (SPWeb class), 43
ProfilePropertyCollection class, 143
profiles (user)
change history, 312-313
change log history query, 140-142
choice list properties, 144
common data, retrieving, 145-146
creating, 143
groups, adding, 145
modifying, 140
new features, 307-308
properties
creating, 143-144
multivalued properties, 144
retrieving, 135-137
User Profile Web Service, 308-309
value separators for properties, 144
Program.cs file, 21-22
properties
BackColor, 168
ConsumerConnectionPoint, 224
ConsumerID, 224
CorrelationToken, 155
Current, 207
CustomerID, 218
Feature definitions, 30-31
FeatureDefinitions, 27
ID, 224
Line of Business system instance, 348
list updatable, 278
LobSystemInstanceStruct structure, 348
MethodStruct structure, 351
Properties, 30
ProviderID, 224
Sites, 35
Solutions, 32
SPFile class, 84-85
SPFolder class, 86
SPItemEventProperties class, 74
SPList class, 48-50
SPListEventProperties, 71
SPListItem class, 51
SPSite class, 36-38
SPSolution class, 33
SPWeb class, 42-43
user profiles
choice list, 144
creating, 143-144
multivalued, 144
value separators, 144
Web Parts, 191-195
attributes, 194-195
selecting from lists, 195-196
SimpleLoanCalculator example, 192-194
WebApplication, 22
Properties property
SPFeaturePropertyCollection collection, 30
SPFile class, 85
SPFolder class, 86
SPListItem class, 51
SPSolution class, 33
PropertiesXml property (SPList class), 49
property bags, 30
PropertyGridEditorPart control, 174
Protocol property (SPSite class), 37
provider Web Parts, 217
connecting with consumer Web Parts, 223-226
data interface, 218
Web Part, creating, 218-220
ProviderID property (WebPartManager class), 224
ProxyWebPartManager control, 173
PublicKeyToken, 186
Publish( ) method, 94
publishing files, 94
Q
queries (CAML)
creating, 6
U2U CAML Query Builder, 11
querying
BDC metadata, 124-126
Official File Web Service, 374-375
Web Part pages, 344-345
R
RaisePostDataChangedEvent( ) method, 170-172
RdbCredentials authentication mode (BDC), 110
ReadLocked property (SPSite class), 37
ReadOnly property (SPSite class), 37
ReceiverData property
SPItemEventProperties class, 74
SPListEventProperties class, 71
record routing rules, adding, 370
Records Center
connections, configuring, 370
files, submitting, 373-374
modifying, 372
Official File Web Service
linking, 370
querying, 374-375
record routing rules, 370
site definition, 370
records repositories
creating, 375-376
files, submitting, 373-374
metadata information storage example, 372
Official File Web Service, 374-375
overview, 369
Records Center
connections, configuring, 370
files, submitting, 373-374
modifying, 372
Official File Web Service, 370, 374-375
record routing rules, 370
site definition, 370
recurring meetings, 101
Recycle Bin, 94
Recycle( ) method, 94
RecycleBin property
SPSite class, 37
SPWeb class, 43
references
Assembly, 21-22
System.Web.dll file, 178
Refresh( ) method, 325
relational data, exposing, 133
RelativeWebUrl property (SPItemEventProperties class), 74
releasing workflow tasks, 366
remote applications, developing, 18
remote development environment, 20-21
Remove( ) method, 32
RemoveColleague( ) method, 309
RemoveDwsUser( ) method, 253
RemoveGroup( ) method, 316
RemoveGroupFromRole( ) method, 316
RemoveLink( ) method, 309
RemoveMeeting( ) method, 300
RemoveMembership( ) method, 309
RemovePinnedLink( ) method, 309
RemoveRole( ) method, 316
RemoveUserCollectionFromGroup( ) method, 316
RemoveUserCollectionFromRole( ) method, 316
RemoveUserCollectionFromSite( ) method, 316
RemoveUserFromGroup( ) method, 316
RemoveUserFromRole( ) method, 316
RemoveUserFromSite( ) method, 316
RemoveUserFromWeb( ) method, 316
RemoveWorkflowAssociation( ) method, 339
Rename( ) method, 257
renaming images, 263
Render( ) method
ExpandingTextBox class, 170
Web Parts, 199
RenderAsHtml( ) method, 55
RenderWebPartForEdit( ) method, 339
RequireCheckout column (lists), 275
Resolve( ) method, 356
RestoreMeeting( ) method, 302
restoring
files, 94
meetings, 302
Retract( ) method, 34
retrieving
commonalities among user profiles, 145-146
Document Workspace data, 244-247
list items, 275-277
picture library images
IDs, 260
lists, 258-260
XML data, 260-261
task data, 367
user profile properties, 135-139, 310-311
workflows
data, 361-362
tasks, 362-365
templates, 366-367
RevertToSelf authentication mode (BDC), 110
revision control (lists), 286
RootFolder column (lists), 274
RootFolder property
SPList class, 50
SPWeb class, 43
RootWeb property (SPSite class), 37
S
Safe Assemblies, 345
SaveAsTemplate( ) method
SPList class, 55
SPWeb class, 44
SaveBinary( ) method, 93-94
SaveWebPart( ) method, 339
SaveWebPart2( ) method, 339
saving
files, 94
server controls to ViewState, 170-172
schemas (lists), 277
SchemaXml property (SPList class), 50
ScopeId column (lists), 275
SearchDocuments( ) method, 44
SearchListItems( ) method, 44
SearchServiceInstance property (SPSite class), 37
SecondaryContact property (SPSite class), 37
security groups, 316-318
SelfServiceCreateSite( ) method, 38
SendToLocation column (lists), 275
SendToLocationName property (SPList class), 50
SendToLocationUrl property (SPList class), 50
SendToOfficialFile( ) method, 373
server controls
ASP.NET integration, 184
building, 166-168
extending, 168-172
saving to ViewState, 170-172
user controls, compared, 163-166
ServerRedirected property (SPFile class), 85
ServerRelativeUrl property
SPFile class, 85
SPFolder class, 86
SPSite class, 37
SPWeb class, 43
servers
applications on, developing, 17-18
posting data back to, 170-172
ServerTemplate column (lists), 274
services
Excel, 322
application logic, 322
architecture, 323
business intelligence, 322
Excel Calculation Services, 324
Excel Web Access, 324
hello world example, 326-328
multiple named ranges client application example, 328-329
reading/writing ranges and saving temporary workbooks application, 329-332
trusted locations, 326
user-defined functions, creating, 332-335
user-defined libraries, 334
web service, 325-326
workbook management, 322
web. See web services
SetAttendeeResponse( ) method, 105
SetCell( ) method, 325
SetCellA1( ) method, 326
SetCustomer( ) method, 223
SetRange( ) method, 326
SetRangeA1( ) method, 326
setup projects, adding, 235
SetWorkspaceTitle( ) method, 297
Sharepoint 2007 SDK template, 148
ShowUser column (lists), 275
ShowUser property (UpdateList( ) method), 279
SimpleLoanCalculator Web Part, 192-194
Single Sign-On authentication mode (BDC), 110
site collections
creating, 39-41
defined, 35
hierarchy, 36
information, accessing, 41
listing, 35
SPSite class, 36-38
site context console application
creating, 21-22
deploying, 22-23
Site Feature list, 79
Site( ) method, 315
.Site object, 207
Site property (SPWeb class), 43
SiteId property
SPItemEventProperties class, 74
SPListEventProperties class, 71
SiteLogoUrl property (SPWeb class), 43
sites
Document Workspace, 241
creating, 242-244
data, retrieving, 244-246
deleting, 243-244
document ID storage, 251-252
folders, 248
metadata, retrieving, 246-247
URLs, validating, 242
users, managing, 253
Meeting Workspaces, 291
available, listing, 293-294
creating, 292
details, modifying, 297
Sites property (SPWebApplication class), 35
SmartPart, 183
SolutionFile property (SPSolution class), 33
SolutionId property (SPSolution class), 33
Solutions
deleting, 32
deploying, 34
enumerating, 32-33
installing, 32
Solutions collection, 32
Solutions property, 32
SourceLeafName property (SPFile class), 85
SourceUIVersion property (SPFile class), 85
SPChangeToken class, 314
SPContext class, 21
SPContext object, 207
Current property, 207
referencing timesheet list, 208-209
SPElementDefinition class, 26
Spell Checker Web Service, 377-379
SpellCheck( ) method, 378
SPEventReceiverBase class, 70
SPFarm class
FeatureDefinitions property, 27
instance of, creating, 27-29
SPFeature class, 26
SPFeatureCollection class, 26
SPFeatureDefinition class, 26
SPFeatureDefinitionCollection class, 31
SPFeatureDependency class, 26
SPFeatureProperty class, 26
SPFeatureProperty objects, 30
SPFeaturePropertyCollection class, 26
SPFeaturePropertyCollection collection, 30
SPFeatureScope class, 26
SPFile class
methods, 91-94
properties, 84-85
submitting files to records repositories, 373-374
SPFolder class
methods, 94
properties, 86
SPItemEventProperties class, 74
SPItemEventReceiver class, 69
SPList class
lists, enumerating, 50-51
methods, 55
properties, 48-50
AlertTemplate, 48-49
AllowContentTypes, 48
AllowDeletion, 48
AllowEveryoneViewItems, 48
AllowMultiResponses, 48
AllowRssFeeds, 48
Audit, 48
BaseTemplate, 48
BaseType, 48
CanReceiveEmail, 48
ContentTypes, 48
ContentTypesEnabled, 48
Created, 48
CurrentChangeToken, 48
DefaultItemOpen, 48
DefaultView, 48
DefaultViewUrl, 48
Description, 48
Direction, 48
DraftVersionVisibility, 48
EmailAlias, 48
EnableAttachments, 49
EnableFolderCreation, 49
EnableMinorVersions, 49
EnableModeration, 49
EnableVersioning, 49
Event, 49
Fields, 49
Folders, 49
Forms, 49
Hidden, 49
ImageUrl, 49
ItemCount, 49
Items, 49
LastItemDeletedDate, 49
LastItemModifiedDate, 49
Lists, 49
MajorVersionLimit, 49
MajorWithMinorVersionsLimit, 49
MobileDefaultViewUrl, 49
MultipleDataList, 49
NoCrawl, 49
ParentWeb, 49
ParentWebUrl, 49
PropertiesXml, 49
RootFolder, 50
SchemaXml, 50
SendToLocationName, 50
SendToLocationUrl, 50
Title, 50
Version, 50
Views, 50
WorkflowAssociations, 50
SPListEventProperties class, 71
SPListEventReceiver class, 70
SPListItem class
lists
contents, viewing, 52
values, accessing, 53
methods, 57
properties, 51
Update method, 214
SPMeeting class, 99
Add( ) method, 103
Cancel( ) method, 104
LinkWithEvent( ) method, 105
SetAttendeeResponse( ) method, 105
Update( ) method, 104-105
SPQuery object, 7
SPSite class, 35-36
Features property, 27
instance of, creating, 27-29
methods, 38
properties, 36-38
AllowRssFeeds, 36
AllowUnsafeUpdates, 36
AllWebs, 36
Audit, 36
CatchAccessDeniedException, 36
CertificationDate, 36
ContentDatabase, 36
CurrentChangeToken, 36
DeadWebNotificationCount, 37
Features, 37
HostHeaderIsSiteName, 37
IISAllowsAnonymous, 37
Impersonating, 37
LastContentModifiedDate, 37
LastSecurityModifiedDate, 37
Owner, 37
Port, 37
PortalUrl, 37
Protocol, 37
ReadLocked, 37
ReadOnly, 37
RecycleBin, 37
RootWeb, 37
SearchServiceInstance, 37
SecondaryContact, 37
ServerRelativeUrl, 37
SyndicationEnabled, 37
UpgradeRedirectedUri, 37
Url, 37
Usage, 37
WebApplication, 38
WorkflowManager, 38
WriteLocked, 38
Zone, 38
site collections
creating, 39-41
information, accessing, 41
updating, 42
SPSiteCollection class, 35-36
SPSolution class, 32
deploy methods, 34
properties, 33
Delete( ) method, 99
Features property, 27
methods, 44
properties, 42-43
webs
creating, 44-45
information, accessing, 45
updating, 46
SPWebApplication class, 35-36
SPWebPartManager class, 185
SPWorkflow class, 365
SQLExecute Web Part, 197
controls, 202
CreateChildControls event, 202-203
listing, 199-202
postbakcs, 203
starting workflows, 367
StartWorkflow( ) method, 360, 367
Status property
SPItemEventProperties class, 74
SPListEventProperties class, 71
StorageManagementInformation( ) method, 38
strong naming Assemblies, 180
stsadm.exe command, 79
style sheets, 213
SubFolders property (SPFolder class), 86
SubmitFile( ) method, 375
SyndicationEnabled property (SPSite class), 37
System.Web.dll file, 178
T
TakeOffline( ) method, 94
tasks
claiming, 366
data, retrieving, 367
modifying, 365-366
releasing, 366
retrieving, 362-365
Tasks property (SPListItem class), 51
templates
lists, 80
Meeting Workspaces, 295
Web Custom Control, 166
web IDs, 40-41
Web Parts, 198-199
WF, 147-148
testing
Assembly references, 21-22
schema changing code for lists, 279
Web Parts, 181-183
TextBox class, 166
Theme property (SPWeb class), 43
things to bring fields (Meeting Workspaces), 304
ThumbnailSize column (lists), 274
time sheet list example, 205
accessing, 206-209
data entry, 210
hierarchy, 206
updating, 209-215
TimeCreated property (SPFile class), 85
TimeLastModified property (SPFile class), 85
Timesheet Entry Web Part example, 210-213
Title column (lists), 274
Title property
SPFile class, 85
SPList class, 50
SPListItem class, 51
SPWeb class, 43
UpdateList( ) method, 279
tools
FieldRef extraction, 7-8
third-party Web Parts, 183
U2U CAML Query Builder, 11
Web Parts, 183
TotalLength property (SPFile class), 85
transform states, 94
trusts (domain-level), configuring, 151
txtSQL control, 202
U
U2U CAML Query Builder, 11
UIVersion property (SPFile class), 85
UIVersionLabel property (SPFile class), 85
Unclassified Records library, 370, 375
UndoCheckOut( ) method, 94
uniform resource locators (URLs), 242
UniqueID parameter, 220
UniqueId property
SPFile class, 85
SPFolder class, 86
SPListItem class, 51
UnPublish( ) method, 94
Update( ) method
SPFile class, 94
SPFolder class, 94
SPList class, 55
SPMeeting class, 104-105
SPWeb class, 44
UpdateColleaguePrivacy( ) method, 309
UpdateGroupInfo( ) method, 316
UpdateLink( ) method, 309
UpdateList( ) method, 278
UpdateMeetingFromICal( ) method, 301
UpdateMembershipPrivacy( ) method, 309
UpdateOverwriteVersion( ) method, 57
UpdatePinnedLink( ) method, 309
UpdateRoleDefInfo( ) method, 316
UpdateRoleInfo( ) method, 316
UpdateUserInfo( ) method, 316
updating
files, 94
folders, 94
cautions, 214
data entry functionality, 213
Lists Web Service, 278-282
Timesheet Entry Web Part example, 210-213
meetings, 301
site collections, 42
Web Parts, 342-343
webs, 46
UpgradeRedirectUrl property (SPSite class), 37
uploading
documents to document libraries, 84
images to picture libraries, 261-262
Url property
SPFile class, 85
SPFolder class, 86
SPListItem class, 51
SPSite class, 37
SPWeb class, 43
URLs (uniform resource locators), 242
Usage property (SPSite class), 37
user controls
ASP.NET integration, 184
information collection user control, 164-165
server controls, compared, 163-166
methods, 315-316
WPF data binding, 316-318
user groups
security principles, enumerating, 316-318
User Group Web Service, 315-316
User Profile Web Change Web Service, 312-314
User Profile Web Service
methods, 308-309
user profile properties, retrieving, 310-311
user profiles
change history, 312-313
change log history query, 140-142
common data, retrieving, 145-146
creating, 143
groups, adding, 145
modifying, 140
new features, 307-308
properties
choice list, 144
creating, 143-144
multivalued, 144
retrieving, 137-139
value separators, 144
properties, retrieving, 310-311
User Profile Web Service, 308-309
user-defined functions, 332-335
user-defined libraries, 334
UserDisplayName property
SPItemEventProperties class, 74
SPListEventProperties class, 71
UserLoginName property
SPItemEventProperties class, 74
SPListEventProperties class, 71
UserProfileManager class, 135, 143
utilities. See tools
V
ValidateWorkflowMarkupAndCreateSupport-Objects( ) method, 339
validating Document Workspace URLs, 242
value separators (properties), 144
VBA (Visual Basic for Applications), 332-335
verifying Global Assembly Cache, 237
versioning, 91
checking files in/out, 91
example, 91-93
Version column (lists), 274
Version property (SPList class), 50
Versionless property (SPItemEventProperties class), 74
Versions property
SPFile class, 85
SPListItem class, 51
Versions Web Service, 383-384
views
alerts, 379-382
built-in style sheets, 213
creating, 288-289
deleting, 289
list contents, 51-53
list of, 289
user profile changes, 312-313
Views property (SPList class), 50
Views Web Service, views, 288-289
ViewState of server controls, 170-172
Visual Basic for Applications (VBA), 332-335
Visual C# 2005 Express Edition download, 18
Visual Studio 2005
Extensions for Windows Workflow Foundation, 148
Web Parts, debugging, 230-231
web references, adding, 287
workflows, modeling, 153-155
W
web applications
hierarchy, 36
site collections, 35
Web Custom Controls, 166
.Web object, 207
Web Part pages
querying, 344-345
Safe Assemblies, 345
Web Parts
adding, 339-341
updating, 342-343
Web Service
adding Web Parts, 339-341
methods, 337-339
Safe Assemblies, 345
Web Part pages, querying, 344-345
updating Web Parts, 342-343
Web Parts
adding to Web Part pages, 339-341
BDC, 114-116
connecting, 223-226
consumers, 221-223
controls, 173
CatalogZone, 178
WebPartManager, 175-176
WebPartZones, 178
debugging, 229-230
breakpoints, setting, 231-233
common SharePoint server, 234
development workstations, 229-230
local SharePoint server, 234
Visual Studio 2005, 230-231
Web Part library, compiling, 231
without SharePoint or WSS, 233
deploying, 235
compiling setup project, 237
configuring setup project, 236
MSI-based, 235
setup projects, adding, 235
design mode, 177
functionality, 197
HelloWorld example, 179-180
importing, 188
integration, 174
JavaScript, adding, 204
layout, 197
library, compiling, 231
lists
accessing, 206-209
data entry, 210
updating, 209-215
managing, 175-176
postbacks, 203
properties, 191-195
attributes, 194-195
selecting from lists, 195-196
SimpleLoanCalculator example, 192-194
providers, 217-220
rendering in browsers, 199
SharePoint, 185-188
SQLExecute example, 197
controls, 202
CreateChildControls event, 202-203
listing, 199-202
postbacks, 203
System.Web.dll file reference, 178
template, 198-199
testing, 181-183
third-party tools, 183
time sheet list example, 205-206
Timesheet Entry Web Part example listing, 210-213
updating, 342-343
web controls, adding, 199
zones, 178
Web property
SPListEventProperties class, 71
SPListItem class, 51
web references, adding, 287
web services
Alerts, 379-382
authentication, 299
BDC, 348
compatible, 132
entities, enumerating, 350-351
Field Resolver, 355-356
filter descriptors, enumerating, 354
Line of Business systems, 348-349
methods, 351-353
Document Workspace
data, retrieving, 244-246
folders, 248
metadata, retrieving, 246-247
Excel Services, 325
hello world example, 326-328
methods, 325-326
multiple named ranges client application example, 328-329
reading/writing ranges and saving temporary workbooks applications, 329-332
trusted locations, configuring, 326
Lists, 273
creating list items, 281-282
deleting list items, 281-282
filtering, 287-288
querying hierarchical list items, 283-285
retrieving lists/list items, 275-277
revision control, 286
updating, 278-282
Official File
querying, 374-375
record repositories, creating, 375-376
Records Center, 370
Spell Checker, 377-379
User Group
methods, 315-316
WPF data binding, 316-318
User Profile
methods, 308-309
user profile properties, retrieving, 310-311
User Profile Web Change, 312-314
Versions, 383-384
Views, 288-289
Web Part Pages
adding Web Parts, 339-341
methods, 337-339
querying, 344-345
Safe Assemblies, 345
updating Web Parts, 342-343
Workflow
methods, 360
starting workflows, 367
tasks, 362-367
templates, retrieving, 366-367
workflow data, retrieving, 361-362
Visual C# 2005 Express Edition download, 18
web template IDs, 40-41
WebApplication property (SPSite class), 22, 38
WebBrowsable attribute, 194
WebControl class, 166
WebDescription attribute, 194
WebDisplayName attribute, 194
WebFullUrl column (lists), 275
WebId column (lists), 275
WebId property (SPListEventProperties class), 71
WebImageHeight column (lists), 274
WebImageWidth column (lists), 274
WebPart class (SharePoint versus ASP.NET), 185
WebPartConnection Collection Editor, 223
WebPartManager class
static connection properties, 224
Web Parts, connecting, 223
WebPartManager control, 173-176
WebPartZone class, 185
WebPartZone control, 173
webs
creating, 44-45
information, accessing, 45
SPWeb class, 42-43
updating, 46
Webs property (SPWeb class), 43
websites
AdventureWorks SQL database, 113
hierarchy, 36
Sharepoint 2007 SDK, 148
SmartPart, 183
U2U CAML Query Builder download, 11
Visual Studio 2005 Extensions for Windows Workflow Foundation template, 148
WebUrl property
SPItemEventProperties class, 74
SPListEventProperties class, 71
WelcomePage property (SPFolder class), 86
WF (Windows Workflow Foundation), 147, 359
templates, installing, 147-148
Workflow Web Service
methods, 360
tasks, 365-367
templates, retrieving, 366-367
workflow data, retrieving, 361-362
workflows, starting, 367
wildcard Finders, 130-131
Windows Forms applications
DocLibPicker.cs, 89-90
Feature Enumerator, 29
Form1.cs, 86-88
Windows Presentation Foundation (WPF), 316
Windows SharePoint Services (WSS), 15
Windows Workflow Foundation. See WF
WindowsCredentials authentication mode (BDC), 111
WinForms applications
creating, 21-22
deploying, 22-23
workbooks (Excel). See also Excel Services
application logic, 322
business intelligence, 322
hello world example, 326-328
managing, 322
multiple named ranges client application example, 328-329
reading/writing ranges and saving temporary workbooks application, 329-332
Workflow Web Service
methods, 360
tasks
claiming, 366
data, retrieving, 367
modifying, 365-366
releasing, 366
retrieving, 362-365
templates, retrieving, 366-367
workflows
data, retrieving, 361-362
starting, 367
workflow.xml file, 157
WorkflowAssociations property (SPList class), 50
WorkflowId column (lists), 275
WorkflowManager property (SPSite class), 38
approval, 148
associations, 150
batch file for installation file, 158-159
building, 150
coding, 155-156
data, retrieving, 361-362
deploying, 156-159
feature.xml file, 156-157
forms, designing, 151-153
HelloWorldSequentialWorkflow Assembly
features.xml file, 156-157
install.bat file, 158-159
workflow designer, 155
workflow.xml file, 157
instances, 150
modeling, 153-155
starting, 367
submitting files to records repositories, 373
support, 153
tasks
claiming, 366
data, retrieving, 367
modifying, 365-366
releasing, 366
retrieving, 362-365
Web Service, 360
workflow.xml file, 157
Workflows property (SPListItem class), 51
WorkflowTemplates property (SPWeb class), 43
workspaces
Document
creating, 242-244
data, retrieving, 244-246
deleting, 243-244
document ID storage, 251-252
folders, 248
metadata, retrieving, 246-247
overview, 241
URLs, validating, 242
users, managing, 253
Meeting, 291
attendee responses, 105
available, listing, 293-294
calendar events, linking, 105
creating meetings, 102-104, 298-299
deleting, 296-297
deleting meetings, 104, 300-301
details, modifying, 297
meeting attendance, 302-303
Meeting Series list, 100-101
modifying meetings, 104
restoring meetings, 302
sites, creating, 292
templates, 295
updating meetings, 301
WPF (Windows Presentation Foundation), 316
WriteLocked property (SPSite class), 38
WriteRssFeed method (SPList class), 55
WriteSecurity column (lists), 274
WSS (Windows SharePoint Services), 15
X–Z
XML data, 260-261
Xml property (SPListItem class), 51
Zone property
SPItemEventProperties class, 74
SPSite class, 38
zones (Web Parts), 178