April 2016
SPQuery and SPSiteDataQuery in SharePoint
.
Before reading this blog, you may also like to know about CAML Query. You can know about CAML Query in details. In this blog, we will see SPQuery and SPSiteDataQuery. SPQuery and SPSiteDataQuery in SharePoint 2010 SPQuery – SPQuery can be used to query a single list. SPQuery query = new SPQuery(); SPSiteDataQuery –…
Important SQL Query asked in Interview
.
Important SQL Query asked in InterviewSQL query to check a record in table, if exist then insert else update the record. BEGIN IF EXISTS (SELECT * FROM [users] WHERE email=@email) UPDATE [users] SET updated_date = GETDATE() WHERE email=@emailELSE INSERT INTO [users] (uid,first_name,last_name,email,password,gender,is_active,reg_date) VALUES (NEWID(),@fname,@lname,@email,@password,@gender,1,GETDATE())ENDStored procedure to return id of last inserted record:@id int…
Attach existing Content Database to new SharePoint Site Collection
.
This blog will describe how to attach, detach a content database.Below is the scenario – You created a new Site collection in SharePoint 2010.Now you want this site collection to work with your existing Content database. Simply you can be asked that you have an existing content database and you need to attach it with…
What is JQuery Callback Function?
.
A call back function executed after the current event has completed. Java Script code executes line by line. However, if next line of code executes even before completing the action(s) which wrote in previous lines. This may create an error. To avoid this, we can create Callback function. JQuery Callback Function Syntax Syntax: $(selector).hide(speed,callback); To…
JQuery Events Methods
.
Like a programming language, a JQuery also has some events. JQuery event occurs on a web page when a user takes some actions like the mouse click, mouse scroll, check box selection etc. Below are some events. Mouse Events Keyboard Events Window Events Form Events Click Key press Load Submit Double Click Key down Scroll…
JQuery Selectors
.
JQuery selectors allow you to select and manipulate HTML elements. JQuery selectors find HTML elements based on id, name, attribute, classes etc. General syntax for JQuery selector is $()Ex: Element selector$(“p”) – select all p element on that page. ID selector $(“#txtUserName”) – select control with mention id. Class selector $(“.myclass”) – select control, html element which…
Master Page and Branding in SharePoint 2010
.
MasterPage and Branding in SharePoint What is branding? – Branding means to design or recreate a page for a site which may use SharePoint Master Page. What is Master Page? – Master Page gives a consistent layout through out the site. For eg – Header, Footer, Top Menu Why We need to do Branding ?…
What is new in SharePoint 2013?
.
SharePoint 2013 is the next version of SharePoint 2013. What’s new in SharePoint 2013? SharePoint 2013 gives more powerful features compare to SharePoint 2010. Few features are – SharePoint 2013 App Model Workflows with the introduction: a new, highly scalable workflow framework. User experience (UX) improvements. Sandbox Solution deprecated in SharePoint 2013 OOTB PDF support Web…
Display SharePoint List Items using ECMA Script – Client Object Model
.
Display SharePoint List Items using ECMA Script In this blog, I will explain, how to get list items using ECMA Script.ECMA script is a client side way to work with SharePoint object. Create a web part page in page library. Add a content editor web part on that page.In content editor webpart write below code:…
REST API in SharePoint 2010 for CRUD operation with ListData.svc
.
REST API in SharePoint 2010 for CRUD Operation SharePoint 2010 offers numerous ways to get data from a list. You may use Client Object Model, Linq to SharePoint and REST API by using ListData.svc. In this blog, I will explain how to perform CRUD operation on a SharePoint list using ListData.svcGenerally, SharePoint REST service URL…
WCF tutorial – Learn WCF quickly
.
WCF tutorial – Learn WCF quickly WCF stands for Windows Communication Foundation and used for developing distributed system. WCF services can communicate with.Net applications and Non-Microsoft technology as well. ABC of WCF (A) Address – Where to bind, which is also called as EndPoint (B) Binding – How to bind (C) Contract – What to…
Error – The user does not exist or is not unique SharePoint 2010
.
Currently I was doing some settings for super accountIn this context, I executed below command in powershell window. stsadm -o setproperty -propertyname portalsuperreaderaccount -propertyvalue account -url “<site-url>” But my site stops working and got below screen while access url with error message. “The user does not exist or is not unique SharePoint 2010“ So I…
MasterPages in SharePoint 2013
.
As we know that there are huge changes in look and feel of SharePoint 2013 while compare to SharePoint 2010. This is all because of Master Page. There are 2 types of MasterPage which is being used in SharePoint 2013. Oslo masterpage and Seattle masterpage On Oslo masterpage left nav is removed and in Seattle…
Client Side Object Model in SharePoint 2010
.
SharePoint 2010 offers a useful way to access SharePoint objects from the client side. A developer can use .Net managed code, ECMAScript to access SharePoint objects like List, Site, Library etc.On this blog, I will write a code to select data from SharePoint list. I will use .Net managed code to do this.First of all, you…
Migrate SharePoint 2010 Application to SharePoint 2013 Step by Step
.
Migrate SharePoint 2010 to SharePoint 2013, Step by StepIn this blog, I will explain about migration from SharePoint 2010 to SharePoint 2013 which I did.PrerequisiteBe ready with a new SharePoint 2013 FarmThe first Step is related to Database as Data is important. To avoid data loss first set Database to read only. To do this go to…
