Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have scenario where i need to bind sharepoint list to the dynamically cretaed html table using jquery and use the jquery file in content editor webpart to show the table in site.Please help me with this regards.I am using sharepoint 2010.I am very new bee to jquery and sharepoint so i have tried something form my side please help me out i ma unable to find way to do it.Thanks in advance

<script type="text/javascript" language="javascript">
    var _clientContext;
    var _web;
    alert("Working")
    //ExecuteOrDelayUntilScriptLoaded(RetrieveListItems, "sp.js");


    function RetrieveListItems() {
        alert("Test");
        _clientContext = new SP.ClientContext.get_current();
        alert(Context);
        _web = _clientContext.get_web();
        alert(web);
        var list = _web.get_lists().getByTitle('Planning Partners');
        alert(list);
       // var camlQuery = new SP.CamlQuery();
        var myquery = new SP.CamlQuery.createAllItemsQuery();
        allItems = list.getItems(myquery);
        _clientContext.load(allItems);
        _clientContext.executeQueryAsync(Function.createDelegate(this, this.success), Function.createDelegate(this, this.failed));
    }

    function success() {
        var Image = null;
        var Linkurl = null;
        var Title = null;
        //        var sHtml = "";
        alert("success");
        var ListEnumerator = this.allItems.getEnumerator();

        while (ListEnumerator.moveNext()) {

            var currentItem = ListEnumerator.get_current();

            Image = currentItem.get_item('Image');
            Linkurl = currentItem.get_item('Linkurl');
            Title = currentItem.get_item('Title');
            //var tbl = document.createElement("tbl");
            var row = document.createElement("tr");
            var $table = $('<table>');
            $table.append('<caption>MyTable</caption>')
            $table.append('<thead>');
            $table.append('<tr>');

            if (Image != oListItem.get_item('Image')) {
                var cell = document.createElement("td");
                var cellText = document.createElement("<image imgurl='" + oListItem.get_item('Image') + "'></Image>");
                cell.appendChild(cellText);
                row.appendChild(cell);
            }


            if (Linkurl != oListItem.get_item('Linkurl')) {
                var cell = document.createElement("td");
                var cellText = document.createElement("<a target='_blank'  href ='" + oListItem.get_item('Linkurl') + "'>" + oListItem.get_item('Title') + "</a>");
                cell.appendChild(cellText);
                row.appendChild(cell);
            }

            if (Title != oListItem.get_item('Title')) {
                var cell = document.createElement("td");
                var cellText = document.createElement("<p>" + Title + "</p>");
                cell.appendChild(cellText);
                row.appendChild(cell);
            }
            $table.append('</tr>');
            $table.append('</thead>');
            tblBody.appendChild(row);
            tbl.appendChild(tblBody);
            body.appendchild(tbl);
        }
    }


    //            sHtml += '<table><tr><td><img src="' + Image + '" height="55px" width="55px"></td><td><table><tr><td valign="top"><div class="fieldsTitle">' + Linkurl + '</div></td></tr><tr><td valign="top">' + Title + '<a href="/">Read More >></a></td></tr><tr><td></td></tr></table></td></tr></table>';

    //        document.getElementById('MainDiv').innerHTML = sHtml;
    //    }

    function failed(sender, args) {
        alert("failed Message" + args.gte_message());
    }
</script>
share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.