While the program compiles correctly, I still recieve an error concerning "Object cannot be cast from DbNull to other types".
The SQL 2000 database column "Day" is set to Integer.
I would like to see VS C# 2005 allow this: int intDay = dr["Day"].ToInt16();
However, this is what I have to work with?
foreach (DataRow dr in dataset1.Tables["Sales"].Rows)
intDay = Convert.ToInt16(dr["Day"]);