70-528 NET Framework 2.0-Web-based Client Development Exam Questions

Demo Question 9.

You work as a Microsoft ASP.NET developer at EliteCertify.com. EliteCertify.com uses the Microsoft Visual Studio .NET 2005 as their application development platform. The EliteCertify.com network contains an Oracle database server named EliteCertify -DB01. EliteCertify -DB01 hosts a database named CK_Products that stores product information for EliteCertify.com's e-Commerce Web site. You use a Microsoft Windows XP Professional client computer named EliteCertify -WS528 as your development computer. Internet Information Services (IIS) is installed on EliteCertify -WS528. You are developing a product page named Catalog.aspx for Web application that will be integrated into EliteCertify.com's existing e-Commerce Web site. The Catalog.aspx page must access data from the CK_Products database. You must use a stored procedure named sp_GetAllProducts to display data in a GridView control named _gridView. The stored procedure takes no parameters. What should you do?

A. Add an ObjectDataSource control to the Catalog.aspx page. Set the DataSourceID property of the GridView control to the ID of the ObjectDataSource. Set the SelectCommand property to the stored procedure name "sp_GetAllProducts".
B. Add a SqlDataSource control to the Catalog.aspx page. Set the DataSourceID property of the GridView control to the ID of the SqlDataSource. Set the SelectCommand property to the stored procedure name "sp_GetAllProducts".
C. Add an ObjectDataSource control to the Catalog.aspx page. Set the DataSourceID property of the GridView control to the ID of the ObjectDataSource. Set the SelectMethod property to the stored procedure name "sp_GetAllProducts".
D. Add a SqlDataSource control to the Catalog.aspx page. Set the DataSourceID property of the GridView control to the ID of the SqlDataSource. Set the SelectMehod property to the stored procedure name "sp_GetAllProducts".


Display Answer

Answer: B

Explanation: You can set the focus of a control in the Focus method of the control itself, in the Page.SetFocus method and pass the ID of a control that should receive focus, or in the SetFocus method of the Page instance in the Page_Load event handler.