X hits on this document

PDF document

“Beginning Visual C# 2005 Express Edition Video Series” - page 64 / 73

162 views

0 shares

0 downloads

0 comments

64 / 73

Creating and Obtaining Data from a Database

Introduction

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.

Understanding Databases

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



Document info
Document views162
Page views162
Page last viewedSun Dec 04 15:24:53 UTC 2016
Pages73
Paragraphs821
Words15988

Comments