Showing posts with label Sharepoint. Show all posts

JavaScript, CSS3, Silverlight, ASP.NET, SharePoint articles Link List – July 2011

Here’s a quick wrap up of JavaScript, CSS3, Silverlight, ASP.NET, SharePoint and other .NET articles published on DevCurry.com in the month of July 2011.

jQuery, JavaScript and CSS Articles

jQuery: Load Page in a Div - Loading an external page in a div using jQuery is as simple as calling thejQuery Load method.

JavaScript: View Source code without Comments - One my clients had a requirement of viewing an object while debugging, and they wanted to view only the source code, without comments.

Array Shuffle in JavaScript - I have yet to find a script that truly does a random shuffle across all browsers using JavaScript (no frameworks). However there are a couple of scripts I use, that are ‘good-enough’ to be used when an Array has to be shuffled.

JavaScript Object can have Private Methods - I was watching a JavaScript video tutorial by Douglas Crockford where he explained private members in JavaScript. Although there are no ‘private methods’ in a JavaScript object, we can easily create something similar by defining a function variable with a local scope.

Unary plus operator in JavaScript - The unary plus (+) operator is a unary operator and converts its operand to a number, if it isn’t already. It is equivalent to the Number() constructor called as a function. Let us see some examples of the Unary + operator and what does it imply in different scenarios

Upside Down Text with CSS3 - When it comes to rotating, tilting or scaling text, you would normally rely on JavaScript or images laid on top of each other, to give that effect. However with the CSS3 transformation functions, you can do all of this without any JavaScript code

JavaScript: Convert CamelCase to Dashes and vice-versa - My colleague Satyam shared a nice piece of JavaScript code that converts a camelcase to dashes and dashes to Camelcase.

Text Shadow Filter in IE - You can drop shadows to text using the text-shadow property which was re-introduced in CSS3.

Conditional CSS and JavaScript for Different Browsers - A common technique adopted by developers is to detect browsers and conditionally differentiate CSS rules and JavaScript for specific versions of browsers. In simple words, a requirement could be that if the browser is IE, use a different set of CSS and JavaScript files.

Free Photo Editors for Web Designers - A good photo editing software comes with a price, but here are some free open source photo editors that could do the job for you!

Swap Variables in JavaScript – Different Methods - Here are some different ways to swap variable values in JavaScript. I will show swapping using a temporary variable, without a temporary variable, XOR operator and a single line swap.

ASP.NET, MVC and Silverlight articles

ASP.NET MVC 3 Documentation Available in 10 Different Languages - As you probably know that localized versions of ASP.NET MVC 3 is available in 9 different languages via the Web Platform Installer. To supplement these releases, Phil Haack recently announced on his blog that now apart from English, the MVC 3 Documentation is also now available in these nine local languages

Silverlight 4: Consuming WCF REST Service using JSON - A nice feature of WCF programming is the support for REST and JSON, using which a client can communicate with the WCF service without using A proxy. In this article, I have used a Silverlight 4 client application to make a call to WCF service using JSON.

Silverlight 4.0 : Open .Exe Files using COM Interoperability - While working with Silverlight Line of Business applications, there may be a scenario where the user wants to open .exe applications e.g. Notepad or Calculator from the local machine. The question here is how to make this possible in Silverlight?

Silverlight 4 and 5 Tutorials–Link List - I recently published a list of Silverlight 4 and Silverlight 5 Tutorials that should be a useful resource for every Silverlight developer out there.

ASP.NET: Accessing Nested Repeater Control - The ASP.NET Repeater control is a handy data-bound list control that allows you to create a custom layout by repeating a specified template for each item displayed in the list. You can nest a repeater control inside the other to create advanced layouts.

ASP.NET MVC Web Matrix & Razor Tutorials - In this list, we will see some articles written by our authors on WebMatrix and Razor syntax

Silverlight TextBox Numeric Validation - Although we have IDataErrorInfo interface for input data validation in Silverlight, it provides us validation error when the user enters the data and leaves the textbox. However the requirement we are talking about is when the user enters any data in the textbox, it should be automatically validated. This article contains the solution to this requirement.

