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

The ADO.NET team is working on a building an object called SqlConnectionStringBuilder. The object is intended to assist in building connections string. Pretty basic concept and if you use config files to store your connection strings, you may not take advantage of it (but still could). But if you ar

Being a die hard Yankee [http://www.yankees.com]fan and a baseball fan in general, I cannot wait to see the Yanks take the Red Sox on tonight [http://sports.espn.go.com/mlb/news/story?page=redsoxyankees]in the Bronx. I just hope it does not get rained out. Its just a lot of fun to watch the story un

Quick blog for now … I set up a new ASP.NET project, turn on NT auth, turn off anonymous access, write some ADO.NET code to connect to SQL Server via integrated security and viola! I get this lovely error: <P></P> <FIELDSET><LEGEND>Arg!</LEGEND> <H2>Login failed