Sharepoint - Asp.net - MVC - C# - Sql server - Jquery - Javascript

Ajax method without parameters   $.ajax({ type: "POST", contentType: "application/json", data: "{}", url: "abcd.aspx/GetEvents", dataType: "json", success: function (data) {  }); }, error: function (XMLHttpRequest, textStatus, errorThrown) { debugger; } });   Ajax method with parameters $.ajax({ type: "POST", contentType: "application/json", data: strdata, url: "ViewEvents.aspx/GetEventsByDates", dataType: "json", success: function (data) {    }); }, error: function (XMLHttpRequest, textStatus, errorThrown) { debugger; } });   $.ajax({ type: "POST",...

CAML Query tutorial for SharePoint In this article, we will understand the basics of CAML query in SharePoint. What is CAML?   Ø     CAML -   Collaborative Application Markup Language   Ø     XML - Extensible Markup Language based query language   Ø     Used to perform a   query   operation against   SharePoint Lists How SharePoint List Items are retrieved? SharePoint List data can be retrieved in any one of the following ways: 1.   Using the SharePoint object model   – used when code runs on the server         ( Example:   Developing a web part or an application page) 2.   Using the SharePoint Lists web service   – used when your code doesn’t run on the server where the SharePoint is installed ( Example : Developing a windows application) 3.   Using Power shell   –used mostly by the ADMIN of the SharePoint when they quickly wa...

            string app_id = "";             string app_secret = "";             string scope = "publish_stream,manage_pages";             if (Request["code"] == null)             {                 Response.Redirect(string.Format(                     "https://graph.facebook.com/oauth/authorize?client_id={0}&redirect_uri={1}&scope={2}",                     app_id, Request.Url.AbsoluteUri, scope));        ...

Keyboard Shorcuts (Microsoft Windows) 1. CTRL+C (Copy) 2. CTRL+X (Cut) 3. CTRL+V (Paste) 4. CTRL+Z (Undo) 5. DELETE (Delete) 6. SHIFT+DELETE (Delete the selected item permanently without placing the item in the Recycle Bin) 7. CTRL while dragging an item (Copy the selected item) 8. CTRL+SHIFT while dragging an item (Create a shortcut to the selected item) 9. F2 key (Rename the selected item) 10. CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word) 11. CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word) 12. CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph) 13. CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph) 14. CTRL+SHIFT with any of the arrow keys (Highlight a block of text) SHIFT with any of the arrow keys (Select more than one item in a window or on the desktop, or select text in a document) 15. CTRL+A (Select all) 16. F3 key (Search for a file ...

Query to Find Column From All Tables of Database SELECT t.name AS table_name , SCHEMA_NAME ( schema_id ) AS schema_name , c.name AS column_name FROM sys.tables AS t INNER JOIN sys.columns c ON t. OBJECT_ID = c. OBJECT_ID WHERE c.name LIKE '%EmployeeID%' ORDER BY schema_name , table_name ;   Find Column Used in Stored Procedure – Search Stored Procedure for Column Name SELECT obj.Name SPName , sc. TEXT SPText FROM sys.syscomments sc INNER JOIN sys.objects obj ON sc.Id = obj. OBJECT_ID WHERE sc. TEXT LIKE '%' + 'Name Your Column Here' + '%' AND TYPE = 'P' How to search every table and field in a SQL Server Database CREATE   PROC  SearchAllTables (      @SearchStr   nvarchar ( 100 ) ) AS BEGIN      -- Copyright © 2002 Narayana Vyas Kondreddi. All rights reserved.      -- Purpose: To search...