• Winforms Databinding

    Snippets below have been condensed from their original sources for brevity. See references for original articles. Dataset usage: Binding DataGridView: References: MSDN, “DataSet Class”, http://msdn.microsoft.com/en-us/library/system.data.dataset.aspx MSDN, “How to: Bind Data to the Windows Forms DataGridView Control”, http://msdn.microsoft.com/en-us/library/fbk67b6z.aspx

  • MSSQL Quick Reference

    Snippets below have been condensed from their original sources for brevity. See references for original articles. Great reference on joins: http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins Show all tables in specific database: (MSSQL equivalent of MySql “show tables”) Insert into: Insert if not exists: Trigger Syntax Structure: Basic If, Then , Else and case: Insert Trigger: Update Trigger: Get and/or…

  • Browser Safe Fonts

    See below for a table of “browser safe fonts” which work well and have been tested with most browsers. This table is courtesy of Ampsoft. Windows fonts / Mac fonts / Font family Normal style Bold style Arial, Arial, Helvetica, sans-serif Arial, Arial, Helvetica, sans-serif Arial Black, Arial Black, Gadget, sans-serif Arial Black, Arial Black,…

  • Amazon Makes $13 million on Living Social Ad

    What am I talking about? Living Social and Groupon are relatively new websites featuring coupons and advertisements which target your local demographic. Some of these coupons are backed by large names, such as Amazon, whereas others may be small businesses, like “Joe’s Pizzeria” down the road. These sites are growing in popularity, even Google recently…

  • OAuth Specs and Protocol

    The OAuth protocol defines a common data structure for communicating between websites. This relatively new format is increasing in popularity and used in many different sites including Facebook and Google. Microsoft has even added support for it in its latest WCF RIA services. (See my article with silverlight links below). Read the full spec at…