Question:

(a) The ObjectDataSource control is an alternative design approach to using AccessDataSource or SqlDataSource controls. Explain and illustrate how an ObjectDataSource control can be used to create a 3-layer design application.

(b) Concurrent access to data from a database is a normal part of application program usage. Discuss three approaches to concurrency control.

(c) Write an ASP.NET program that allows you to create and populate a CheckBoxList control by accessing the Title field from the Movies database table. You should also consider the following rules:

(i) Checkboxes will be displayed in two columns

(ii) The associated values of the checkboxes will be the Primary key field from the Movies table which is Movie_ID

(iii) the program must also allow you to select the different Titles and display them in a label control

(iv) you will use an SqlDataSource control and assume that the connection string is established in a Web.Config file.