Get SharePoint list items programmatically

http://www.sharepointace.com/Blog/post/2007/12/Another-way-to-retrieve-SharePoint-List-Data---Use-built-in-functionality!.aspx

http://weblogs.asp.net/gunnarpeipman/archive/2008/09/27/sharepoint-for-developers-3-2-hands-on-getting-list-items.aspx

http://aidangarnish.net/blog/post/2007/08/Using-SharePoint-web-services-to-get-list-items.aspx

http://tomblog.insomniacminds.com/2008/01/28/sharepoint-internals-splistgetitems/