.NET and SharePoint Articles

Windows Communication Foundation WCF 4.0 Tutorials - Author and Trainer Mahesh Sabnis has been writing some in-depth WCF 4.0 tutorials that I thought of sharing with all my blog readers. This tutorial series covers some basics and advanced concepts of WCF 4.0 programming

SharePoint 2010 Service Pack 1 Released - Microsoft recently released Service Pack 1 for SharePoint 2010 and Office Products.

SharePoint 2010 Content Database and Other Data Storage Changes - Microsoft recently announced some nice changes to SharePoint 2010 Data storage limits

"Partially Succeeded" TFS status in Visual Studio while upgrading to TFS 2010 - While upgrading from TFS to TFS 2010 and to TFS Team Build 2010, you may have come across the ‘partially succeeded’ message.

C#: Find Previous Month's First and Last Day - Here’s a simple query that gives you the first and last day of the previous month

WCF 4.0 : Discoverable Service - In this small article, I have explained the WCF 4.0 Discovery feature. This feature is used when the location of the service gets changed e.g. changing in the hosting environment or changing the physical address of the server etc

SharePoint 2010 and Azure Free Training - If you are a developer/architect who is interested in understanding how SharePoint 2010 and Windows Azure can leverage each other, then Microsoft recently released the July 2011 update of SharePoint 2010 & Windows Azure Training Kit.

SharePoint 2010 and Azure Free Training

I had recently published a list of SharePoint 2010 Tutorials For Beginners and Intermediate Developers. If you are a developer/architect who is interested in understanding how SharePoint 2010 and Windows Azure can leverage each other, then Microsoft recently released the July 2011 update of SharePoint 2010 & Windows Azure Training Kit. The kit contains twelve modules that include PowerPoint decks, hands-on labs and source code that shows how the SharePoint 2010 platform and Windows Azure platform can work together.

Here are the modules covered in this kit:

Windows Azure Development Overview
SharePoint 2010 Development Overview
Getting Started with Integrating SharePoint 2010 and Windows Azure
Integrating Windows Azure Web Services with SharePoint 2010
Integrating jQuery, SharePoint 2010 and WCF Services in Windows Azure
Integrating Windows Azure in Office 2010 Solutions
Using Bing Maps in SharePoint 2010 with SQL Azure and Business Connectivity Services
Securing Windows Azure Services for SharePoint 2010
Using Windows Azure Blob Storage with SharePoint 2010
Azure Hosted Application Design Pattern for SharePoint
Using Windows Azure with SharePoint Event Handlers
Using Windows Azure with SharePoint Workflow

View the MSDN version of SharePoint 2010 and Azure Training Kit

Download the offline version of SharePoint 2010 and Azure Training Kit

SharePoint 2010 Content Database and Other Data Storage Changes

Microsoft recently announced some nice changes to SharePoint 2010 Data storage limits. If you have installed SharePoint 2010 SP1, then you can now take advantage of a larger content database limit. Previously, the content database limit was under 200 GB for collaboration and < 1TB for document archive. However with SP1, SharePoint 2010 now supports up to 4TB of data in all usage scenarios and there are no imposed size limit for document archive scenarios.

The second important change is that the SQL Server FILESTREAM RBS provider is now supported for use with SharePoint. Good news for admins and companies as now lower cost iSCSI connected NAS disk can be used.

There are some additional changes that has been explained in the blog post here. Make sure you read it to understand the changes better.

SharePoint 2010 Service Pack 1 Released

Microsoft recently released Service Pack 1 for SharePoint 2010 and Office Products. Some of the products covered in SharePoint SP 1 includes

Microsoft SharePoint Server 2010 Service Pack 1
Microsoft SharePoint and Project Server 2010 Service Pack 1
Microsoft SharePoint Foundation 2010 Service Pack 1
Microsoft SharePoint Foundation 2010 Language Pack Service Pack 1
Microsoft SharePoint 2010 Indexing Connector for Documentum Service Pack 1

It is advised to read about some known issues when you install Office 2010 SP1 and SharePoint 2010 SP1.

Download SharePoint 2010 Service Pack 1.

