Showing posts from January, 2012

SharePoint 2010 Web part, which one is used where and when

SharePoint 2010 picking the web part depending upon the data coming from  data source.

Comparing view and form web parts
XSLTListViewWebPart : SP list, libraries, external content typesXSLTListFormViewWebPart : from external listListViewWebPart:ListFormWebPart : From a SharePoint  listDataViewWebPart : n/a - only for backwards compatibility.DataFormWebPart: Xml, SOAP, REST, Database data source InfopathFormWebPart
If you migration your database from 2007 to 2010 then DataViewWebPart gives backwards compatibility.
When you added View in your web part: If data coming from the list like “SP list, libraries, and external content types” then it will display the data in  XSLTListViewWebPart.  If data coming from the list like “Xml, SOAP, REST, Database data source” then it will display the data in  DataFormWebPart.When you added View in your web part : If you added the form in your web part and your data coming from the external list then SPD choose XSLTListFormViewWebPart. If your data comin…

How to extract WSP from SharePoint 2010 Central Admin


My Client requirement makes the exact replica of the SharePoint server to another location. There is some custom WSP installed on the server. So SharePoint 2010 Central admin will not allow us to download the WSP from there. Customer wanted to download the WSP Solutions.
stsadm, there’s not a command to download a solution.

Purposed solution:
Using Console application to Extract WSPUsing Power Shell ScriptImplementation:

Using Console Application to Extract WSP
SPSolutionCollection solutions = SPFarm.Local.Solutions;
foreach (SPSolution solution in solutions)
    SPPersistedFile wspFile = solution.SolutionFile;
    wspFile.SaveAs("c:\\wsp\\" + solution.Name);
}Using Power Shell
$farm = Get-SPFarm
$file = $farm.Solutions.Item("custom.wsp").SolutionFile
$file.SaveAs("c:\temp\ custom.wsp")

Problem Solve Report deployment error in SharePoint Integration mode

Today post related to SSRS Access Denied Problem.

I have a two system attached in a farm.
SharePoint SiteSharePoint SSRS (Reporting) In SharePoint Site SSO already implemented. I need to move my SharePoint Content database as well as report database server database to new Server.

I have a updated SSRS Project source code so I need not to backup the report database. So took the back up of SharePoint content database and move it to another system. I installed new SharePoint Server in one machine and SharePoint SSRS other machine and add both server to farm. I attached the backup database with new application guess :) what.. it was working fine.

But the problem comes :( when I was going to deploy reports. It was giving me an access denied. When I open my old reports going to SharePoint Site and open report library still It was giving me an error because the reports only available in SharePoint content database not in Report server database.

Also my old database had not accessed to the Rep…

CRUD Operation with SharePoint REST Service using ADO.NET DATA Services

Today I am going to implement the SharePoint 2010 REST Services using ADO.NET Data Services. In this example i will show you how to applying the CRUD Operation to the SharePoint List. In this example I will create the Window Application and consuming the ListData.svc service and perform the basic list Operations. I will provide you a video link so you can easily understand and do it your self. 

PrerequisiteGeneral error while using SharePoint Rest Services.Fix ErrorsImplementationCRUD Operation with SharePoint REST Service using ADO.NET DATA ServicesVideoSource CodePrerequisite Visual Studio 2010 ADO.NET Data Services v1.5 CTP2 Installed on your machineFull Access to the SharePoint 2010 Rest Service URL. Ex http://<<servername:port>>/_vti_bin/Listdata.svc 

General error while using SharePoint Rest Services. “System.Data.Services.Providers.IDataServiceUpdateProvider’ from assembly ‘System.Data.Services, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089”…