HTML Form Validations

In this blog, we will see HTML form validation code in JavaScript. My another blog on AMP HTML and Angular JS.Form validation for Alphabet only: Sometimes you may require allowing the only alphabet in a particular input field. For Eg first name and last name, a field should not allow any other character apart from … Read more

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

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 dropdown2 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. Visual WebPart ASCX code: <asp:DropDownList ID=”ddlList” AutoPostBack=”true” runat=”server”     onselectedindexchanged=”ddlList_SelectedIndexChanged”></asp:DropDownList><p>    <asp:Label … Read more

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