-
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,…
-
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…