Make sure you install the SharePoint 2010 Hotfix after you have installed Service Pack 1. The June Cumulative Update includes several important security and bug fixes that are not included Service Pack 1.

SharePoint 2010 Application Templates for Health Organization

SharePoint 2010 Application templates are out-of-the-box custom scenarios that are created to address the business process requirements of a particular business industry – say the Health sector. These templates facilitate the business process owners and developers to build deeper SharePoint-based solutions.

Microsoft has released a set of Sharepoint 2010 Application Templates for Health Organizations. Sometime back I had read in a link over here that Microsoft won’t be releasing new versions of the Fabulous 40 templates for SharePoint 2010 Products. However it’s good to see they have released some new templates for SP 2010. Here they are.

Microsoft SharePoint 2010 Application Template for Health Organizations: Request for Proposal - The Request for Proposal application template helps manage the process of creating and releasing an initial RFP, collecting proposal submissions, and formally accepting the selected proposal from among those submitted.

Microsoft SharePoint 2010 Application Template for Health Organizations: Help Desk - The Help Desk application template helps departments such as IT, Facilities, and HR manage service requests

Microsoft SharePoint 2010 Application Template for Health Organizations: Physical Asset Tracking and Management - The Physical Asset Tracking and Management application template helps departments such as Facilities, BioMedical, and Surgery manage requests and the tracking of physical assets.

Microsoft SharePoint 2010 Application Template for Health Organizations: Team Work Site- - The Team Work Site application template provides a place where clinical and business teams, such as Medical Management or Environment of Care committees, can upload background documents, track scheduled calendar events, initiate discussion topics, and submit action items.

Microsoft SharePoint 2010 Application Template for Health Organizations: Clinical Trial Initiation and Management - For those who work in academic medical centers, the Clinical Trial Initiation and Management application template helps teams track clinical trial protocols, set objectives, select subjects, and manage the budget.

Microsoft SharePoint 2010 Application Template for Health Organizations: Employee Training Scheduling and Materials - The Employee Training Scheduling and Materials application template helps nursing educators and other instructors manage courses and related materials.

Microsoft SharePoint 2010 Application Template for Health Organizations: Employee Activities Site - The Employee Activities Site application template helps departments such as HR and Marketing manage the creation of and attendance at employee events.

Microsoft SharePoint 2010 Application Template for Health Organizations: Case Management - The Case Management application template helps case managers track the status and tasks required to complete their work.

Microsoft SharePoint 2010 Application Template for Health Organizations: Budgeting and Tracking Multiple Projects - The Budgeting and Tracking Multiple Projects application template helps project teams track and budget multiple, interrelated sets of activities.

Microsoft SharePoint 2010 Application Template for Health Organizations: Business Performance Reporting - The Business Performance Reporting application template helps managers in healthcare organizations track the satisfaction of internal customers/patients through a combination of surveys and discussions.

Microsoft SharePoint 2010 Application Template for Health Organizations: Event Planning - The Event Planning application template helps teams organize events efficiently through the use of online registration, schedules, communication, and feedback.

Microsoft SharePoint 2010 Application Template for Health Organizations: Knowledgebase - The Knowledge Base application template helps teams manage the information that is resident within their organization.

Microsoft SharePoint 2010 Application Template for Health Organizations: Change Request Management - The Change Request Management application template helps users track risks associated with a design change.

Microsoft SharePoint 2010 Application Template for Health Organizations: Call Center - The Call Center application template helps departments such as Billing, HR, and IT manage customer service requests, from issue identification to cause analysis and resolution.

Microsoft SharePoint 2010 Application Template for Health Organizations: Discussion Database - The Discussion Database application template provides a location where team members can create and reply to discussion topics.

Microsoft SharePoint 2010 Application Template for Health Organizations: Document Library and Review - The Document Library and Review application template helps people manage the review cycle common to processes like publication, knowledge management, and project plan development.

Microsoft SharePoint 2010 Application Template for Health Organizations: Compliance Process Support Site - The Compliance Process Support Site application template helps both teams and executive sponsors manage compliance implementation endeavors, such as HIPAA.

SharePoint 2010 Technical Library Available as CHM

