.NET

Visual Studio: Tab Stop Configuration

Visual Studio 2005 (and 2008 EDIT: and 2010) has a great tool for fixing the tab stop values on any form, and it's point and click! With your form open, use the 'Layout' toolbar and click the 'Tab Order' button. All the controls on the form now have a numbered…

.NET, OleDB and Excel

OleDB is a very useful API in .NET, especially when manipulating the data in an Excel spreadsheet. In fact, it can open an Excel spreadsheet and query the data using regular SQL statements. using System.Data.OleDb; OleDbConnection conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=…