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

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

Answer:

B. CommandBuilder.DeriveParameters

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

Previous QuestionNext Question
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.
Suppose You develop a Windows-based application XYZiApp by using Visual Studio .NET. XYZiApp uses
a SqlConnection object for database access.
You typically run XYZiApp on a computer that has limited RAM and hard disk space. After the
code finishes using the SqlConnection object, you must ensure that the connection is closed and
that any resources consumed by the object are released immediately.
What should you do?
A. Call the Finalize method of the SqlConnection object.
B. Call the Dispose method of the SqlConnection object.
C. Set the SqlConnection object equal to Nothing.
D. Set the SqlConnection object equal to