DataBase Resources

This page is designed to support database programming lessons for Access and SQL. These are appropriate for CS106, CS205, & CS206 students. While the examples are in VB, you  C# students should be able to translate the projects without any major difficulty.

Return to Main Menu 

Access Downloads:

• My customers-03.mdb

• MS Access and ADO

• ADO Model

• How to create an Access DB Series (Kessler)

• How to display images from DB (Access 03, 07, GridView, & Details View!)

• Creating a new SQL query document.

• Access & ADO videos Using Wizards
  • 1-Creating Datasources with the grid.
  • 2-Customizing Mr. Grid
  • 3-Searching Records (exact match on Last Name)
  • 4-Searching records by a pattern
  • 5-Status Bar Messages
  • 6-Confirm Delete
  • Get the completed project I used for these videos
  • 7-Using the ReportViewer Control
    • Introduction
    • Creating the report
    • Get the project here

SQL Downloads:

• Kessler's SQL DB Videos

• SQL Home page

• SQL Management Studio Express 2005

• Managing SQL with management studio (pdf) (Eric Brown

• SQL Management Studio Express 2008

• Get Northwind & Pubs Databases

• AdventureWorks Sample Databases

• Customers-05 database

Resources:

• FIX VS2008 & SQL 2005
• ADO Primer/examples
• SQL Server Books On Line (Excellent)
• SQL Language tutorial
• SQL Tutorial (W3 schools)
• SQL Data types
• DataBinding Model
• MSDN SQL database video series.
• MSDN VB How to: Database Video Series
  
• On-Line Training
• Code Helper
• Object-Oriented Programming
• Overview of VS Products
• Visual Basic Power Pack
• Working with SQL User Instances & VStudio
• Working with SSMSE
• DataGridView Secrets