You create an application by using the Microsoft .NET Framework 3.5 and Microsoft
ADO.NET.The application contains a DataSet object that has a table. The DataSet object is
as shown in the following exhibit.
You need to ensure that the application meets the following requirements without creating another table:
The DataSet can be extended by using the designer.
The application displays all product records.
The product records can be filtered by ProductID.
What should you do?
A.
Modify ProductTableAdapter by using the Fill method that accepts ProductID as an
optional parameter.
B.
Modify ProductTableAdapter by using the GetData method that accepts ProductID as an
optional parameter.
C.
Add another TableAdapter object named ProductTableAdapterByProductID and
configure it to retrieve records by ProductID.
D.
Add another query to ProductTableAdapter by using the ProductID field as a parameter,
and then filter the records by using this parameter.