Showing posts from October, 2015

HTML Form Validations

In this blog, we will see HTML form validation code in JavaScript. My another blog on AMP HTML and Angular JS .

How to access SharePoint List with List Web Service

SharePoint List Web service allow developers to access, manipulate List and List items through a service url. Generally List web service url format is :  http://site/_vti_bin/lists.asmx Now lest start consuming this service and manage SharePoint List. Open this url: http://spsite:1985/_vti_bin/lists.asmx Open Visual Studio 2010. Right click on project and add service reference. Then click on Advanced… (Refer below screen shot)

Bind Drop-down with SharePoint List and display list items in a Gridview

In this blog, I will explain about below point through C# code: 1. Bind all list in a dropdown 2 Load List items in a Gridview once a user changes list name in dropdown. You need to create a visual webpart in Visual studio 2010.

Difference between Stored Procedure and Function in SQL

Stored Procedure vs Function 1)Functions must return a value. Stored procedure need not be. 2)Stored procedures can be called using EXEC command where as Functions can be called from another SQL Statement. 3)Stored Procedures are precompiled. Functions are not precompiled. 4)Generally Stored procedures are used for executing business logic where as Functions are used to execute computations . 5)Functions can return only one value at a time where as stored procedures can return more than one value at a time. 6)Functions cannot return Images and text.Stored procedures can return all types of datatypes.