Friday, 29 July 2016

SPService with code description

Refer link 1

Refer Link 2

Below is the code for Add item and Get items from List.

<script src="http://code.jquery.com/jquery-1.7.2.min.js" type="text/javascript"></script>
// <script type="text/javascript" src="//cdnjs.cloudflare.com/ajax/libs/jquery.SPServices/2014.02/jquery.SPServices.min.js"></script>
<script type="text/javascript" src="http://cdnjs.cloudflare.com/ajax/libs/jquery.SPServices/0.7.1a/jquery.SPServices-0.7.1a.min.js"></script>
<script type="text/javascript">

$(document).ready(function () {
                 $("#btnSubmit").click(function () {
                                         var fname = $("#fname").val();
                                                                 var lname = $("#lname").val();
                                                                 addNewListItem(fname,lname);
            });
                                                GetSpeakers();
        });
                               
                                function addNewListItem(name,last) {
                                                  $().SPServices({
                operation: "UpdateListItems",
                async: false,
                batchCmd: "New",
                listName: "RestList",
                valuepairs: [["Fname", name],["Lname", last]],
                completefunc: function (xData, Status) {
                    alert("Data Saved! and Please check your List");
                }
            });
                                }
                               
                                function GetSpeakers()
        {
         var method = "GetListItems";
       
         var list = "RestList";
         var fieldsToRead =     "<ViewFields>" +
                                "<FieldRef Name='Title' />" +
                                "<FieldRef Name='Fname' />" +
                                "<FieldRef Name='Lname' />" +
                            "</ViewFields>";
       
                                var query = "<Query><OrderBy><FieldRef Name='Title' /></OrderBy></Query>";

       
        $().SPServices({
                operation: method,
                async: false, 
                listName: list,
                CAMLViewFields: fieldsToRead,
                  CAMLQuery: query,
                      
                    completefunc: function (xData, Status) {
                     
                        $(xData.responseXML).SPFilterNode("z:row").each(function() {
                     
                            var name = ($(this).attr("ows_Title"));
                           
                     
                            var Fname = ($(this).attr("ows_Fname")).split(",")[0];
                           
                     
                            var Lname = ($(this).attr("ows_Lname")).split(",")[0];
                           
                     
                            AddRowToTable(name,Fname,Lname);
                           
                        });               
                    }
        });

                                }

                                function AddRowToTable(name,Fname,Lname)
                                {
                                                $("#speakerTable").append("<li>'" + name + "'</li>");
                                }
                               
</script>

SP Service code for update list item

function addNewListItem(name,last) {
                                                  $().SPServices({
                operation: "UpdateListItems",
                async: false,
               ID: “1”,
                batchCmd: "Update",
                listName: "RestList",
                valuepairs: [["Fname", name],["Lname", last]],
                completefunc: function (xData, Status) {
                    alert("Data Saved! and Please check your List");
                }
            });

                                }

No comments:

Post a Comment