Creating and Obtaining Data from a Database
This chapter is to be read with video lessons 8 and 9, “Obtaining Data from a SQL Server 2005 Express Edition Database” and “Databinding Data to User Interface Controls”, respectively.
Databases are files or systems that organize data for easy storage and retrieval. Working with Databases will probably become the single most important use for your coding skills if you plan to work for a typical IT department as a programmer.
There are many different types of databases from different vendors. Each database shares a common structure and terminology. This is known as a Relational Database. You will need to use a sub-set of the .NET Framework called ADO.NET, which stands for ActiveX Data Objects. Don’t worry … there’s nothing about the history of ADO that is pertinent right now. What IS important is that it contains a series of classes that allow you to interact with all types of different databases very easily.
Most of the applications I write involve accessing information in a database, whether I just select records to display on screen, or insert, update or delete records.
A database is a file that has data structured in such a way that the data is organized and easily searched for, or modified. A database can be created by Microsoft Access for simple applications … or better yet, you can take advantage of Sql Server 2005 Express Edition which is installed with Visual C# 2005 Express Edition and Visual Basic 2005 Express Edition and is integrated directly into the IDE via the Database Explorer window. Or in larger companies or for high-volume web site, you may want to use a Database Management System like SQL Server 2000 or 20005 or Oracle 9i Database. These larger systems don't allow you to access the data file yourself, but have a program (called a Database Server) that accepts your request, performs the request and delivers the results (if any). The benefit is that it can accommodate more computers that try to access
Supplemental Readings for the Express Edition Videos Copyright © 2005 LearnVisualStudio.NET