Showing posts from May, 2012

Error: The language-neutral solution package was not found.

While using Visual Studio, you may get the following error
“The language-neutral solution package was not found.” Solution: There are three ways you can fix this problem: 1. This may be caused due to the CACHING issue in the Visual Studio and hence restarting the Visual Studio will help you in fixing the issue. 2. Sometimes the solution you are trying to update will not get updated properly. Hence delete the following folders (By navigating to In Visual Studio   -> Right click on project in Solution Explorer window -> Select Open folder in Windows Explorer)  bin, obj and package. After deleting these folders, rebuild and deploy the solution which will work out. 3. Or finally, you can retract the solution from the Central Admin (in case of SharePoint related issues) and then uninstall the solution dll from the assembly folder. Then try to deploy the solution. Please free to comment and share this post, if this helps you!

Chart Controls in ASP.Net

I was looking at creating chart controls for implementing in the .Net web applications. I didn’t like to use the 3rd party tools or any freeware tools. Well, while browsing found a cool feature provided by MICROSOFT for the same.
In this article, we will have a look at the CHART CONTROLS in .Net applications. Pre-requisites
ØVisual Studio 2008 SP1, Link to download
Ø.NET Framework 3.5 SP1, Link to download
Ø Microsoft Chart Controls, Link to download
ØVisual Studio 2008 Add-on for the Chart Controls, Link to download
ØDocumentations by Microsoft, Link to download
ØWeb and Windows Application Samples, Link to download Types of Charts
ØArea Charts
ØBar column Charts
ØCircular Charts
ØCombination Charts
ØData Distribution Charts
ØError Bar
ØFinancial Charts
ØLine Charts
ØPie Doughnut Charts
ØPoint Charts
ØPrice Range Financial Charts
ØPyramid Funnel Charts
ØRange Charts Examples The examples provided by Microsoft are very clear and easy. Hence you can download and try the samples. Also, the control is easy to u…

Windows System Shows Blank Screen after logging in

I have faced many situations like after logging into the Windows Operating system machine (Especially Windows 7 and Windows Server which I have faced); it takes more hours showing a BLANK SCREEN without showing the desktop. It wasted my time more. So I was searching for a solution which would help in fixing the issue. Solution: 1. Press CTRL + ALT + DEL 2. Select Start Task Manager from the list 3. In the Task Manager Select -> File -> New Task (New Task (Run...)) – I have Win 7 as shown below: 4. Type “Explorer” in the text box and click OK. 5. Now, you will see the explorer opening suddenly and also your desktop is ready to use. Hope this helps some one’s time. Happy Sharing!

Change the Color of a Column in a List in SharePoint

In this article, we will know how to change the color of a column based upon the values in the column. It is something like“Color Indicator”inSharePoint.
Scenario: We have a custom list used for Project Tracking. In the list, we have column namedSTATUSfor tracking the project. Whenever anitemin the list is updated with thestatusin the column, then the background color of the status column shouldautomaticallychange depending upon the status. Hence it gives aproper UIfor tracking the status.
1. Create a custom list named “Project Tracking System” with the columns such as “Title”, “Description” and Status with the data type as shown below:
Columns with the data types to be created:

2. Now, we will insert 4-5 items in the list created.  In the above list, we can see that the status column is updated, but it would be good when we havebackground colorof the eachstatusseparately. It is gives easy tracking to the users. 3. We can achieve this through JAVA SCRIPT 4. Add aContent Editor Web par…

Remote Blob Storage (RBS) in SharePoint 2010

In this article, we will know about a new feature in SharePoint 2010 which allows the remote storage in SharePoint.
What is Remote BLOB Storage?
ØBLOB – Binary Large Object ØRemote BLOB Storage (RBS) is a library API set that is incorporated as an add-on feature pack for Microsoft SQL Server. ØIt can be run on servers with Microsoft SQL Server 2008 R2, SQL Server 2008 or SQL Server 2008 R2 Express. To run RBS on a remote server, you must be running SQL Server 2008 R2 Enterprise edition. ØRBS is not supported for Microsoft SQL Server 2005. ØIn Microsoft SharePoint Server 2010, RBS can be used for content databases only. Why RBS? It provides the following benefits: ØBLOB data can be stored on less expensive storage devices that are configured to handle simple storage. ØThe administration of the BLOB storage is controlled by a system that is designed specifically to work with BLOB data. ØDatabase server resources are freed for database operations. When to Go for RBS? ØLarge Database of Mostly Binar…

CAML Query to Get Data from SharePoint List

To know about the Basics of the CAML query read this article.
To know about using CAML query builder to create CAML queries, read this article. In this article, we will learn how to use CAML query in Microsoft Visual Studio Scenario: I have a custom list named “Product List” with the columns named Title, Price, Quantity and Is Available. I want to retrieve the products with price greater than 1000 and lesser than 10000. Then I have to order the results depending upon the quantity in descending order.
Using the CAML query builder, I have created a CAML query for the above scenario and the query is as follows:
<Query><Where><And><Gt><FieldRef Name="Price" /><Value Type="Number">1000</Value></Gt><Leq><FieldRef Name="Price" /><Value Type="Number">10000</Value></Leq></And></Where><OrderBy><FieldRef Name="Price" Ascending="False" /><…