Microsoft has made available the SharePoint Foundation 2010 technical library as a downloadable CHM. The CHM contains the following topics not limited to:

Newly published content for SharePoint Foundation 2010
Roadmap to SharePoint Foundation 2010 content
Downloadable content for SharePoint Foundation 2010
Product evaluation for SharePoint Foundation 2010
Getting started with SharePoint Foundation 2010
Planning and architecture for SharePoint Foundation 2010
Development for SharePoint Foundation 2010
Deployment for SharePoint Foundation 2010
Operations for SharePoint Foundation 2010
Security and protection for SharePoint Foundation 2010
Troubleshooting (SharePoint Foundation 2010)
Technical reference for SharePoint Foundation 2010
Office Web Apps (Installed on SharePoint 2010 Products)
Search Server 2010
and much more

Download SharePoint Server 2010 Technical Library in Compiled Help format

SharePoint 2010 Performance and Capacity Recommendation

Microsoft has released a series of SharePoint whitepapers and articles that contains information about the performance and capacity characteristics of each SharePoint feature and how it was tested by Microsoft. Here’s a list of them:

Capacity Planning Key Concepts

Capacity management and sizing for SharePoint Server 2010 – Explains the key concepts behind capacity management in SharePoint Server 2010.

Performance and Capacity Planning of SharePoint 2010 Features

Business Connectivity Services - Provides guidance on the footprint that use of Business Connectivity Services has on topologies running SharePoint Server 2010

SharePoint Server Caches Overview - Provides information about how the three SharePoint Server 2010 caches help the product scale and grow to meet the demands of your business application

Designing large lists and maximizing list performance (SharePoint Server 2010) - Provides guidance on performance of large document libraries and lists. This document is specific to SharePoint Server 2010, although the throttles and limits that are discussed also apply to Microsoft SharePoint Foundation 2010

Large-scale document repositories - Provides guidance on performance of large-scale document repositories in regards to SharePoint Server 2010.

Estimate capacity and performance for enterprise managed metadata in SharePoint Server 2010 - Provides guidance on how to perform sizing and performance optimization of the managed metadata service in SharePoint Server 2010

My Sites and Social Computing Capacity Planning - Provides guidance on the footprint that use of My Sites and other social computing features has on topologies running SharePoint Server 2010

Estimate performance and capacity requirements for PerformancePoint Services - Provides guidance on the footprint that usage of PerformancePoint Services has on topologies running SharePoint Server 2010

Estimate performance and capacity requirements for SharePoint Server 2010 Search - Discusses capacity planning for different deployments of SharePoint Server 2010 search, including small, medium, and large farms

Capacity requirements for the Web Analytics Shared Service in SharePoint Server 2010 - Provides guidance on the footprint that use of the Web Analytics service has on topologies running SharePoint Server 2010

Estimate performance and capacity requirements for Web Content Management in SharePoint Server 2010 - Provides guidance on performance and capacity planning for a Web Content Management solution

Estimate performance and capacity planning for workflow in SharePoint Server 2010 – Provides guidance on the footprint that usage of Workflow has on topologies running SharePoint Server 2010

Office Apps Capacity Planning (SharePoint 2010)

Estimate performance and capacity requirements for Access Services in SharePoint Server 2010 - Provides guidance on how using Access Services impacts topologies running SharePoint Server 2010

Estimate performance and capacity requirements for Visio Services in SharePoint Server 2010 - Provides guidance on the footprint that use of Visio Services has on topologies running SharePoint Server 2010

Office Web Apps Capacity Planning - Provides guidance on the footprint that use of Office Web Apps has on topologies running SharePoint Server 2010

Estimate performance and capacity requirements for Excel Services in SharePoint Server 2010 - Provides planning guidance for Excel Services in Microsoft SharePoint Server 2010

Estimate performance and capacity requirements for InfoPath Forms Services in SharePoint Server 2010 - Provides guidance on the footprint that use of InfoPath Forms Services has on topologies running SharePoint Server 2010

Word Automation Services Capacity Planning - Provides capacity planning guidance for Word Automation Services in SharePoint Server 2010

