Purpose:

This article describes basic knowledge required to get one started with SharePoint programming model. This article allows SharePoint developers to take their experience to next level for developing cool webparts.

All you need to know is how to get site reference. You can get that with following chunk of code

SPSite mySite = new SPSite(URL); // Where URL is sharePoint site URL
SPWeb  myWeb = mySite.OpenWeb()
{
  // Do stuff here
}

Now, we got the reference to site and would like to see all Lists with-in site... We can achive this with little bit extension to code mentioned above.

SPSite mySite = new SPSite(URL); // Where URL is sharePoint site URL
SPWeb  myWeb = mySite.OpenWeb()
{
  // Do stuff here
  string output ="";
  foreach(SPList list in myWeb.Lists)
  {
    output += "<a href='" +list.DefaultView.Url.ToString() + "'>"+ list.Title + "</a> has "+list.Items.Count+" Items<br>";
  }
}

Code above will scan through all lists and create html for each list items and it's record count. Now if you know which list you want to work with then you do not need to iterate full list. you can do following to access list by name.

  
SPSite mySite = new SPSite(URL); // Where URL is sharePoint site URL
SPWeb  myWeb = mySite.OpenWeb()
{
  // Do stuff here
  SPList myList= myWeb.Lists["myListName"];  // Where myListName is sharePoint List name under URL

  foreach (SPListItem myRec in myList)
  {
     string mycolumn = myRec["ColumnName"].ToString(); // Get data from List Item record

  }
}

That's It... Now you know how to access list and its values from SharePoint Site. You can now build some custom webparts reading your LOB data and fusioning it with SharePoint Content.

Good Luck!!

MyProfile: https://mcp.support.microsoft.com/profile/PATEL1