Working with Databases
Databases are the workhorses that power almost every commercial Web site. They can also become a bottleneck on Web-based applications unless the databases are well designed and the programs that use them are carefully written. It’s not our purpose to address database design issues in this book. Our focus is how best to write the code for Web Applications that use databases and how to approach the design of data-driven Web pages. If you’re completely new to ADO.NET, then we strongly recommend you temporarily part company from this chapter, and read Appendix D. This appendix explains the key features of ADO.NET and presents “starter” code that shows and explains some of the basic ADO.NET tasks. It also explains some important concepts, such as the difference between connected and disconnected data manipulation. If you already know your DataReaders from your DataTables, then read on. We’ll be working exclusively with the HiFlyers dat base, an overview of which was presented in the Introduction. It’s not a complex database, but it helps if you’re familiar with its tables and relationships.
KeywordsData Table Visual Studio Physical Database Session State DataSet Object
Unable to display preview. Download preview PDF.