Technical Documents for Microsoft SharePoint Server and Foundation 2010

Microsoft has released two documents that includes technical information about the Microsoft SharePoint Server and Foundation 2010 provider for Windows PowerShell and other helpful reference information about general settings, security, and tools.

Download Technical reference for Microsoft SharePoint Server 2010

Download Technical reference for Microsoft SharePoint Foundation 2010

The audiences for these books are business application specialists, line-of-
business specialists, information architects, IT generalists, program managers, and
infrastructure specialists who are planning a solution based on SharePoint Foundation
2010.

You may also want to looks at some Video demos and training for SharePoint Server 2010 subject matter experts and TechNet writers walk through tasks and dynamically explain SharePoint-related concepts

Windows Phone 7 applications with SharePoint 2010 Products

Microsoft has released a cool whitepaper that describes how to build Windows Phone 7 applications with SharePoint 2010 Products and Microsoft Forefront Unified Access Gateway (UAG).

This white paper addresses business scenarios for the development of mobile applications that use the features of SharePoint 2010 Products for collaboration while authenticating through Microsoft Forefront Unified Access Gateway (UAG). The main body of the paper introduces the concepts and code required to access SharePoint list data in a secure manner from Windows Phone 7.

The Appendix details the installation and configuration of a developer instance of UAG for the purposes of testing and developing mobile applications with SharePoint 2010 Products.

This paper seeks to clarify the following development scenarios:

How do I prepare for connecting to SharePoint 2010 Products from my Windows Phone 7 applications?
How do I connect to SharePoint through the Unified Access Gateway?
How do I connect to, authenticate, and consume SharePoint Web services?
How do I create and update SharePoint list items?
How do I consume RSS feeds provided by SharePoint?

Download Windows Phone 7 with SP 2010 Whitepaper (.doc)

Download Windows Phone 7 with SP 2010 Whitepaper (.pdf)

Win .NET EBooks and PluralSight Training in this GiveAway

My other site DotNetCurry.com is doing a GiveAway to celebrate it’s 4 year on the web. There are 156 prizes consisting of .NET Books, Software and Training and you can win them too!!

Just follow this link to enter the contest - DotNetCurry.com $38K Mega GiveAway: 4th Anniversary Celebration

Amongst the prizes, there are some cool O'reilly EBooks and Training. You can win 3 Annual Subscriptions to Pluralsight On-Demand .NET Training. Pluralsight provides high-quality training solutions for Microsoft .NET developers that can fit any schedule or budget. The revolutionary Pluralsight On-Demand! training library provides developers with instant access to a rich collection of online training courses delivered by industry authorities.

There are also 25 EBooks sponsored by O'Reilly on the latest Microsoft Technologies, for the GiveAway.

To participate, click here - DotNetCurry.com $38K Mega GiveAway: 4th Anniversary Celebration. Good Luck!

Deploy Silverlight Application using SharePoint 2010 Project

In this post we will see how to deploy Silverlight Application using SharePoint Project in Visual Studio 2010. The first step is to ‘Create a Silverlight Project’. I have already demonstrated one of my Silverlight applications which shows Plane Projection capabilities in Silverlight Silverlight 3D - Using Plane Projection. You can refer to that article or use your own Silverlight project for this example. I will be using the project I created earlier for this demonstration.

So let’s create an ‘Empty SharePoint 2010 Project’ with the name ‘DeploySilverlightApp’ as shown below –

Click ‘OK’ and choose ‘Deploy as a Sandboxed Solution’ option by providing SharePoint Site URL –

Now your project will look like the following –

clip_image003

Now let’s add a ‘Module’ to our SharePoint project. The modules are used to deploy the files to SharePoint sites. To add a module, right click the SharePoint Empty project and add a new item. Choose ‘Module’ from the SharePoint > 2010 section. Name the module as ‘SLAppModule’.

Now this will display Elements.xml file. From the project under solution explorer, delete ‘Sample.txt’ file and also delete the entry –

<File Path="SilverlightAppModule\Sample.txt" Url="SilverlightAppModule/Sample.txt" />

from the Elements.xml.

