Ch10 - Chapter 10 Database Management 10.1 An Introduction...

Info icon This preview shows pages 1–25. Sign up to view the full content.

View Full Document Right Arrow Icon
1 Chapter 10 – Database Management 10.1 An Introduction to Databases 10.2 Editing and Designing Databases
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
2 10.1 An Introduction to Databases Accessing a Database Table Binding to Additional Tables Querying a Table with LINQ Primary and Foreign Keys The Join of Two Tables
Image of page 2
3 Sample Table – Cities Table
Image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
4 Sample Table – Countries Table
Image of page 4
5 Database Terminology A table is a rectangular array of data. Each column of the table, called a field , contains the same type of information. Each row, called a record , contains all the information about one entry in the table.
Image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
6 Database Management Software (DBMS) Used to create databases Databases contain one or more related tables Examples of DBMS are Access, Oracle, and SQL Server. The databases used in this chapter are found in the folder Programs\Ch10\Databases. They were created with Access and have the extension accdb .
Image of page 6
Megacities.accdb Contains the two tables Cities and Countries shown earlier. This database will be used extensively in the examples for this chapter. Several steps are required to bind to a table of the database. (See the next sixteen slides.) 7
Image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Binding to the Cities Table Add a BindingSource control to the form. (The control is in the Data and All Windows Forms group of the Toolbox. It appears in the form’s component tray with the name BindingSource1.) 8
Image of page 8
DataSource Property of BindingSource1 9 click here
Image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Choose Data Source Type 10 click on Next button select
Image of page 10
Choose Database Model 11 click on Next button select
Image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Choose Data Connection 12 click on New Connection button
Image of page 12
Add Connection Dialog Box 13 click on Change button
Image of page 13

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Change Data Source Box 14 select click on OK button
Image of page 14
15 Add Connection Dialog Box click on Browse button
Image of page 15

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Select Database File 16 double-click on Megacities.accdb
Image of page 16
Add Connection Dialog Box 17 click on OK button
Image of page 17

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Choose Data Connection 18 click on Next button
Image of page 18
19 click on Yes button
Image of page 19

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Save to File 20 check this box click on Next button
Image of page 20
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern