MCSD.NET - 70-316 Exam Question:
Download Questions PDF

Suppose As a developer at XYZ you develop a new sales analysis application that reuses existing data
access components. One of these components returns a DataSet object that contains the data for
all customer orders for the previous year.
You want your application to display orders for individual product numbers. Users will specify the
appropriate product numbers at run time..
What should you do?
A. Use the DataSet.Reset method.
B. Set the RowFilter property of the DataSet object by using a filter expression.
C. Create a DataView object and set the RowFilter property by using a filter expression.
D. Create a DataView object and set the RowStateFilter property by using a filter expression.

Answer:

C. Create a DataView object and set the RowFilter property by using a filter expression.

Download MCSD.NET - 70-316 Exam Interview Questions And Answers PDF

Previous QuestionNext Question
You plan to develop a customer information application CustomEX that uses a Microsoft SQL
Server database. CustomEX will be used frequently by a large number of users. Your application
code must obtain the fastest possible performance when accessing the database and retrieving
large amounts of data. You must accomplish this goal with the minimum amount of code.
How should you design CustomEX?
A. Use classes in the System.Data.OleDb namespace.
B. Use classes in the System.Data.SqlClient namespace.
C. Use remoting to connect to the SQL Server computer.
D. Use interoperability to include legacy COM-based data access components.
You develop a Windows-based application XYZ. XYZ uses a DataSet object that contains two
DataTable objects. XYZ will display data from two data tables. One table contains customer
information, which must be displayed in a data-bound ListBox control. The other table contains
order information, which must be displayed in a DataGrid control.
You need to modify XYZ to enable the list box functionality.
What should you do?
A. Use the DataSet.Merge method.
B. Define primary keys for the Data Table objects.
C. Create a foreign key constraint on the DataSet object.
D. Add a DataRelation object to the Relations collection of the DataSet object.