Question:
(a) List three advantages of binding data to controls.
(b) The Repeater control uses templates to control formatting. Define the five types of templates supported by the Repeater control.
(c) Distinguish between the following methods as used in ADO.NET:
(i) ExecuteScalar()
(ii) ExecuteReader()
(iii) ExecuteNonQuery().
(d) Write an ASP.NET program that allows you to retrieve data from the Patients database table and to display the same in a DataGrid control, using the DataSet principles.
Database name: hospital.mdb
Table name: tblPatients