How to create folder in sharepoint custom list programmatically

Here is steps to add new item as a folder in sharepoint list programmatically.

- Create new instance of site with your current application
using (SPSite site = new SPSite(SPContext.Current.Web.Url.ToString()))
{

- Create new web instance and open web for current application
using (SPWeb webFolder = site.OpenWeb())
{

- Get folder by folder name in list
SPFolder folder = webFolder.GetFolder("/Lists/Your List Name/Your Folder Name");

- Check whether folder is exist in list or not, if not then create new folder
if (folder.Exists)
{
Response.Write("Folder name already exists.");
return;
}

- Create list and Get County list
SPList list = webFolder.Lists[Your List Name];

- Set AllowUnsafeUpdates to true to insert new item through code
webFolder.AllowUnsafeUpdates = true;

- Create new item to add
SPListItem item = list.Items.Add();
item.FileSystemObjectType = SPFileSystemObjectType.Folder;

- Set values for the folder name
item["Title"] = “Your Folder Name”;

- fire update event for County list
item.Update();
webFolder.Update();

 }
}

-That’s it for adding new item to your sharepoint list as folder.

How to add custom menu item to sharepoint menu

Here is some link that demonstrate how we can add new menu item under existing sharepoint menu.

- To add menu item follow link shown below
(1) SharePoint 2010 Development with Visual Studio 2010: Add Resources (like Elements.xml) to Feature


(2) SharePoint 2010: Add custom menuitem to Welcome/My Settings (top-right) menu


(3) How to Add Menu Items to SharePoint with Features, Custom Actions, and Custom Action Groups

(4) Adding actions to Site Actions menu

(5) Adding a Custom Action to a Display Form for List Items

- Default custom action locations
below link lists different location and their custom action groups for different menu on different locations. 
(1) Default Custom Action Locations and IDs

(2) SharePoint: RegistrationId List Template Type IDs

 

Delete sharepoint list item attachment programmatically

Here is steps to delete sharepoint list item attachment programmatically.

- Follow the steps to delete list item attachment from your sharepoint list.

- Create new instance of site with your current application
using (SPSite site = new SPSite(SPContext.Current.Web.Url.ToString()))
{

- Create new web instance and open web for current application
using (SPWeb web = site.OpenWeb())
{

- Create new list object and get your list
SPList SPLData = web.Lists["Your List Name"];

- Create new query object to hold query which fetches list item of the list
SPQuery SPMyQuery = new SPQuery();

- Assign query with value to it in ID field of the list item
SPMyQuery.Query = string.Format(“<Where><Eq><FieldRef Name='ID' /><Value Type='Counter'>{0}</Value></Eq></Where>”,1);

//========== Fetch item collection data for Your List  ==========//
SPListItemCollection common = SPLData.GetItems(SPMyQuery);

SPListItem listItem = common[0];

if (listItem.Attachments.Count > 0)
{
listItem.Attachments.Delete(“Name of file”);
listItem.Update();
}

}

}

-That’s it for deleting attachments from your existing list item of sharepoint list.

Get sharepoint list item attachment programmatically

Here is steps to get sharepoint list item attachment programmatically.

- Follow the steps to insert new item into your sharepoint list.

