What you will learn in this chapter:
- How to install Microsoft SQL Server Express
- Using SQL Server Express Manager
- Viewing and managing data in Visual Studio SQL Server Explorer
- Working with various ASP.NET Web Forms data controls
- Managing data in ASP.NET MVC applications
- Handling sorting and pagination in a web application
Code Downloads for this Chapter:
The wrox.com code downloads for this chapter are found at www.wrox.com/go/beginningaspnetforvisualstudio on the Download Code tab. The code is in the chapter 09 download and individually named according to the names throughout the chapter.
There are very few websites that need the dynamic capabilities provided by ASP.NET that don't also need a way to store data either about the visit or about actions taken during the visit. This data could be as simple as persisting the pages that were clicked by visitors as they went through the site, to as complex as a multi-million-dollar order for thousands of various widgets.
There are various ways that you can persist this data.
- You can store it on the local file system as a specially delimited file.
- Another, and the most common, way to store information is in a database system. A database system is an application whose primary reason for existence is to manage the creation, editing, deletion, and fetching of data. There are many different types of database systems, from very simple to extremely complex. This chapter introduces the free version ...