Maharry / Foggon Beginning ASP.NET 1.1 Databases

From Novice to Professional
1. Auflage 2008
ISBN: 978-1-4302-0742-9
Verlag: APRESS
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 632 Seiten, Web PDF

Reihe: Professional and Applied Computing

This book picks up where 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.

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.

Zielgruppe

Popular/general

Autoren/Hrsg.

Maharry, Dan

Foggon, Damien

Inhaltsverzeichnis

One Introductions.- 1 Data Sources and the Web.- 2 Introducing Relational Databases.- Two Core Skills.- 3 Connecting to Data Sources.- 4 Commands and SQL Queries I.- 5 Commands and SQL Queries II.- 6 DataReader and DataSet.- 7 Displaying Data on a Page.- 8 Writing Data from a Page.- 9 Stored Procedures.- 10 Modifying the Database Structure.- Three The Real World.- 11 Application Design and Implementation.- 12 The Case Study, Part I.- 13 The Case Study, Part II.- Four Appendixes.- Appendix A Installation.- .NET 1.1.- .NET ODBC Data Provider.- Web Matrix.- MSDE.- SQL Web Data Administrator.- MySQL.- MySQL Control Center.- MySQL Administrator.- MySQL ODBC Connector.- Appendix B SQL Primer.- SELECT.- INSERT.- DELETE.- UPDATE.- CREATE DATABASE.- CREATE TABLE.- DROP DATABASE.- DROP TABLE.- ALTER DATABASE.- ALTER TABLE.- SQL Data Types.- Text Types.- Numeric Types.- Date and Time Types.- Binary Types.- Miscellaneous Types.- Appendix C Sample Database Tables.- The Publisher Table.- The Author Table.- The Book Table.- The WhoWroteWhat Table.- Using the Database Scripts.- Appendix D Webliography.- Installation Links.- Data Source Product Web Sites.- Object-Oriented Data Stores.- XML Databases.- Relational Databases.- Community-Based Development Sites.- 2.- 3.- 6.- 7.- 9.- 10.- 11.

Über Autor(innen)

Dan Maharry is a UK-based professional technical author with over a dozen books to his name and many more as technical reviewer and editor for a variety of publishers including Wrox, Apress, Microsoft Press and O'Reilly Associates. He's also a .NET developer with past stints for the dotCoop TLD registry and various web development houses under his belt. He contributes code and documentation to various open source projects and tries to blog and to speak from time to time to user groups about cool stuff. He listens to a lot of new music as he does the above.