Create a Simple Stored Procedure in Sql Server

create procedure GetRequestbyId

//Parameters which pass from the Application Programme

@Id nvarchar (36)


select * from dbo.Requests where Id=@Id



Get Current Login User Details in SharePoint Web

 public class CurrentEmployeDetails
public static string loginName;
public static SPSite site;
public static string userName;

public static SPWeb Web()
site = new SPSite(SPContext.Current.Web.Url);
SPWeb web = site.OpenWeb();
return web;
public static string LoginName() // Returns Current Login User’s Login Name
loginName = Web().CurrentUser.LoginName.ToString();
return loginName;

public static string UserName() //Returns Current Login User’s User Name
userName = Web().CurrentUser.Name.ToString();
return userName;

Check Folder Exits in Sharepoint Document Library

using (SPSite site = new SPSite("Site Url"))

using (SPWeb web = site.OpenWeb())
//Check Folder path (Floder Already Exits or Not)
if (web.GetFolder(“DocumentLibraryName”/”FolderName”).Exists)
//Do Something

CAML Query for get only View Fields not all List Items in SharePoint List

//Get SharePoint List from SharePoint Site
SPList listEmp = currentWeb.Lists["Employee_Master"];

//Create SharePoint Query Object for use CAML Query
SPQuery qryEmp = new SPQuery();

//CAML Query to Get SharePoint List Records SharePoint List ( SPQuery object & CAML)

qryEmp.Query = “” + Name + “”;

//Select what are the fields you want to retrieve from CAML Query.(Not all Columns from SharePoint List)

qryEmp.ViewFields = string.Concat(
“<FieldRef Name=’Employee_ID’ />”,
“<FieldRef Name=’First_Name’ />”,
“<FieldRef Name=’Email’ />”,
“<FieldRef Name=’Login_ID’ />”,
“<FieldRef Name=’Immidiate_Supervisor’ />”,
“<FieldRef Name=’Department’ />”);

qryEmp.ViewFieldsOnly = true;

//Assign result data set (which are get from CAML Query with View Fields) to SPListItem Collection

SPListItemCollection itemCollectionEmp = listEmp.GetItems(qryEmp);

Elevate Privileges on C# Code in SharePoint


// This code scope runs as a System Account – Code run with elevated Privilages

using (SPSite currentSite = new SPSite(SPContext.Current.Site.Url))
using (SPWeb currentWeb = currentSite.OpenWeb())
currentSite.AllowUnsafeUpdates = true;
currentWeb.AllowUnsafeUpdates = true;

//Things what do you want

currentWeb.AllowUnsafeUpdates = false;
currentSite.AllowUnsafeUpdates = false;