Ships from: STERLING HEIGHTS, MI
Usually ships in 1-2 business days
Ships from: Sausalito, CA
Usually ships in 1-2 business days
This book picks up where Beginning ASP.NET: From Novice to Professional left off, focusing on database programming with ASP.NET. As an ASP.NET developer, you probably need to access your databases quickly and efficiently. This book will provide you with the skills to do so, teaching you best practices and methods that will help achieve professional ASP.NET and database solutions.
Beyond the basics of building a Web form and placing a few controls on a page, the most common task required of ASP.NET developers is building a Web site possessing content that is stored in a database. Because general ASP.NET beginner books usually invest so many chapters going through basics, the books don’t cover everything involved.
Beginning ASP.NET 1.1 Databases: From Novice to Professional is a complete, thorough introduction to this particular topic. The authors show how you can connect a Web site to many different data sources not just databases and use the data to dynamically generate 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. Youll learn that you often have several ways to achieve the same task, and you’ll find out how to decide which option is the most appropriate for the task you face.
Of course, this kind of knowledge is only as good as the solutions it helps build. The authors cover the real-world issues youre likely to face, such as design, transactions, error handling, optimization and scalability. We work with SQL Server, Jet, and MySQL databases throughout the book, and we point out the practical differences among these. Finally, we set you on your way at the end with a handy case study that brings together all the things you’ve learned.
| Pt. 1 | Introduction | 1 |
| Ch. 1 | Data sources and the Web | 3 |
| Ch. 2 | Introducing relational databases | 27 |
| Pt. 2 | Core skills | 79 |
| Ch. 3 | Connecting to data sources | 81 |
| Ch. 4 | Commands and SQL queries I | 119 |
| Ch. 5 | Commands and SQL queries II | 155 |
| Ch. 6 | DataReader and DataSet | 183 |
| Ch. 7 | Displaying data on a page | 219 |
| Ch. 8 | Writing data from a page | 285 |
| Ch. 9 | Stored procedures | 327 |
| Ch. 10 | Modifying the database structure | 359 |
| Pt. 3 | The real world | 401 |
| Ch. 11 | Application design and implementation | 403 |
| Ch. 12 | The case study, part I | 431 |
| Ch. 13 | The case study, part II | 469 |
Anonymous
Posted Sat Aug 14 00:00:00 EDT 2004
The book is the functional equivalent of the many out there discussing using J2EE to build a dynamical website that is hooked to SQL databases. Foggon and Maharry show how if you are in the Microsoft .NET world, you can do likewise. They give a quick summary of earlier Microsoft efforts, like COM, Data Access Objects and Remote Data Objects. And how ADO 2.0 replaced the latter 2, and in turn is superceded by ADO.NET. The entire book is a not too subtle encouragement to migrate to ASP.NET and C#. There are solid technical explanations of why it is advantageous to do so. Like the relative ease of hooking to a back end SQL Server database, using high level classes like DataSet to pull stuff from the database, with a minimal knowledge of SQL needed. Then they show how the latest ASP can use this data to make dynamic HTML pages. Much like JSP and Java servlets. There is even a section on designing a database. Raising issues like normalisation and first and second normal forms. Though if this is new to you, then consider consulting a dedicated book on the subject.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Overview
This book picks up where Beginning ASP.NET: From Novice to Professional left off, focusing on database programming with ASP.NET. As an ASP.NET developer, you probably need to access your databases quickly and efficiently. This book will provide you with the skills to do so, teaching you best practices and methods that will help achieve professional ASP.NET and database solutions.
Beyond the basics of building a Web form and placing a few controls on a page, the most common task ...