The next step is to add our existing Silverlight application to our solution. Right click the Solution and click on ‘Add Existing Project’. Browse the project to add. Now let’s add the following code in between <Module></Module> and save the file –

<File Path="SLAppModule\SLDataGridExample.xap" Url="_catalogs/masterpage/SLDataGridExample.xap" />

Right click the ‘SLAppModule’ and go to properties. In the properties window, click on ‘Project Output References’ and click on the button in front of it. This will bring up a dialog box. Click on ‘Add’ button. Now in the ‘Deployment Type’ choose ‘Element File’ from the dropdown list. Then from the ‘Project Name’ dropdown box, choose Silverlight application as shown below –

Now build your solution and press ‘F5’ which will deploy the ‘.XAP’ to the SharePoint site. Once the deployment is over, it will open a site to which we have just deployed the .XAP file.

Now go to ‘Site Actions’ Menu and click on ‘Site Settings’. This will display the site settings page. Go to ‘Galleries’ section and click on Solutions as shown below –

clip_image005

In the solution page, you will see the ‘SLDeployApp.wsp’ file as shown below –

Deploy Silverlight Application

Now let’s go to our browser URL and modify the URL to verify the .XAP file –

‘http://localhost:21068/_catalogs/masterpage/Forms/AllItems.aspx’

You will see the ‘SLDataGridExample.xap’ file. Let’s use this XAP file in our page. Click the .XAP file dropdown box and click on ‘View Properties’. This will display the properties window. Right click ‘SLDataGridExample’ and click on ‘Copy Shortcut’.

Now go to the home page and click on ‘Edit’ page button. Go to ‘Insert Tab’ and click on ‘Web Part’ button. Choose ‘Media and Content’ category > ‘Silverlight web part’ as shown below –

Note: If for some reason, you are unable to see the Silverlight Web Part, check my article Silverlight Integration with SharePoint 2010 to see how to enable this feature.

Click on the ‘Add’ button. It will ask you for an URL. Paste the URL which we copied some time back and click the ‘OK’ button. Here’s the output –

Silverlight Sharepoint Deployment

Excel Service User Defined Function in SharePoint Server 2010

In this post, we will see how to create an Excel Service User Defined Function in SharePoint Server 2010. We will also see how to deploy and enable the UDF using Central Administration Tool. We will also test the function using Microsoft Excel 2010.

To start with, let’s create a Class Library Project using Visual Studio 2010 with the name ‘SalaryCalciUDF’–

Now let’s add a reference to the DLL file – ‘Excel Services Application UDF Framework’ as shown below –

Now rename ‘Class1’ with ‘SalaryCalculator’ and add a function called ‘CalculateGrossSalary’. Also import a namespace ‘using Microsoft.Office.Excel.Server.Udf;’. Now your class should look similar to the following –

clip_image003

If you check the above code, we have applied ‘[UdfClass]’ attribute to our class and ‘[UDFMethod]’ attribute to our method. If we do not apply the attribute ‘[UdfClass]’, Excel calculation service will ignore this class. The same applies to method attribute.

Now compile the assembly and you will get a ‘SalaryCalciUDF.dll’ file in the debug folder of your project. Let’s copy this DLL and paste it in a folder ‘C:\ExcelUDFs’ folder. If the folder is not created, create the

folder.

Now let’s deploy the created UDF in our shared location of Excel Service. To deploy this UDF, click on Central Administration tool and click on ‘Application Management’ link from the left navigation pane. Now from the ‘Service Applications’ group on the right hand side, click on ‘Manage Service Applications’ as shown below –

This will show you all the available services. Now click on ‘Manage Excel Services Application’ link. This will show you different options to manage the Excel Services application. I assume that you have already created a SharePoint Site. If you have not created the SharePoint site, please refer to my article ‘SharePoint Dashboard with Common Filters using PerformancePoint Services 2010’ on http://www.dotnetcurry.com/.

Now let’s add a ‘Shared Document’ library path into the trusted file location as shown below–

Click on ‘Trusted File Locations’ shown above and click on a link ‘Add trusted file location’. In the address, paste the path of ‘Shared Document library as shown below –

