As we know WCF supports various hosting options. Self Hosting is one of them. What is Self Hosting? WCF allows hosting a service in an application such as Console Application. Create a Console Application Project to host a WCF Service. Add WCF Service project Reference in this Console Application. Delete existing App.config file. Add new … Read more
If you are new to WCF services then please read my earlier blogs. Go through with this link – WCF Tutorial step by step.WCF supports a various way to host a service. In this blog, I will explain about Hosting a WCF Service in IIS. How to host WCF service in IIS? Step 1: Create … Read more
Below Power Shell Script will Unlock a SharePoint site if it is in locked/read-only.#Region variable declarationWrite-Host “UnLock status started…..”Add-PSSnapin Microsoft.Sharepoint.PowershellSet-SPSite -Identity “<site-url>” -LockState “Unlock”Write-Host “Task completed…..”Read-Host -Prompt “The above error occurred. Press Enter to exit.”For -LockState attribute there are mainly 4 parameters that can be used:Unlock – To unlock site collection and make it available to … Read more
What is JSON? JSON stands for JavaScript Object Notation. JSON is a data exchange format between javascript and server-side languages like JSP, ASP.NET etc. How to write data in JSON format ? Within the script tag, we write JSON data format. Benefit of using JSON JSON is a lightweight data exchange format built into Java … Read more
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 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
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 … Read more
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
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 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
