SharePoint has a little known web control called SPGridView. This control can give you a SharePoint list-like view of data from any data source you can bind to (from a database or other sources). It also has features to sort, filter and group the data in much the same way users can with SharePoint lists...

Sometimes when writing custom code for SharePoint, you want to open the list to which another list field is referring (when it uses a lookup field). I had to do this to put the lookup field values in a custom menu item. Other times, you just want the SP List Item that another list item is referring to...

There are many applications that store binary data in blob or varbinary fields of a database, including pictures, Office documents, PDFs and other types of documents. Recently, a customer had the need to display, in SharePoint, an image stored in an Oracle database. They were already indexing and displaying...