Microsoft Visual C
Customising DataGridViews exercise
Harder than average exercise

This Microsoft Visual C# CUSTOMISING DATAGRIDVIEWS exercise is provided to allow potential course delegates to assess their suitability for the Wise Owl VISUAL C# 2005 WINDOWS FORMS course only, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Exercise: DataGridViews - the full monty

A full answer to this exercise is provided as part of the training course!

1)	Create a new Access database called Films (or use SQL Server if you prefer), and within it create 3 tables: A table called Category, to hold fields CategoryId and CategoryName A table called Certificate, to hold fields CertificateId and CertificateName A table called Film, to hold fields FilmId, FilmName, CategoryId and CertificateId
2)	Create appropriate primary keys and relationships, and enter a few film categories (such as Musical), certificates (such as PG) and films (such as The Matrix - the best film ever made?).
3)	Create a datasource, then create a new form containing a combobox and datagridview to look like this:
	When you choose a category or certificate at the top of the form, you should make sure that your datagridview shows different records satisfying the criteria entered
4)	Create another form showing a single film at a time:
	When you save your changes, the previous form should reappear, with any changes you made included
5)	If you haven't already done so, add the necessary code so that: when you choose a film category or certificate on the first form, the list automatically updates when you double-click on a film in the list (or click on the Edit button) the film automatically appears in the separate single-record form when you make any changes they are automatically written to the underlying database
6)	If you've got any spare time, you could always add menus, toolbars and short-cut keys allowing a user to create a new record, delete a film or save all changes made ...

Thank you for showing an interest in this Visual C# 2005 Windows Forms training course! As mentioned above, full answers to this and other exercises are provided on the course. On all Wise Owl scheduled courses delegates can take away these model answers (together with their own efforts!) on a free USB stick.

Return to the list of exercises for this topic