You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The
application connects to a Microsoft SQL Server database. The application uses a DataTable named
OrderDetailTable that has the following columns:
• ID
• OrderID
• ProductID
• Quantity
• LineTotal
Some records contain a null value in the LineTotal field and 0 in the Quantity field. You write the
following code segment. (Line numbers are included for reference only.)
01DataColumn column = new DataColumn(“UnitPrice”, typeof(double));
02
03OrderDetailTable.Columns.Add(column);
You need to add a calculated DataColumn named UnitPrice to the OrderDetailTable object. You also
need to ensure that UnitPrice is set to 0 when it cannot be calculated. Which code segment should
you insert at line 02?
A.
column.Expression = “LineTotal/Quantity”;
B.
column.Expression = “LineTotal/ISNULL(Quantity, 1)”;
C.
column.Expression = “if(Quantity > 0, LineTotal/Quantity, 0)”;
D.
column.Expression = “iif(Quantity > 0, LineTotal/Quantity, 0)”;
Explanation:
IIF ( boolean_expression, true_value, false_value )