(We'll cover all of these operations in the course of this tutorial set.)ĭatabase work can be enormously complex and can require specialized knowledge. You'll also often gather information from users and add it to a database, or you'll modify records that are already in the database. Much of the work you do in web applications consists of reading information out of the database and displaying it on a page. In the example, the ID column is the primary key for the address book shown in the previous example. This value is known as the table's primary key, and you use it to identify each row in the table. (Rows are sometimes referred to as records, and columns are sometimes referred to as fields.)įor most database tables, the table has to have a column that contains a unique value, like a customer number, account number, and so on. For each entry in the address book (that is, for each person) you have several pieces of information such as first name, last name, address, email address, and phone number. Structurally, a database table is like a spreadsheet. If you have database experience, you can skip this short section.Ī database contains one or more tables that contain information - for example, tables for customers, orders, and vendors, or for students, teachers, classes, and grades. This tutorial will provide only the briefest introduction to databases. When you're done with this tutorial, you'll be able to view a movie listing that looks like this page:īut to begin, you have to create a database. The app is a simple movie application that lets you view, add, change, and delete information about movies. In this tutorial, you'll begin creating the actual web application that you'll use for the rest of the series. cshtml files), to the basics of Razor syntax, and to helpers. In the previous tutorial, you were introduced to ASP.NET Web Pages (. How to customize the WebGrid helper to change the data display and to add paging and sorting.How to run SQL commands in ASP.NET Web Pages.How to display data from the database on a page.How to use WebMatrix tools to add data to a database.How to use WebMatrix tools to create a database and database tables.It assumes you have completed the series through Introduction to ASP.NET Web Pages Programming. This tutorial shows you how to create a database in WebMatrix and how to display database data in a page when you use ASP.NET Web Pages (Razor).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |