Blogs from Wise Owl on ADO.NET and data in ASP.NET webforms

Review of VB.NET Data Storage Structures

Posted by Andy Brown on 24 August 2011

There are a bewildering array (excuse the pun) of data storage structures available to you in Visual Basic. Choose from arrays, ArrayLists, SortedLists, Dictionaries, HashTables, Lists and DataTables, among others. This blog gives an example of each type of structure, and benchmarks them to show which perform best and worst.

Using SQL UNION queries to populate the first Item in a list type control

Posted by David Wakefield on 31 May 2011

Adding a first or default item to a list control which gets its data from a table can be tricky. This blog gives an elegant solution using UNION queries, which works equally well for ASP.NET dropdown controls, Windows Forms dropdowns or Access combo boxes.