How To Read The SharePoint Lists

Shantanupatel
Posted by in SharePoint category on for Beginner level | Points: 250 | Views : 11378 red flag
Rating: 4.43 out of 5  
 7 vote(s)

This article explains about how to read the SharePoint Lists in a SharePoint Folder and Bind It To Repeater Control

A SharePoint List is a structure of items or rows and columns or fields that contain data provided by SharePoint.

It is similar to a collection of data in the form of a table. SPList is used to represent a SharePoint list

Approach


First step is to create a custom list in SharePoint Site. Please find the snapshot attached of the list created.



Code Sample:



Output Result:


Conclusion

Hope this helps!

Page copy protected against web site content infringement by Copyscape

About the Author

Shantanupatel
Full Name: Shantanu Patel
Member Level:
Member Status: Member
Member Since: 2/19/2010 8:01:15 AM
Country: India
Shantanu
http://www.dotnetfunda.com

Login to vote for this post.

Comments or Responses

Posted by: CP_RAJ on: 4/20/2011 | Points: 25
HI Patel,

Nice Article...

Always use "Using"
using (SPSite objsiteCollection = new SPSite(webAppURL))
{
using (SPWeb objSite = objsiteCollection.OpenWeb())
{
so that the object will get dispose...

Whether you have customize the master page in sharepoint...can you please give me tips....
Posted by: Ulf@bendsoft.com on: 8/2/2011 | Points: 25
Hi,

I suggest that you have a look at the Camelot .NET Connector for Microsoft SharePoint. Its a standard ADO.NET Connector that allows you to select, insert, update or delete data from SharePoint as if it was a typical sql server (with optional where or limit statements). It is also good for inserting data from a ASP.NET form or similar. In this specific case, you could write something like:

var connection = new SharePointConnection(@"
Server=sharepointserver;
User=spuser;
Password=******;
Authentication=Ntlm;
RecursiveMode=FilesOnly");

connection.Open();

var adapter = new SharePointDataAdapter(@"SELECT Title, SiteUrl FROM `SupportClaims/CustomerSupport`", connection);

var dataTable = new DataTable();
adapter.Fill(dataTable);

reptCustomerSupportTab.DataSource = dataTable;
reptCustomerSupportTab.DataBind();

connection.Close();
Posted by: Kundan.sriv on: 9/26/2011 | Points: 25
Hi Shantanupatel,

Your approach is good.

But as a fresher it is quite difficult that where to start and how to do it.
You have simply write a code block.

For ex. you can see the example on below link that how they have explain step by step for a sharepoint beginner.

http://sharepointcafe.net/articles/event-handler-in-sharepoint.aspx

and

http://sharepointcafe.net/articles/webpartinsharepoint2010.aspx

Sorry to say that but if you are explaining some thing for beginners then you should start with step by step process.

Thanks.

Posted by: Shantanupatel on: 9/26/2011 | Points: 25
Hi Kunda,
Thanks a lot for the feedback!

Yes, what you have scribbled is correct and that would be taken into account in the coming posts.

Thanks
Shantanu

Login to post response

Comment using Facebook(Author doesn't get notification)