This book picks up where Beginning ASP.NET 2.0: From Novice to Professional leaves off, focusing on database programming with ASP.NET. Since ASP.NET developers need to access databases quickly and efficiently, this book teaches the best practices and methods to help developers achieve professional ASP.NET and database solutions. Beginning ASP.NET 2.0 Databases: From Novice to Professional is a comprehensive introduction on how you can connect a Web site to many different data sources — not just databases — and use the data to create dynamic page content. They also show how to build a relational database, use SQL to communicate with it, and understand how they differ from each other. You’ll also learn about the new features of ADO.NET and ASP.NET in .NET 2.0 The authors cover mission-critical issues, such as design, transactions, error handling, optimization, and scalability. They write about SQL Server, Jet, and MySQL databases, highlighting their differences. Finally, they concluded with a handy case study that brings together all of the things you’ve learned.
Author(s): Damien Foggon
Edition: 2nd ed.
Year: 2006
Language: English
Pages: 656
ERRATA......Page 1
Contents......Page 6
CHAPTER 1 Data Sources and the Web......Page 30
CHAPTER 2 Introducing Relational Databases......Page 56
CHAPTER 3 Displaying Data on a Page......Page 106
CHAPTER 4 Database Access in Code......Page 144
CHAPTER 5 DataReader and DataSet......Page 184
CHAPTER 6 Inline and List Binding......Page 218
CHAPTER 7 Table Binding......Page 276
CHAPTER 8 Writing to the Database......Page 326
CHAPTER 9 The GridView Family......Page 396
CHAPTER 10 Stored Procedures......Page 444
CHAPTER 11 Modifying the Database Structure......Page 488
CHAPTER 12 Useful Techniques......Page 526
CHAPTER 13 Application Design and Implementation......Page 576
APPENDIX A Installation Instructions......Page 600
APPENDIX B SQL Data Types......Page 608
APPENDIX C SQL Primer......Page 620
APPENDIX D Sample Database Tables......Page 626
INDEX......Page 636
