You create a personalized home page. You want to enable users to choose from a selection of daily headlines from different news providers. You create a series of custom user controls. Each control points to a different news provider. You need to add these controls to the personalized home page. What should you do?

You are an enterprise application developer. You create a component that executes queries against Microsoft SQL Server. The queries are executed inside the scope of a transaction. The transaction is started by using the SqlTransaction object. The code executes the query inside a Try block. You need to create an exception handling mechanism that rolls back the transaction under any error condition and notifies the caller of the error. What should you do?

You are creating a Windows Forms application. The application executes a stored procedure that takes several seconds to complete. The stored procedure is invoked to populate a SqlDataReader object. You need to ensure that the application remains responsive to the user while the stored procedure is executing. What should you do?

You are an enterprise application developer. You are creating an application that will deploy an on-demand training program. The training is a combination of documents and video files that the user can ac cess from an internal server on the LAN. Users might access this application through their home computers when they are connected to the corporate network through a virtual private network (VPN). You need to design the video portion for the on-demand training program. You also need to ensure that users can view the videos without making modifications to their computer configuration. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You are creating a Windows Forms application that includes the database helper methods UpdateOrder and UpdateAccount. Each method wraps code that connects to a Microsoft SQL Server 2005 database, executes a Transact-SQL statement, and then disconnects from the database. You must ensure that changes to the database that result from the UpdateAccount method are committed only if the UpdateOrder method succeeds. You need to execute the UpdateAccount method and the UpdateOrder method. Which code segment should you use?

You are an enterprise application developer. You are creating a component that will be deployed as part of a class library. The component must meet the following specifications:

* The interface of the component must be accessible to components outside the hosting assembly.
* The interface of the component must be interoperable with components written in any other .NET Framework languages.
* The implementation of the component cannot be expanded upon by a derived class.

You need to design the interface of the component.
Which three tasks should you perform? (Each correct answer presents part of the solution. Choose three.)

You are creating a Windows Forms application. Initialization code loads a DataSet object named ds that includes a table named Users. The Users table includes a column named IsManager. You need to bind the IsManager column to the Checked property of a check box named chkIsManager. Which code segment should you use?

You are an enterprise application developer. You are creating a component that will be used in an order fulfillment process.
The component performs the following two tasks:

* Modifies data in a local Microsoft SQL Server database
* Adds data to a remote SQL Server database

The application that uses the component is multithreaded. Each application thread that uses the component creates its own instances of the component classes. You need to ensure that the component either performs both tasks successfully or performs neither task. What should you do?

A Windows Forms application contains the following code segment.
Dim SQL As String = “SELECT OrderID, ProductID, UnitPrice, Quantity FROM [Order Details]” Dim da As New SqlDataAdapter(SQL, connStr)
Dim dt As New DataTable()
da.Fill(dt)

You need to add a new column to the data table named ItemSubtotal. The ItemSubtotal column must contain the value of the UnitPrice column multiplied by the value of the Quantity column. Which code segment should you use?