‘http://localhost:21068/Shared%20Documents/’

Please note that you will have put the ‘Shared Document’ library path on your machine.

Then in ‘Location Type’ choose ‘Microsoft SharePoint Foundation’. Under ‘Trust Children’ check the checkbox ‘Children Trusted’ and at the end of this page, check the check box ‘User Defined Functions allowed’ from the ‘Allow User defined Functions’ section and click the ‘OK’ button.

The next step is to enable the UDFs. To enable the UDFs, go back to the ‘Manage Excel Services Application’ and click on ‘User Defined Function Assemblies’ link. Now click on ‘Add User Defined Function Assembly’ link.

Add the path ‘C:\ExcelUDFs\SalaryCalciUDF.dll’ file path and choose ‘File Path’ from ‘Assembly Location’. Check the checkbox ‘Assembly Enabled’ from the section ‘Enable Assembly’ and click ‘OK’ button.

Now let’s test our UDF. Let’s create an Excel Workbook and add all the data as shown below –

Now let’s add a parameter. Select the cell next to the ‘BasicSalary’. Go to ‘Formulas’ ribbon and click on ‘Name Manager’ as shown below –

Now click on ‘New’ button and in the name textbox, type ‘BS’ as shown below –

clip_image008

Now repeat the above steps to add name parameters till PF. Now choose a cell which is after ‘GrossSalary’ and write the following formula –

=CalculateGrossSalary(BS,HRA,TA,DA,PF)

You will see ‘#NAME?’. This function will be evaluated only when the Excel workbook is displayed in Excel Services. So let’s publish the workbook into our ‘Shared Document’ library. Before that, save the workbook on local drive. To publish the excel workbook, go to ‘File’ menu of Excel workbook and click on ‘Save and Send’ menu. It will show you ‘Save to SharePoint’ option and Publish Option button as shown below –

clip_image010

Now click on the button ‘Publish Options’. Click on ‘Parameters’ tab. Click on ‘Add’ button and choose all the parameters and click ‘OK’ button. Now click on ‘Save As’ button and paste the path of ‘Shared Document’ library and hit Enter. Now save your workbook with the name ‘TestUDF’ and click on ‘Save’ button.

As soon as you save the workbook in SharePoint Library ‘Shared Document’, it will open the workbook in a browser. In the parameters task pane, add the values for the parameters and click on ‘Apply’ button. You will see your gross salary like below –

clip_image012

View CAML generated by LINQ to SharePoint

In this post, we will see how to view the CAML generated by LINQ to SharePoint. As we know when we write a LINQ query against a SharePoint List, internally the query gets converted into ‘CAML’ (Collaborative Application Markup Language’). I have already written an article on ‘LINQ to SharePoint’ in which I have explained how to perform CRUD operation on SharePoint Lists. If you have not seen that article, I would highly recommend you to go through the article first and then you can continue with this one.

So let’s create a simple console application to implement this demonstration. Once you create a console application, you will have to follow a couple of steps. These steps are listed in my article ‘LINQ to SharePoint’

The steps are –

1) First you need to generate Entities for all the lists in SharePoint Site with their properties using the SPMetal.exe tool.

2) Once you generate the .CS/.VB file with all the entities, use this file for querying the SharePoint Lists data. So let’s add this file into our Console application.

3) Now with the generated file in our console application, we now have to add the reference to an API – Microsoft.SharePoint.LINQ.dll. You will find ths DLL file in the following path – C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\ISAPI.

Now in the ‘Main’ method, let’s write the following code as shown below –

If you observe the above code, we are declaring an object of the data context of our SharePoint site by passing a URL of our site. We then write a LINQ query which fetches the data from ‘Customers’ list using a where condition. We are using the ‘Log’ property of our data context which shows the LINQ query conversion to CAML.

Note: Please replace the site URL in the code above, with your site URL.

Download the source code

SharePoint 2010 Articles and Tutorials

In this post, I wanted to highlight some excellent SharePoint 2010 Articles and Tutorials written by the authors of DotNetCurry.com. I am sure these articles will help you understand the capabilities of SharePoint 2010, as well as give you development, reporting administration and architectural tips and demonstrate techniques on how to resolve existing pain-points while implementing a SharePoint solution in your organization.