- Create new instance of site with your current application
using (SPSite site = new SPSite(SPContext.Current.Web.Url.ToString()))
{

- Create new web instance and open web for current application
using (SPWeb web = site.OpenWeb())
{

- Create new list object and get your list
SPList SPLData = web.Lists["Your List Name"];

- Create new query object to hold query which fetches list item of the list
SPQuery SPMyQuery = new SPQuery();

- Assign query with value to it in ID field of the list item
SPMyQuery.Query = string.Format(“<Where >  < Eq >  < FieldRef Name='ID' / >  < Value Type='Counter' > {0} < /Value >  < /Eq >  < /Where >”,1);

- Assign query to list and get item on the basis of the query build above
SPListItemCollection common = SPLData.GetItems(SPMyQuery);

- Check whether list collection contains result of the query, if contains item the proceed to update value of the list item
if (common.Count > 0)
{
SPListItem mylistItem = common[0];
string[] _Str_Attachments = GetAttachmentCollection(mylistItem);

- You can assign attachment collection with grid and if you want to give link to the attachment filename, on each file name with anchor link put following code for href of anchor.
string.Format("/Lists/{0}/Attachments/{1}/{2}", "Your List Name”,1,”FileName”);

}
}
}

- Get sharepoint list item attachment collection
public string[] GetAttachmentCollection(SPListItem item)
{
string FileNames = String.Empty;
if (item.Attachments.Count > 0)
{
string[] _Str_File_Name = new string[item.Attachments.Count];
for (int i = 0; i < item.Attachments.Count; i++)
{
SPFile file = item.ParentList.ParentWeb.GetFile(item.Attachments.UrlPrefix + item.Attachments[i].ToString());
_Str_File_Name[i]= file.Name;
}
return _Str_File_Name;
}
return null;
}


-That’s it for fetching attachments for existing item of sharepoint list.

Insert new item with attachment to sharepoint list programmatically

Here is steps to add new item with attachment to sharepoint list programmatically.

- Get name of the file
string _Str_File_Name = fuAttachment.PostedFile.FileName;

- Get stream data by following way
byte[] contents = GetFileStream();

- Declare variable which hold the newly created item id.
int _Int_ID = 0;

- Follow the steps to insert new item into your sharepoint list with attachment.
- Create new instance of site with your current application
using (SPSite site = new SPSite(SPContext.Current.Web.Url.ToString()))
{
- Create new web instance and open web for current application
using (SPWeb web = site.OpenWeb())
{
- Create new list object and get your list
SPList list = web.Lists["Your List Name"];
- Set allowunsafeupdates for web & site to true
site.AllowUnsafeUpdates = true;
web.AllowUnsafeUpdates = true;
- Create new list item object and add new item for newly created list object
SPListItem item = list.Items.Add();

- Assign value for newly created item
item["Title"] = "Title1";

- Assign selected filename and stream data
if (!string.IsNullOrEmpty(_Str_File_Name != null) && (contents.Length > 0))
{
SPAttachmentCollection fileAttach = item.Attachments;
fileAttach.Add(_Str_File_Name, contents );
}

- Update item which will add new item to list
item.Update();

- if you want to manipulate on newly created item then you can get id of the newly created item by following way
itemId = item.ID;
}
}

- Convert your selected file to byte by following function
private byte[] GetFileStream()
{
//fuAttachment is your file select control
if (!fuAttachment.HasFile)
return null;
Stream fStream = fuAttachment.PostedFile.InputStream;
byte[] contents = new byte[fStream.Length];
fStream.Read(contents, 0, (int)fStream.Length);
fStream.Close();
return contents;
}
Click Insert new item to sharepoint list programmatically to view my previous post to add item to sharepoint list.

-That’s it for adding new item to your sharepoint list with attachment.

Delete sharepoint list item programmatically

- Create new instance of site with your current application
using (SPSite site = new SPSite(SPContext.Current.Web.ToString())) 
{

- Create new web instance and open web for current application
using (SPWeb web = site.OpenWeb())
{
- Create new list object and get your list
SPList SPLData = web.Lists["Your List Name"];
- Create new query object to hold query which fetches list item of the list
SPQuery SPMyQuery = new SPQuery();
- Assign query with value to it in ID field of the list item
SPMyQuery.Query = string.Format(“<Where><Eq><FieldRef Name='ID' /><Value Type='Counter' >{0}</Value> </Eq> </Where>”,1);

- Assign query to list and get item on the basis of the query build above
SPListItemCollection common = SPLData.GetItems(SPMyQuery);
- Check whether list collection contains result of the query, if contains item the proceed to update value of the list item
if (common.Count > 0)
{

- Set allowunsafeupdates for web to true
web.AllowUnsafeUpdates = true;

- Delete selected item from fetched list
common[0].Delete();

- Update item which will add new item to list
web.Update();

}
}
} 

Update existing sharepoint list item programmatically

Here is steps to update existing sharepoint list item programmatically.

- Follow the steps to insert new item into your sharepoint list.

- Create new instance of site with your current application
using (SPSite site = new SPSite(SPContext.Current.Web.Url.ToString()))
{

- Create new web instance and open web for current application
using (SPWeb web = site.OpenWeb())
{

- Create new list object and get your list
SPList SPLData = web.Lists["Your List Name"];

- Create new query object to hold query which fetches list item of the list
SPQuery SPMyQuery = new SPQuery();

- Assign query with value to it in ID field of the list item
SPMyQuery.Query = string.Format(“ < Where >  < Eq >  < FieldRef Name='ID' / >  < Value Type='Counter' > {0} < /Value >  < /Eq >  < /Where > ”,1); 

- Assign query to list and get item on the basis of the query build above
SPListItemCollection common = SPLData.GetItems(SPMyQuery);

- Check whether list collection contains result of the query, if contains item the proceed to update value of the list item
if (common.Count > 0)
{

- Set allowunsafeupdates for web to true
web.AllowUnsafeUpdates = true;

- Get first list item from the result list
SPListItem item = common[0];

- Set new value for the column which we want to update
item["Title"] = “New Value”;

- Update item which will add new item to list
item.Update();
}
}
}

-That’s it for updating existing item of sharepoint list.

Insert new item to sharepoint list programmatically

Here is steps to add new item to sharepoint list programmatically.
- Declare variable which hold the newly created item id.
int _Int_ID = 0;

- Follow the steps to insert new item into your sharepoint list.

- Create new instance of site with your current application
using (SPSite site = new SPSite(SPContext.Current.Web.Url.ToString()))
{
- Create new web instance and open web for current application
        using (SPWeb web = site.OpenWeb())
        {
- Create new list object and get your list
                SPList list = web.Lists["Your List Name"];
- Set allowunsafeupdates for web & site to true
                site.AllowUnsafeUpdates = true;
                web.AllowUnsafeUpdates = true;
- Create new list item object and add new item for newly created list object
                SPListItem item = list.Items.Add();
- Assign value for newly created item
                item["Title"] = "Title1";
- Update item which will add new item to list
                item.Update();
- if you want to manipulate on newly created item then you can get id of the newly created item by following way
                itemId = item.ID;
        }
}

-That’s it for adding new item to your sharepoint list.

How to Create New Sharepoint List Programmatically

Creation of new list includes following things.
- Create new list
- Create new field to newly created list
- Create new field which will set default value when new item created
- Show newly created field in view list of list
- Create lookup column to newly created list
- If list is already exist then create column to it


Here is the steps to create product list and columns in it.
(1) First, get list with name “Product” and check whether list is not null.
SPList ListProduct = web.Lists.TryGetList(“Product”);
if (ListProduct == null)
{
(2) if “Product” list is null then following step will create new list for sharepoint
web.Lists.Add(“Product”, "Product List Instance", SPListTemplateType.GenericList);
web.Update();
(3) After Creation of list “Product”, again, Get newly create list “Product”
SPList ProductList = web.Lists[“Product”];
(4) if you want to set product list to be appear on quick launch bar of sharepoint site then make it true/false accordingly
ProductList.OnQuickLaunch = false;

(5) Create field with name “Active”, if you want to add default value for field this way you can add default value
SPFieldBoolean fldActive = (SPFieldBoolean)ProductList.Fields.CreateNewField(SPFieldType.Boolean.ToString(), "Active");
fldActive.DefaultValue = "1";
ProductList.Fields.Add(fldActive);
(6) Simply, if you want to add field and there is no need to put any default value on the time of creation of new item you can add field by following way.
ProductList.Fields.Add("Description", SPFieldType.Note, false);

(7) After adding fields to List, update list.
ProductList.Update();

(8) After creation of list, then adding new fields to list, if you want to add newly added fields to view list of list then call following function.
CommonMethods.SetFieldInViewField(ProductList, "Active");
CommonMethods.SetFieldInViewField(ProductList, "Description");
(9) from above code we have added those column which are simple to add, but if you want to add any lookup column to list then use following step.
- Get list which you want to use as reference to lookup column
SPList ListCategory = web.Lists.TryGetList(“Category”);
- Call following function which will add new column named “Category” to “Product” list and adds reference of list “Category” with its field “Title”
CommonMethods.CreateLookupColumn(ProductList , ListCategory, "Category", "Title");

(10) Again, after creation of field, just put “Category” field to view list of list
//========== put field in view fields ==========//
CommonMethods.SetFieldInViewField(ProductList , "Category");
}

- To Set field in view list of list, use following function
public static void SetFieldInViewField(SPList ListName, string _Str_Column_Name)
{
SPView oView = ListName.Views["All Items"];
SPViewFieldCollection collViewFields = oView.ViewFields;
collViewFields.Add(_Str_Column_Name);
oView.Update();
}
- To add lookup column, use following function
public static void CreateLookupColumn(SPList Lst_Source_List, SPList Lst_Lookup_List, string _Str_Target_Column_Name, string _Str_Lookup_Column_Name)
{
SPList ListTest = Lst_Source_List;
ListTest.Fields.AddLookup(_Str_Target_Column_Name, Lst_Lookup_List.ID, false);
SPFieldLookup lkp = (SPFieldLookup)ListTest.Fields[_Str_Target_Column_Name];
lkp.LookupField = Lst_Lookup_List.Fields[_Str_Lookup_Column_Name].InternalName;
lkp.Update();
}

- To create new column when list is exist follow steps given below.
(1) SPList ListProduct = web.Lists.TryGetList(“Product”);
(2) if(ListProduct != null)
{
- Check whether the column with name “SortOrder” is not exist then add new column
if (!ListProduct .Fields.ContainsFieldWithStaticName("SortOrder"))
{
- Add new column and update list
ListProduct .Fields.Add("SortOrder", SPFieldType.Number, false);
ListProduct .Update();
- Add newly created column to view list of the list
//========== put field in view fields ==========//
CommonMethods.SetFieldInViewField(ListProduct , "SortOrder");
}
}
so, that’s it for all. 

Create your first setup project for Outlook Add-in

Here is the steps which will show you how to create your first outlook add-in and setup project for same Outlook Add-in.

Please follow steps given below to create your first Outlook Add-in which will be installable in your Outlook 2010.

(1) Create new project for Outlook Add-in by navigating
File –> New –> Project –> Visual C# –> Office –> 2010 –> Outlook 2010 Add-in –> Give it any name “MyFirstAddIn” and click OK.

(2) To work with code, just put following line of code in auto generated event “ThisAddIn_Startup”
“MessageBox.Show("hi");”
Add namespace “using System.Windows.Forms;” for above code
After putting this code it will look like following screenshot.

(3) Now, to create Setup project for above Outlook Add-In follow steps given below in same project solution.

(4) Right Click on solution –> Add –> New Project –> Other Project Types –> Setup and Deployment –> Visual Studio Installer –> Setup Project –> Give it any name “MyFirstSetup” and click OK.

(5) Right Click on “MyFirstSetup” –> View –> File System. It will open up with File System area with following options on Left Hand Panel. (1) Application Folder (2) User’s Desktop (3) User’s Program Menu

(6) Right Click on “Application Folder” –> Add –> Project Output and it will open up with following screenshot.

Select your Add-in project and select Primary Output then click on OK.
It will selects all dlls and runtime files needed for this output in Right Hand Side panel. Again, Right Click on “Application Folder” –> Add –> File and it will open with “Add Files” dialog, navigate to your Add-in project’s bin folder then select Debug folder and select “MyFirstAddIn.vsto” & “MyFirstAddIn.dll.manifest” file and click OPEN. Again, you will find this two files were added to Right Hand side panel.

- To add Manufacturer path for this installation Right Click on “Application Folder” –> Properties Window –> Default Location and put value “[AppDataFolder][Manufacturer]\[ProductName]” in Default Lcoation.


(7) Right Click on “MyFirstSetup” –> View –> Registry. It will open up with Registry area with following options on Left Hand Panel shown below in screenshot.

(8) From this pane, Expand HKEY_CURRENT_USER –> Software. Follow the steps given below to add your registry entry.

- Under Software there will be default “[Manufacturer]” key is added, rename it with “Microsoft”
- Right Click on Microsoft –> New –> Key and name key to “Office”
- Right Click on Office –> New –> Key and name key to “Outlook”
- Right Click on Outlook –> New –> Key and name key to “AddIns”
- Right Click on AddIns –> New –> Key and name key to “MyFirstAddIn”.

(9) After creating your Registry key “MyFirstAddIn”, follow steps given below to add your values.

- Right Click on Registry Key MyFirstAddIn –> New –> String Value and name it “Description”, Right Click on Description –> Property Window –> Value –> “My First Outlook Addin”
- Right Click on Registry Key MyFirstAddIn –> New –> String Value and name it “FriendlyName”, Right Click on FriendlyName –> Property Window –> Value –> “MyFirstAddIn”
- Right Click on Registry Key MyFirstAddIn –> New –> DWORD Value and name it “LoadBehavior”, Right Click on LoadBehavior –> Property Window –> Value –> “3”
- Right Click on Registry Key MyFirstAddIn –> New –> String Value and name it “Manifest”, Right Click on Manifest –> Property Window –> Value –> “[TARGETDIR]MyFirstAddIn.vsto|vstolocal”

That’s it for your first setup project of your Outlook Add-in, navigate to your Add-in's bin –> Debug –> Click On “MyFirstSetup” or “Setup” and follow installation step. After installation completed, restart your Outlook and on start it will ask you to Install our Add-in into outlook. Click on Install. After installation, it will prompt you with “hi” Message Box. So, every time you open up your Outlook it will prompt with “hi” Message Box. This way you can put your own code in event start up and create setup for that and after installing it you can achieve your goal.

Wroking with Active Directory and Some Error Resolution

Active Directory 
(1) Active Directory and .NET


(2) Howto: (Almost) Everything In Active Directory via C#


(3) Active Directory With C#


(4) Active Directory Display all properties in a table


(5) Integrating LDAP Active Directory into your ASP.Net Web Portal (C# or VB.NET)


Active Directory Tips
(1) Changes Between IIS 6.0 and IIS 7 Security : Migration from IIS 6.0 : Planning Your IIS 7 Architecture : The Official Microsoft IIS Site


(2) Understanding Built-In User and Group Accounts in IIS 7 : Configuring Security : Installing and Configuring IIS 7 : The Official Microsoft IIS Site


(3) Troubleshooting Tips


(4) Resetting Passwords in Active Directory with C# ASP .NET


(5) Active Directory user password expiration date .net /OU Group Policy


Error Troubleshooting With Active Directory
(A) Sharepoint: An operations error occurred
(1) An Operations Error Occured


(2) Impersonation in ASP.NET causes [ COMException (0x80072020): An operations error occurred. 


(3) DirectorySearcher on Sharepoint: An operations error occurred


(B) The attribute syntax specified to the directory service
(1) The attribute syntax specified to the directory service... RSS


(C) a device attached to the system is not functioning. active directory
(1) creating a user in Active Directory: A device attached to the system is not functioning


(2) Samba with active directory groups with special character


(3) Object names


(4) How to add a user in Active Directory with name longer than 20 characters?


(D) The server is not operational.
(E) Exception has been thrown by the target of an invocation.

Working with Masterpages in Sharepoint

Here is some links that will show how to inline code for Masterpage in sharepoint. Also, if you find "Code Block are not allowed in this file" error while you are adding some code blocks to your sharepoint master page follow links given below.

(1) Writing inline code in SharePoint aspx pages.

(2) Code Block are not allowed in this file

(3) How to allow inline code in unghosted master pages?

(4) How to run inline code in SharePoint aspx pages

(5) Sharepoint Inline c# Code

Service Unavailable HTTP Error 503. The service is unavailable

Here is some links that i found while i get error "Service Unavailable HTTP Error 503. The service is unavailable" for my running sharepoint web application.
(1) Service Unavailable HTTP Error 503. The service is unavailable

(2) HTTP Error 503. The service is unavailable. in SharePoint 2010 Central Administration

(3) SharePoint Central Administration – Service Unavailable HTTP Error 503

(4) HTTP Error 503. The service is unavailable in SharePoint

(5) SharePoint 2010 Troubleshooting: 503 Service Unavailable, App Pool Shutdown

Some Important Links for Sharepoint

Here is some important links when working with Sharepoint.
(1) SharePoint 2010 Internal Field Names

(2) Default Server Ribbon Customization Locations

(3) Field Element (List)

(4) Chapter 3: Programming SharePoint Lists and Libraries

(5) Changing Service Accounts in SharePoint 2010

(6) Change SharePoint 2010 Service Account Passwords

(7) SharePoint Resources

(8) Change the Active Directory User Password Through SharePoint

(9) Latest Tips

(10) Create Custom List Templates in CAML

(11) SharePoint: Permission Levels, SPBasePermissions and PermissionMask

(12) Adding Code-Behind Files to Master Pages and Content Pages in Windows SharePoint Services 3.0


(13) How to reset SharePoint 2010 List forms from InfoPath to the default forms?


(14) How do I create custom properties in Visual Web Parts?


(15) How to add site collection administrator programmatically


(16) Formatting Overview


(17) Configuring Custom Master Page in SharePoint 2010


(18) Access a Forms Based SharePoint Site's Web Service

Working with Modal Popup in Sharepoint 2010

Here is some links about working with Modal Popup in sharepoint.
(1) Open the SharePoint 2010 Modal Dialog

(2) Sharepoint 2010: Open Modal Dialog from EditControlBlock

(3) Open list item modal dialog (lightbox) with a hyperlink in SharePoint 2010

(4) Working with SharePoint 2010 modal dialogs

(5) Opening a SharePoint 2010 Modal Dialog Box from an InfoPath 2010 Form

(6) How to close the sharepoint modal dialog and refresh the parent page.

(7) How to – SharePoint 2010 – JS client object model and UI advancements

(8) Using the SharePoint 2010 Modal Dialog

(9) SharePoint 2010 Application Pages and Modal Dialogs the easy way

(10) How to close the sharepoint modal dialog and refresh the parent page.

(11) Using the Dialog framework in SharePoint 2010

(12) Using the SharePoint Foundation 2010 Managed Client Object Model

(13) SP.UI.ModalDialog.commonModalDialogClose(dialogResult, returnVal) Method

(14) SP.UI.ModalDialog Methods

(15) SharePoint 2010 Modal Dialog

Querying sharepoint list item data using jQuery

Here is some links that shows how to querying sharepoint list item data using jQuery.
(1) Querying SharePoint List Items using jQuery

(2) AJAX calls to SharePoint web services using jQuery | SharePoint Snippets

(3) javascript- Stack Overflow

(4) Lists.asmx, GetListItems and Folders « Paul Galvin's SharePoint Space

(5) Chapter 13: The Client Object Model and jQuery

Working with Event Receiver in Sharepoint 2010 Lists

Here is some links about Binding Event Receiver on Lists of Sharepoint 2010.
(1) How to Create Event Receivers for Windows SharePoint Services 3.0

(2) Add Event Receivers to SharePoint 2010 Lists

(3) Create Custom List Definitions in SharePoint 2010

(4) Using the Event Handler in SharePoint 2010.sharepointbriefing.com

(5) Creating Event receiver in SharePoint 2010 : Learning SharePoint

(6) Chaks' Corner | Event Receivers in SharePoint 2010

(7) List Definition from Content Type using Event Receiver- Site Home - MSDN Blogs

(8) How Do I: Create Event Receivers for SharePoint 2010 in Visual Studio 2010?

(9) Creating custom list event receivers in SharePoint 2007 « aarebrot.net

(10) SharePoint Kings: Redirection from event handler

(11) How to: Access, Copy, and Move Files

(12) Walkthrough 2 – Developing an Event Receiver for a Document Library « Karine Bosch’s Blog

(13) How to copy newly added document with metadata to another document library?

(14) Move a document from one library to another library using event eceiver- Stack Exchange

(15) document library- Copy To Folder - SharePoint - Stack Exchange

(16) SharePoint 2010: Redirecting User to a Custom Page from Event Receiver « Razi [SharePoint MVP] Blog

(17) Creating SharePoint 2010 Event Receivers in Visual Studio 2010

(18) Using Event Receivers in SharePoint Foundation 2010 (Part 1 of 2)

(19) SharePoint Document Library item title in Event Receiver AfterProperties

(20) Walkthrough: Add List Event Receiver dynamically at runtime in SharePoint 2010

(21) How to: Create an Event Receiver for a Specific List Instance

(22) Add a Counter to a SharePoint List Using an Event Receiver

(23) SharePoint: Writing a Custom Event Receiver

==> Remove event receiver
(1) Deleting an Event Receiver using STSADM

(2) Remove Event Receiver in Sharepoint List

(3) Delete event receiver from a SharePoint list

(4) How to add/delete an event receiver to a single list with PowerShell in SharePoint 2010

Working with DataSheet View in Sharepoint 2010

Here is some links about DataSheet View in sharepoint 2010.

(1) Enabling DataSheet View in SharePoint 2010

(2) Data Sheet View Not Working? | SharePoint Blues

(3) SharePoint 2010 Datasheet view not available | Train-A-Scope- Linking People and Technology - Steven Knight Training

(4) Nicholas Bisciotti's Blog: SharePoint Datasheet View, Office 2010 Compatibility

(5) errors in micosoft share point: The list cannot be displayed in datasheet view wss, error message Moss "Server Error in '/_vti_bin' Application"

(6) Use Datasheet view in 64-bit Office 2010- Office.com

(7) Create Datasheet view missing

(8) SharePoint 2010 : Use the Datasheet View to Add, Edit, or Delete Items and Files, exercises, practises, tutorials, solutions about Sharepoint

(9) You cannot view a list in Datasheet view after you install the 64-bit version of Office 2010

(10) SharePoint View Permission & Column Permission | Try Free

(11) How to Disable Data Sheet View for Users in SharePoint 2010?

(12) Know SharePoint: SharePoint Datasheet View and Office 2010 64-bit

(13) SharePoint 2010 Help » Datasheet view

(14) SharePoint 2010 Datasheet View Bugaboo » Marc D Anderson's Blog

Download Details for Datasheet View
(1) Access 2007 Download: Access Runtime

(2) Microsoft Access 2010 Runtime

(3) Microsoft Access Database Engine 2010 Redistributable

(4) 2007 Office System Driver: Data Connectivity Components

Some Error Resolutions while working Programmatically in Sharepoint 2010

Here is errors and links related to error occurred during programming with sharepoint.

(1) Error occurred in deployment step 'Recycle IIS Application Pool': The vssphost4.exe process was unable to start due to an unknown error or problem.

- Interesting registry settings to help debugging SharePoint Tools Extensions in Visual Studio 2010

- VSX « Second Life of a Hungarian SharePoint Geek

- Visual Studio 2010 extension for helping SharePoint 2010 debugging

(2) One or more field types are not installed properly. Go to the list settings page to delete these fields.
- this is because some of the field in CAML query could be written/spelled wrongly.

(3) Invalid data has been used to update the list item. The field you are trying to update may be read only.
- when there is any lookup field exist and in that we provide any information that is not exist in source table then it will throw error like this.

(4) The data source does not support server-side data paging.
- when we are working paging in grid and we are fetching items using LINQ if list is not returning ToList() then it will give error shown here.

(5) The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
- its looking for referenced assembly in GAC
- its looking for referenced assembly in SafeControl directive of Web.config file.

(6) The security validation for this page is invalid. Click Back in your Web browser, refresh the page, and try your operation again.
    - The security validation for this page is invalid. Click Back in your Web browser, refresh the page, and try your operation again.

    - SPSecurity.RunWithElevatedPrivileges to update SPRoleAssignment of an SPListItem

    - The security validation for this page is invalid. Click Back in your Web browser, refresh the page, and try your operation again.
   
(7) SPDataGrid error 'Unable to cast object of type int32 - SPDataGrid.NewPageIndex property and DataKeyNames

http://blog.sharepointsite.co.uk/2010/10/spdatagrid-error-unable-to-cast-object.html

(8) The server was unable to process the request due to an internal error.  For more information about the error, either turn on IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute or from the configuration behavior) on the server in order to send the exception information back to the client, or turn on tracing as per the Microsoft .NET Framework 3.0 SDK documentation and inspect the server trace logs.

    - AnswerFBA in sharepoint 2010

    - The server was unable to process the request due to an... RSS

(9) This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold (8) enforced by the administrator.
   
    - This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold (8) enforced by the administrator

    - This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold (8) enforced by the admin..

(10) SQL database login for 'SharePoint_Config' on instance 'Username' failed.
- SQL database login for 'SharePoint_Config' on instance 'SP_2010_TESTQA_SQL' failed.

(11) This solution contains no resources scoped for a web application and cannot be deployed to a partucular web application.
- Issues Deploying SharePoint Solution Packages

- This solution contains no resources scoped for a Web application and cannot be deployed to a particular Web application

- This solution contains no resources scoped for a Web application – Sharepoint WSP deployment exception

(12) Error occurred in deployment step 'Recycle IIS Application Pool': 0x80070005Access denied.
- Deploy Solution to Site configured with Claims-based Authentication

- Error occurred in deployment step 'Recycle IIS Application Pool': Provider load failure

- Error occurred in deployment step ‘Recycle IIS Application Pool’

Working with Calculated Column in Sharepoint

Here is some links about Calculated column in sharepoint list.
(1) SharePoint - get value of calculated field without manual parsing

(2) About SharePoint Calculated Columns

(3) SharePoint calculated column and jQuery Highlight row

(4) Controlling the Result Type for Calculate Fields

(5) SharePoint List Calculated Column - Calculate Business Days

(6) Calculated Field Formulas

(7) Examlples of common furmulas - Windows Sharepoint Service - Office.com

(8) Programmatically setting field value for sharepoint listitem

(9) SharePoint Calculated Columns Formulas

(10) Adding Calculated Field in SharePoint List Programmatically

(11) WSS Practice: Create a list, columns and view programmatically

Links to calculate field value
(1) Aging Calculated Fields in SharePoint

(2) Common Date Time formulas for Sharepoint – Calculated Fields « Abstract Spaces

(3) How to calculate age of list items in SharePoint

(4) Using [Today] in SharePoint calculated default values

(5) SharePoint Calculated columns – Adding hours onto a date field

(6) Gantt charts Start/End date on calculated columns

(7) The Truth about using [Today] in SharePoint Calculated Columns

(8) Working Days, Weekdays and Holidays in SharePoint Calculated Columns

(9) SharePoint Calculated Column Cheat Sheet

(10) How to use [Today] in a SharePoint list

(11) Advanced SharePoint View and Filter techniques