sharepointcafesp_addlinkedserver linked 2 servers. Once sp_addlinkedserver query executes, query can be run against these servers. Run below queries one by one to link, to provide login credentials and to access data EXEC sp_addlinkedserver @server=’ServerName’ EXEC sp_addlinkedsrvlogin ‘ServerName‘, ‘false’, NULL, ‘username’, ‘password’ select * from [ServerName].[DBName].[DBO].[TableName] Once your requirement is done, you may drop the linking by … Read more
As you know pagination is very important for any data control for eg Gridview if you have large amount of data. Server load on pagination is also a big concern.Below is the code for pagination in gridview using client side. It means no page load/ server post back operation will be performed. To implement this … Read more
What is Cookies? Cookies here refer as Web Cookies, HTTP Cookies is a small piece of code stored at user’s machine by bowers. Why we use Cookies ? To collect demographic information about who is visiting the Web site. Sites often use this information to track how often visitors come to the site and how … Read more
Java Script is the best way to validate a web form at client side and ensure the most accurate data to store from an HTML or asp.net web forms. In this blog, I will explain about all kind of validation that is used in an ASP.Net and HTML forms Java Script Form Validation in ASP.Net … Read more
I was working on a project where all my SharePoint inherits from a custom master page with predefined Page Layout. I got a requirement where i need to create few pages with different layouts. There are various ways to do this. One is to create a new Page Layout by coding and select your layout … Read more
Facebook is a popular social media. Most of the website provide login with facebook feature, why because each and every user over internet have facebook account. So login with facebook feature avoid filling a new signup form on a new website.Login with facebook is simple and secure as the api is given by facebook only.1. … Read more
Service Oriented Architecture (SOA) is a style to design software system where 2 or more component communicates with each other over a network through a defined protocol. Advantages of SOA architecture. Loosely Couple – A component in SOA architecture must be loosely coupled. One service does not require to know the technical and platform details … Read more
In this blog, We will see Object Oriented Programming Principal in simple and easy way. What is Object Oriented Programming Concept? Object oriented is an approach to do programming in C#, Java etc. Before object oriented programming structural programming model was in use. C programming language is an example of structural programming. But the problem … Read more
In this blog, I will explain how to crop an image and then upload that image using jQuery. Here you will come to know about preview an image, and then crop that image and finally upload it using jQuery and C# code. This implementation has been done using jQuery, so no post back only smooth … Read more
Below code will upload image in a particular folder and will show the list of images from that folder. User may delete images from that list.HTML Code:<div> <table style=”width: 90%”> <tr> <td style=”width: 50%”> … Read more