Article Title	Author
SharePoint 2010: Connect InfoPath Form Web part with Excel Web Part	Pravinkumar Dabade
Connected Web Parts in SharePoint 2010 - an Architectural Framework	Lavanya Kammari, Nataraj Yadavalli, Mark Kendall
Custom Content Types in SharePoint	Sumit Maitra
SharePoint: Create Dashboards with KPI, Scorecard and Report using Excel Services	Pravinkumar Dabade
Create SQL Server Dashboard in SharePoint	Pravinkumar Dabade
SharePoint – Creating Page Layouts for Custom Content Types	Sumit Maitra
Create SQL Server Dashboard in SharePoint	Pravinkumar Dabade
Mastering Business Connectivity Services in SharePoint 2010 - Part 1	Mark Kendall
Create Excel Dashboards in SharePoint	Pravinkumar Dabade
SharePoint: Writing a Custom Event Receiver	Sumit Maitra
SharePoint Dashboard with Common Filters using PerformancePoint Services 2010	Pravinkumar Dabade
Mastering Business Connectivity Services in SharePoint 2010 - Part 2	Mark Kendall
Designing Dashboards and Scorecards using SharePoint PerformancePoint Services 2010 and SSAS – Part 1	Pravinkumar Dabade
Designing Dashboards and Scorecards using SharePoint PerformancePoint Services 2010 and SSAS – Part 2	Pravinkumar Dabade
Designing Dashboards and Scorecards using SharePoint PerformancePoint Services 2010 and SSAS – Part 3	Pravinkumar Dabade

Upgrade Sharepoint 2007 to Sharepoint 2010

If you are planning to upgrade from Sharepoint 2007 to Sharepoint 2010, Microsoft has released a free guide that could prove very useful.

Here’s what the guide contains (excerpt taken from the document)

About the upgrade process (SharePoint Server 2010) - Learn about what's new in upgrade and how the upgrade process works.

Plan and prepare for upgrade (SharePoint Server 2010) - Determine which approach you should take to upgrade to SharePoint Server 2010 and plan your upgrade process.

Testing and troubleshooting upgrade (SharePoint Server 2010) - Learn how to test your upgrade process ahead of time to understand what issues you might face in your actual upgrade, and determine the time and space you will need for upgrade. Also, learn how to troubleshoot issues that come up during the actual upgrade.

Perform pre-upgrade steps (SharePoint Server 2010) - Find out what steps you need to take before upgrading, including information about how to run the pre-upgrade checker.

Perform an in-place upgrade (SharePoint Server 2010) - Follow the steps in this section if you are upgrading in-place to SharePoint Server 2010. When you upgrade in-place, you install SharePoint Server 2010 on the same hardware, and then upgrade the content and settings on the server or server farm as part of a single process.

Perform a database attach upgrade to SharePoint Server 2010 - Follow the steps in this section if you are using the database attach upgrade method to upgrade to SharePoint Server 2010. When you use the database attach upgrade method, you upgrade the content for the environment on a separate farm.

Perform post-upgrade steps (SharePoint Server 2010) - Find out how to tell whether upgrade was completed successfully and what steps you need to perform after the upgrade to get your environment ready for users again.

Upgrade from other versions or other products - Articles in this section contain information about how to upgrade to Microsoft SharePoint Server 2010 from related SharePoint products.

Migrate from forms-based authentication to claims-based authentication (SharePoint Server 2010) - This article provides guidance to help you migrate existing Microsoft Office SharePoint Server 2007 Web applications, which were configured to use forms-based authentication, to work in a Microsoft SharePoint Server 2010 environment as claims-based Web applications.

Migrate from classic-mode to claims-based authentication (SharePoint Server 2010) - The procedures in this article provide guidance to help you migrate existing Microsoft SharePoint Server 2010 Web applications, which were configured to use classic-mode authentication, to use claims-based authentication.

Upgrade Sharepoint 2007 to Sharepoint 2010 (Doc)

Upgrade Sharepoint 2007 to Sharepoint 2010 (Pdf)