Get List Items and display in html table using SOM

Question

Hi All I want to display the sharepoint 2010 list items in html table using SharePoint Object Model. Note: not in gridView and not using CSOM Can any one help me with this?? Thanks in advance:)

Hiren Thesiya · Answer

See below code private void GetListItems() { using (SPSite site = new SPSite( site url )) { using (SPWeb web = site.OpenWeb()) { SPList list = web.Lists.TryGetList( list title ); SPListItemCollection collection = list.Items; string html = string .Empty; foreach (SPListItem listItem in collection) { //build html as required html +=   + listItem[ column internal name to read ] +   ; } } } }

Nanddeep Nachan · Answer

Add Script Editor to SharePoint page with code as attached var siteUrl = '/sites/MySiteCollection' ; function retrieveListItems() { var clientContext = new SP.ClientContext(siteUrl); var oList = clientContext.get_web().get_lists().getByTitle( 'Announcements' ); var camlQuery = new SP.CamlQuery(); camlQuery.set_viewXml( ' ID\ '/>' + ' Number\ '>1 10 ' ); this .collListItem = oList.getItems(camlQuery); clientContext.load(collListItem); clientContext.executeQueryAsync(Function.createDelegate( this  this .onQuerySucceeded) Function.createDelegate( this  this .onQueryFailed)); } function onQuerySucceeded(sender args) { var listItemInfo = '' ; var listItemEnumerator = collListItem.getEnumerator(); while var oListItem = listItemEnumerator.get_current(); listItemInfo += '
ID: ' + oListItem.get_id() + '
Title: ' + oListItem.get_item( 'Title' ) + '
Body: ' + oListItem.get_item( 'Body' ); } alert(listItemInfo.toString()); } function onQueryFailed(sender args) { alert( 'Request failed. ' + args.get_message() + '
' + args.get_stackTrace()); }

Rajkiran Swain · Answer

using Microsoft.SharePoint; using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace SharePointData { class Program { static void Main( string [] args) { using (var site = new SPSite( http://waqasserver/sites/demo )) { var web = site.RootWeb; Console.WriteLine(web.Title); var lists = web.Lists; foreach (SPList list in lists) { Console.WriteLine( 	 + list.Title); } Console.ReadLine(); } } } }