View Recording
System & Device Check
About the Class
Almost all application are not useful unless they help us store and retrieve data from the database. If we own a small books store, we need a way to store data for our customers, books and orders. If we are a small oil change shop, still we need a way to store data about inventory, customers, employees, etc. I would like to show you how you can create an application and use it to store information in your database.
Let''s learn how to use ADO .NET for accessing databases. The Data in a Database Is Organized in Tables, Rows, and Columns.
Database: a collection of tables which hold related data
Table: data organized in rows and columns
Field: an individual piece of information pertaining to an item
Record: a complete set of data about a single item (a row in a table)
In this lesson you develop an application that performs basic operations on a database, such as adding, changing, and deleting records, and searching for data.
We will be using MS Access database for our class which will have Books table, Order table, and Customer table. We will learn how to display order information for orders placed in our database.
Language of instruction:
Keywords: structured query language(sql), ms access, visual basic .net, query, database management system (dbms), asp.net, customer, books, orders
