Posts

Showing posts from January, 2011

Experiencing the Microsoft SharePoint 2010 User Interface

Image
Microsoft SharePoint 2010 includes an enhanced user interface that provides IT professionals with a streamlined administration experience. This Learning Snack describes the features of the SharePoint 2010 user interface. It demonstrates how the new Central Administration console enables you to perform several administrative tasks from one central location. The Learning Snack also describes how Shared Application Architecture can be used for flexible deployments in SharePoint 2010. Experiencing the Microsoft SharePoint 2010 User Interface by MSL

Developing Solutions with Microsoft SharePoint 2010

Image
Microsoft SharePoint 2010 enables developers to build rich solutions easily, rapidly, and efficiently. This Learning Snack demonstrates how you can use Microsoft Visual Studio 2010 to create and deploy your solutions. It also demonstrates how you can build Silverlight applications using the SharePoint 2010 client object model and use LINQ to SharePoint to create SharePoint entities. Developing Solutions with Microsoft SharePoint 2010 by MSL

SharePoint List Batch Update

I was required to add and delete nearly 100 items (it may grow) in a list. If we do it in normal procedure we will definitely face performance issue and also there is a chance of Request timed out error . Calling SPListItem.Update()  or SPListItem.Delete() method for every record is not recommended, because every time it hits the database. SPList lstData = web.GetList(web.Url + "/Lists/Ratio"); SPListItemCollection itmColl = lstData.GetItems(lstData.DefaultView); //assume the datatable dtData have 100 records foreach(DataRow dr in dtData.Rows) {        SPListItem itemData = itmColl.Add();        itemData["Title"] = dr["title"].ToString();        itemData["PaperCount"] = dr["PaperCount"].ToString();        itemData.Update(); } The above code may take more time to complete the operation. Then one thing came up into my mind don't we have a kind of batch insert/update commands like SQL server...

SharePoint Calculated Field Functions and Formulas

Today, I got required to implement a standard deviation in SharePoint list based on other columns and then I thought of use calculated field to do this. So I don't know much what are the functions available and how to implement custom logic for standard deviation. After searching some time in google, I found there is a function STSDEV to do this. Also I find following good links about all functions and formulas that can be used in calculated fields. http://www.sharepointpanda.com/2009/04/29/sharepoint-calculated-field-functions-and-formulas/ http://msdn.microsoft.com/en-us/library/bb862071.aspx

3 Must-Know Technologies for Every SharePoint Developer

SharePoint is a huge platform, and there are many competing technologies for you to learn to become a proficient SharePoint developer. However, three areas stand out above all others: Silverlight, JQuery, and Windows Azure. Although each one of these on its own can fill volumes, let’s briefly look at each technology and see why it’s so important to SharePoint. Silverlight Silverlight is a platform for creating rich and interactive experiences on the web, on the desktop, and on mobile devices. Silverlight enables you to take your SharePoint site to the next level. You can easily integrate rich media experiences in your sites. Silverlight has great tooling support for developers using Visual Studio 2010 and for designers using Expression Blend 4. The Silverlight tools will reduce the time it takes to build, debug, and deploy your SharePoint applications. Learning Silverlight is straightforward for .NET developers and even easier if you have Windows Presentation Foundation (WPF) exper...

SharePoint 2010 Client Object Model

If you want to access SharePoint Server 2007 Data, you have two ways of doing it (based on your needs): 1. Writing a Server Application          This application resides in server 2. Writing a Client Application          This client application can run from any other server or a desktop Server Application We interact with the Server Object Model, which are nothing but SharePoint APIs and build applications. For example : List<Announcement> announcements = new List<Announcement>(); SPSite site = SPContext.GetContext(HttpContext.Current).Site; using (SPWeb curWeb = site.OpenWeb()) {       SPList lstAnnouncements = curWeb.Lists[new Guid(LibraryName)];       //rest of the code } Client Application We use the SharePoint Web Services which then interacts with the SharePoint API. Usually, developers either build their own set of web services which exposes only certain methods...

SharePoint Features in Visual Studio 2010

As you probably know, Visual Studio 2010 contains a lot of great features and project templates for SharePoint developers. Below is a short overview for some of the SharePoint development related features and project templates. Configurable deployment With all new SharePoint project templates you can leverage new configurable deployment feature which lets you configure the way you want to deploy or retract your project. Besides using provided, out of the box deployment steps (Run Pre-Deployment Command, Run Post-Deployment Command, Recycle IIS Application Pool, Retract Solution, Add Solution, and Activate Features) you can use SharePoint extensibility to create your own, custom deployment steps and deployment configurations. Sandboxed and farm solutions Some SharePoint projects can be deployed either as sandboxed or farm solutions. Sandboxed solutions run in a secure and monitored process that has limited resource access and with farm solutions user must have SharePoint administrator p...

SPQuery with Pagination

Today, I have come across with performance issue while querying items from a list, Where my list contains nearly 1000 items. So, to resolve this it's better to query some no.of items instead of querying all items by using RowLimit  property of SPQuery class. But we can query all the time 'n' number of items only, means suppose you have given RowLimit is 100 then you will get 100 items only, so next time if you want items from 101 you have to use SPListItemCollectionPostion class. Using these both properties we can implement paging in the same way how the list is offering paging to us. I have found following good article on this. http://blogs.msdn.com/b/colbyafrica/archive/2009/02/19/learning-sharepoint-part-vi-list-pagination.aspx One more important thing is, in SharePoint 2010 we will not be able to query more than 5000 items at a time due to list view threshold limit. The following code snippet helps you to query all items and keep it in datatable....

Performance fine tuning with SharePoint Object Model

Scenario 1 : Retrieve SPList instance SPWeb.Lists (“name”) – Not Good           using ( SPSite site = new SPSite (strSite))             {                 using ( SPWeb web = site.OpenWeb())                 {                     SPList oList = web.Lists [" MyList "]                 }              } In this case, it loads the metadata * of the all lists in that specific SPWeb object. Then it does SPList.Title comparison with metadata of all the lists returned and then it returns the matching list fr...