You use Microsoft .NET Framework 4 to develop an application that connects to a Microsoft SQL
Server 2008 database. You add the following table to the database.
CREATE TABLE Orders(
ID numeric(18, 0) NOT NULL,
OrderName varchar(50) NULL,
OrderTime time(7) NULL,
OrderDate date NULL)
You write the following code to retrieve data from the OrderTime column. (Line numbers are
included for reference only.)
01 SqlConnection conn = new SqlConnection (…) ;
02 conn.Open();
03 SqlCommand cmd = new SqlCommand(
“SELECT ID, OrderTime FROM Orders”, conn);
04 SqlDataReader rdr = cmd.ExecuteReader(); 05
06 while(rdr.Read())
07 {08
09 }
You need to retrieve the OrderTime data from the database.
Which code segment should you insert at line 08?
A.
TimeSpan time = (TimeSpan)rdr[1];
B.
Timer time = (Timer)rdr[1];
C.
string time = (string)rdr[1);
D.
DateTime time = (DateTime)rdr[1];
Explanation:
Pay attention to the fact that it goes about Microsoft SQL Server 2008 in the question.
Types date and time are not supported in Microsoft SQL Server Express.
time (Transact SQL)
(http://msdn.microsoft.com/en-us/library/bb677243.aspx)
Using date and time data
(http://msdn.microsoft.com/en-us/library/ms180878.aspx)
date and time functions
(http://msdn.microsoft.com/en-us/library/ms186724.aspx)
SQL Server Data Type Mappings (ADO.NET)
(http://msdn.microsoft.com/en-us/library/cc716729.aspx)