Philip Conrod - Visual C# and Databases: A Step-By-Step Database Programming Tutorial

Visual C#
And Databases A Computer Programming Tutorial By
Philip Conrod & Lou Tylee
2017 Kidware Software LLC
PO Box 701
Maple Valley, WA 98038 http://www.computerscienceforkids.com http://www.kidwaresoftware.com

Copyright 2017 by Kidware Software LLC. All rights reserved Kidware Software LLC PO Box 701 Maple Valley, Washington 98038 1.425.413.1185 www.kidwaresoftware.com www.computerscienceforkids.com All Rights Reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any means without the written permission of the publisher. Printed in the United States of America ISBN-13: 978-1-937161-66-8 (Electronic) ISBN-13: 978-1-937161-74-3 (Printed) Previous edition published as Visual C# & Databases - 2012 Professional Edition Cover Design by Neil Sauvageau Illustrations by Kevin Brockschmidt This copy of Visual C# and Databases and the associated software is licensed to a single user. Copies of the course are not to be distributed or provided to any other user. Multiple copy licenses are available for educational institutions.

Please contact Kidware Software for school site license information. This guide was developed for the course, Visual C# and Databases, produced by Kidware Software, Maple Valley, Washington. It is not intended to be a complete reference to the Visual Basic language. Please consult the Microsoft website for detailed reference information. This guide refers to several software and hardware products by their trade names. These references are for informational purposes only and all trademarks are the property of their respective companies and owners.

Microsoft, Visual Studio, Small Basic, Visual Basic, Visual J#, and Visual C#, IntelliSense, Word, Excel, MSDN, and Windows are all trademark products of the Microsoft Corporation. Java is a trademark product of the Oracle Corporation. The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted are fictitious. No association with any real company, organization, product, domain name, e-mail address, logo, person, place, or event is intended or should be inferred. This book expresses the authors views and opinions. The information in this book is distributed on an "as is" basis, without and expresses, statutory, or implied warranties.

Neither the author(s) nor Kidware Software LLC shall have any liability to any person or entity with respect to any loss nor damage caused or alleged to be caused directly or indirectly by the information contained in this book.

About The Authors Philip Conrod has authored, co-authored and edited numerous computer programming books for kids, teens and adults. Philip holds a BS in Computer Information Systems and a Master's certificate in the Essentials of Business Development from Regis University. He also holds a Certificate in Programming for Business from Warren-Tech. Philip has been programming computers since 1977. He has held various Information Technology leadership roles in companies like Command Plus, BibleBytes Software, Sundstrand Aerospace, Safeco Insurance Companies, FamilyLife, Kenworth Truck Company, PACCAR and Darigold.

In his spare time, Philip serves as the President & Publisher of Kidware Software, LLC. He is the proud father of three techie daughters and he and his beautiful family live in Maple Valley, Washington. Lou Tylee holds BS and MS degrees in Mechanical Engineering and a PhD in Electrical Engineering. Lou has been programming computers since 1969 when he took his first Fortran course in college. He has written software to control suspensions for high speed ground vehicles, monitor nuclear power plants, lower noise levels in commercial jetliners, compute takeoff speeds for jetliners, locate and identify air and ground traffic and to let kids count bunnies, learn how to spell and do math problems. He has written several online texts teaching Visual Basic, Visual C# and Java to thousands of people.

He taught a beginning Visual Basic course for over 15 years at a major university. Currently, Lou works as an engineer at a major Seattle aerospace firm. He is the proud father of five children and proud husband of his special wife. Lou and his family live in Seattle, Washington.

Acknowledgements I want to thank my three wonderful daughters - Stephanie, Jessica and Chloe, who helped with various aspects of the book publishing process including software testing, book editing, creative design and many other more tedious tasks like finding errors and typos. I could not have accomplished this without all your hard work, love and support.

I want to also thank my best friend Jesus, who has always been there by my side giving me wisdom and guidance. Without you, this book would have never been printed or published. I also want to thank my multi-talented co-author, Lou Tylee, for doing all the real hard work necessary to develop, test, debug, and keep current all the beginner-friendly applications, games and base tutorial text found in this book. Lou has tirelessly poured his heart and soul into so many previous versions of this tutorial and there are so many beginners who have benefited from his work over the years. Lou is by far one of the best application developers and tutorial writers I have ever worked with.

Course Description: Visual C# and Databases is a tutorial that provides a detailed introduction to using Visual C# for accessing and maintaining databases. Course Description: Visual C# and Databases is a tutorial that provides a detailed introduction to using Visual C# for accessing and maintaining databases.

Topics covered include: database structure, database design, Visual C# project building, ADO .NET data objects, data bound controls, proper interface design, structured query language (SQL), and database reports. Visual C# and Databases is presented using a combination of over 850 pages of course notes and actual Visual C# examples. No previous experience working with databases is presumed. It is assumed, however, that users of the course are familiar with the Visual C# environment and the steps involved in building a Visual C# application.

Course Prerequisites: To grasp the concepts presented in Visual C# and Databases , you should possess a working knowledge of Microsoft Windows. No previous experience working with databases is presumed.

It is assumed, however, that users of the course are familiar with the Visual C# environment and the steps involved in building a Visual C# application (such background can be gained from our Learn Visual C# course). You will also need the ability to view and print documents saved in Microsoft Word. Finally, and most obvious, you need to have Microsoft Visual Studio Community Edition. This is a separate product that can be downloaded for free from Micrososofts website: https://www.visualstudio.com/free-developer-offers/

How To Take the Course: Visual C# and Databases is a self-paced course. Each chapter will require a different amount of time. The suggested approach is to decide how much time you can spend each week working through the notes.

Print out the notes one chapter at a time. Then, work through the notes at your own pace. Try to do each example as it is encountered in the notes. Work through the projects. If you need any help, all completed projects are included in the Code folder.

Software Requirements Visual Studio 2017 will install and run on the following operating systems: Windows 10 version 1507 or higher: Home, Professional, Education, and Enterprise (LTSB is not supported) Windows Server 2016: Standard and Datacenter Windows 8.1 (with Update 2919355): Basic, Professional, and Enterprise Windows Server 2012 R2 (with Update 2919355): Essentials, Standard, Datacenter Windows 7 SP1 (with latest Windows Updates): Home Premium, Professional, Enterprise, Ultimate Next page