A few days ago Raymond Lewallen blogged about refactoring [https://www.johnpapa.net/blogs/raymond.lewallen/archive/2005/04/26/62457.aspx] some VB.NET code using interfaces, and abstract classes. I followed up with a C# example of the same code in a blog [https://www.johnpapa.net/blogs/john.papa/arch

Pablo Castro, Microsoft's Program Manager of the ADO.NET Team, has a good post last week [http://blogs.msdn.com/dataaccess/archive/2005/05/19/420065.aspx] that helps clarify how bath updates are intended to work in ADO.NET 2. This is a common discussion that I am drawn into since the DataAdapter

There are several ways to convert and cast values in .NET. For example, DirectCast versus System.Convert and if you are a VB.NET'er, you have the CInt, CBool, Cxxx functions. It is along these lines that I offer this quiz: What are the differences between the following ways to cast an object?

Over the past few days I've had a few questions regarding a situation where there is a list of parent rows (let's say Orders) loaded into a dropdown list and a list of child rows (let's say Order Details) loaded into a grid. The idea being that when the user selects the Order from the dr

I ran some tests using ADO.NET to measure the time it takes to retrieve a single value from a database. All of my tests had the following attributes: * Each test gets the CompanyName for the specified CustomerID (in Northwind) * The same connection string, using integrated security * Stored pr