How to Use CAML Query to get Data from SharePoint 2007 List
I was enjoying my summer with some CAML queries – All I wanted was to get some data from a simple Products List in SharePoint 2007. The list was pretty simple with 2 colomns "Product" and "Cost". I used U2U to create a pretty descent CAML query. I created a simple website in VS2008 to test it !!! It all worked fantastically!!!
Here is my Quick Dirty code –
public partial class _Default : System.Web.UI.Page
protected void Page_Load(object sender, EventArgs e)
SPList mylist=new SPSite ("http://sharepointlogics").OpenWeb ().Lists ["Products"];
SPQuery query=new SPQuery ();
query.Query = "
SPListItemCollection items=mylist.GetItems (query);
foreach (SPListItem proditem in items )
So what it does is, it opens a site called sharepointlogics and then it finds a list called "Products"from the list and then get the item names and Cost out of the list and using a simple Response.Write writes it to a page.
So all you need to do is fire up your Visual Studio, create a simple SharePoint site and a list in the site called "Products" and then copy paste the code on a C# project and run it.
Thats all!!!! it will start fetching values from your sharepoint site and will display you.....
Just a simple starter..........
Hope you would enjoy it !!!!