The list cannot be displayed in datasheet view for one or more of the following reasons in SharePoint

I was easily changing my list view by edit in data sheet view and in standard view.  After sometime, when I tried to edit a SharePoint list in DATASHEET view,I got the following error which doesn't allow me to view the list in the datasheet view and shown up a error as shown below: Solution: Clearly, the problem is due to some DLL's in the MS office is creating this problem. Hence, either of the following solutions will help you to fix this error: Microsoft Office diagnostics Run the Microsoft office diagnostics tool by navigating to the following location: Start -> All Programs -> Microsoft Office -> Microsoft Office Tools -> Microsoft Office Diagnostics This will repair the office setup installed in the machine. you may see the following screens running once started Once completed, you will see the following screen:
Installing Office2007 SharePoint Components I read a wonderful article for this and the link is…

Using CAML Query Builder for SharePoint

To know about the Basics of the CAML query read this article. Download Link Use the following link to download the CAML Query builder.
Update: CAML query builder for 2007, 2010, 2013 and SP Online link How to use CAML Query Builder to create a query Following are the steps for using the CAML query builder to create a CAML query 1. Open the CAML query builder. Type the URL to connect to the SharePoint site and check Credentials of the current user to login 2. Once clicked connect, you will see the following window SharePoint site with all the lists and libraries in the site in a tree view structure which is shown below: 3. Now we will create a new query on a list named “Product List” as shown below: 4. We will start creating a new query which is as follows:

5. You will find the query being created depending upon your selection from the list 6. Clicking on Execute, you will see the query being executed and the result is being displayed…

Import Excel Sheet to SharePoint List

In this article, we will learn how to export the excel data to the SharePoint list.
Steps: 1. Click on Site Actions -> More Options  2. Now click on the Lists -> Select Import Spread Sheet from the type -> then Click Create  3. Give the Name and Description of the List to be created and then browse the Excel Sheet to be uploaded 4. Clicking on Import option, you will find see a popup window opens. Select Range of Cells in the Range Type 5. This option allows you to select the table columns and rows in excel as shown below. After selecting, you will see the selected field’s column and row data being populated in the Select Range field in the popup window 6. Now click on Import in the popup window. Your SharePoint list will be created from the Excel Sheet and the values are also populated as shown below: You may face some issues while importing the Excel Sheet to SharePoint and the solution is follows: Error: “Method ‘Post’ of object ‘IOWSPostData’ failed” in SharePoint Solution:  ØOpen t…

CAML Query tutorial for SharePoint

In this article, we will understand the basics of CAML query in SharePoint.
What is CAML?   ØCAML - Collaborative Application Markup Language   ØXML- Extensible Markup Language based query language   ØUsed to perform a query operation against SharePoint Lists How SharePoint List Items are retrieved? SharePoint List data can be retrieved in any one of the following ways: 1. Using the SharePoint object model – used when code runs on the server         (Example: Developing a web part or an application page) 2. Using the SharePoint Lists web service – used when your code doesn’t run on the server where the SharePoint is installed (Example: Developing a windows application) 3. Using Power shell –used mostly by the ADMIN of the SharePoint when they quickly want to retrieve some information from the SharePoint site How does CAML query looks like? As I already mentioned, it is XML based query language and it contains tags in it. The root element of the CAML query root element is Query. But it is not nec…

Creating FAVICON for WSS 3.0 and MOSS 2007

In this article, we have learned how to Changing the FavIcon in SharePoint 2010.
But there is no favIcon for WSS 3.0 and MOSS 2007 by default. Then how to create favicon for the lower versions of the SharePoint. Here is the solution.
1. Open the SharePoint site (WSS 3.0 or MOSS 2007) in SharePoint designer 2007
2. Edit the master page
3. Add the below tag before end of the HEAD tag in the master page
<link rel=”shortcut icon” href=”/SiteImages /favicon.ico” /> 
4. Now save the master page and Check in the page
5. Refresh the SharePoint page, you will see the FAVICON  in the address bar of the SharePoint site.
To know more about:
1. What is favicon ? 
2. Creating favicon
3. Use of favicon
Read this article.

SharePoint site continually prompting for passwords

I got a scenario where the SharePoint site is not allowing a user to login to the site even on giving correct username and password. It is an intranet site and hence it will take the Windows Authentication. But after 3 consecutive wrong attempts, password should be locked since it is taking the username and password from the Active Directory. It doesn’t happen. I have checked the Active directory and it is unlocked only.
So, what is the problem stopping the user to login to the site? Read the solution below.
Solution: I have analyzed the problem in the following ways and arrived at the solution.  The root cause of the issue may be any one of the following issues: Adding the SharePoint site to the Local Intranet 1. Open IE on your computer, go to TOOLS > INTERNET OPTIONS, and then Select the Security tab. Click on the Local Intranet zone icon, and then the Sites button. 2. You will see a pop up -> Local Intranet -> click Advanced -> Local Intranet -> where you can add t…