PrepAway - Latest Free Exam Questions & Answers

Which code segment should you insert at line 05 to ensure that the Order and the OrderDetail tables are popula

You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.

The application contains a DataSet object named OrderDS that has the Order and OrderDetail tables as shown in the following exhibit.

You write the following code segment. (Line numbers are included for reference only.)

01 private void GetOrders(SqlDataConnection cn) {
02 SqlCommand cmd = cn.CreateCommand();
03 cmd.CommandText = “Select * from [Order]; Select * from [OrderDetail];”;
04 SqlDataAdapter da = new SqlDataAdapter(cmd);
05
06 }

You need to ensure that the Order and the OrderDetail tables are populated.

Which code segment should you insert at line 05?

PrepAway - Latest Free Exam Questions & Answers

A.
da.Fill(OrderDS);

B.
da.Fill(OrderDS.Order);
da.Fill(OrderDS.OrderDetail);

C.
da.TableMappings.AddRange(new DataTableMapping[] { new DataTableMapping(“Table”, “Order”), new DataTableMapping(“Table1”, “OrderDetail”)});
da.Fill(OrderDS);

D.
DataTableMapping mapOrder = new DataTableMapping();
mapOrder.DataSetTable = “Order”;
DataTableMapping mapOrderDetail = new DataTableMapping();
mapOrder.DataSetTable = “OrderDetail”;
da.TableMappings.AddRange(new DataTableMapping[] { mapOrder, mapOrderDetail });
Da.Fill(OrderDS);


Leave a Reply