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

Suppose You use Visual Studio .NET to develop a Windows-based application. Your application will
display customer order information from a Microsoft SQL Server database. The orders will be
displayed on a Windows Form that includes a DataGrid control named XYZGrid1. XYZGrid1 is
bound to a DataView object. Users will be able to edit order information directly in XYZGrid1.
You must give users the option of displaying only edited customer orders and updated values in
XYZGrid1.
What should you do?
A. Set the RowStateFilter property of the DataView object to
DataViewRowState.ModifiedOriginal.
B. Set the RowStateFilter property of the DataView object to DataViewRowState.ModifiedCurrent.
C. Set the RowFilter property of the DataView object to DataViewRowState.ModifiedOriginal.
D. Set the RowFilter property of the DataView object to DataViewRowState.ModifiedCurrent.

Answer:

C. Set the RowFilter property of the DataView object to DataViewRowState.ModifiedOriginal.

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

Previous QuestionNext Question
Suppose You create a Visual Studio .NET setup project to distribute an application. You add a SQL script
named XYZDB.SQL. You must ensure that the SQL script is executed during the installation
process. What should you do?
A. Add a custom action to your setup project.
Select XYZDB.SQL as the source path.
B. Add a batch file to your setup project to execute XYZDB.SQL.
Add a launch condition to the setup project.
Set the Condition property to the batch file.
C. Create a new Visual Studio .NET project that executes XYZDB.SQL.
Include the new project with your setup project.
Add a custom action that launches the new project during installation.
D. Add a launch condition to your setup project.
Set the Condition property to XYZDB.SQL.
Suppose You develop a Windows-based application XYZ App by using Visual Studio .NET. XYZApp
implements ADO.NET objects to call Microsoft SQL Server stored procedures. Your database
administrator is responsible for coding and maintaining all stored procedures. Periodically, the
administrator modifies the stored procedures.
At run time, your application code must discover any changes in the way that values are passed
to and returned from the stored procedures.
Which ADO.NET object and method should you use?
A. CommandBuilder.RefreshSchema
B. CommandBuilder.DeriveParameters
C. SqlCommand.CreateParameter
D. SqlDataAdapter.GetFillParameters