Visual C# .Net and Database: Practical Tutorials (Paperback)

This book aims to develop a database-driven desktop application that readers can develop for their own purposes to implement database-oriented digital image processing, machine learning, and image retrieval applications. In Tutorial 1, you will perform the steps necessary to add 6 tables using Visual C# into the ImageProc database. This table has sixteen fields: OfficerID, FirstName, LastName, RegNumber, BirthDate, AppData, Gender, Status, Rank, Address, Mobile, Phone, Email, Description, PhotoFile, and FingerFile). You need seventeen label controls, two picture boxes, ten text boxes, two comboxes, one check box, two date-time pickers, one open file dialog, and one print preview dialog. You also need four buttons for navigation, eight buttons for utilities, one button for searching an officer's name, one button to upload an officer's photo, and one button to upload an officer's fingerprint. In Tutorial 2, you will perform the steps necessary to create and implement a police station form. In this tutorial, you will build such a form for the PoliceStation table. This table has seven fields: PSID, OfficerID, PSName, City, Address, Phone, and Description. You need eight label controls, six text boxes, two comboxes, one check box, and one print preview dialog. You also need four buttons for navigation, eight buttons for utilities, and one button for searching the officer's name. Place these controls on the form. In Tutorial 3, you will build such a form for the Accused table. This table has thirteen fields: AccusedID, FullName, MotherName, CrimeCase, BirthDate, Gender, Address, Mobile, Phone, Email, Description, PhotoFile, and FingerFile). The form will also have the capability of navigating from one record to another. You need fourteen label controls, two picture boxes, nine text boxes, two comboxes, one date time picker, one open file dialog, and one print preview dialog. You also need four buttons for navigation, eight buttons for utilities, one button for searching the accused's name, one button to upload the accused's photo, and one button to upload the accused's fingerprint. In Tutorial 4, you will build such a form for the Witness table. This table has thirteen fields: WitnessID, FullName, MotherName, CrimeCase, BirthDate, Gender, Address, Mobile, Phone, Email, Description, PhotoFile, and FingerFile). You need fourteen label controls, two picture boxes, nine text boxes, two comboxes, one date time picker, one open file dialog, and one print preview dialog. You also need four buttons for navigation, eight buttons for utilities, one button for searching a witness's name, one button to upload a witness's photo, and one button to upload a witness's fingerprint. In Tutorial 5, you will build such a form for the Victim table. This table has thirteen fields: VictimID, FullName, MotherName, CrimeCase, BirthDate, Gender, Address, Mobile, Phone, Email, Description, PhotoFile, and FingerFile). You need fourteen label controls, two picture boxes, nine text boxes, two comboxes, one date time picker, one open file dialog, and one print preview dialog. You also need four buttons for navigation, eight buttons for utilities, one button for searching the victim's name, one button to upload the victim's photo, and one button to upload the victim's fingerprint. In Tutorial 6, you will build such a form for the CrimeReg table. This table has fourteen fields: CRID, CRNumber, PSID, VictimID, AccusedID, DateReport, DateCrime, Arrested, CaseStatus, Description, Feature1, Feature2, Feature3, and Feature4. You need thirty-two label controls, seven text boxes, ten comboxes, one check box, two date-time pickers, six picture boxes, and one print preview dialog. You then need four buttons for navigation, eight buttons for utilities, and one button for searching crime register numbers. You also need a button to save every feature.