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 – … Read more

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 … Read more

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 … Read more

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 … Read more

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 … Read more

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 … Read more

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: … Read more