Synopses & Reviews
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.
Picking up where "Beginning ASP.NET with VB" left off, this book focuses on the all-important area of database programming and presents the expert's voice on the best way to achieve professional ASP .NET and database solutions.
This book carries on where 'Beginning ASP.NET with VB' finished, and focuses on the all-important area of database programming with ASP.NET. The vast majority of ASP.NET developers and ASP.NET applications need to access a database quickly and efficiently - it's a huge skill to have as an ASP.NET developer, and this book focuses on this area and shows the expert's voice on the best way to achieve professional ASP.NET and database solutions.
All web sites with any depth of content need a database behind them to store, edit and retrieve that information to be displayed on a website. ASP.NET can interact with databases to create websites like this.ASP.NET is a great web development technology for putting small-to-medium businesses onto the web. Its object-oriented architecture and solid database layer (ADO.NET) make it more robust and suited to e-commerce than simple scripting and tag-based solutions like PHP and ColdFusion, but its ease of use and tools support make it much faster to develop with than Java. Using ASP.NET you can easily build scalable, well-structured, extensible websites that you can support a business on. By introducing database programming in-depth to ASP.NET programmers, we are introducing a core skill set tutorial that is involved in almost every ASP.NET application of any size.
Table of Contents
Getting Started: Installing MSDE; A Simple Data-driven Web App; Introducing SQL.- ADO.NET Basics: What's ADO.NET? Connecting to the Database; Getting the Data; Using the DataReader; The DataSet and DataAdapter.- Data and the Web: Using Data in ASP.NET Pages; Advanced DataGrid Techniques; Validating User Input; Data in Web Services; Caching Data.- More about Databases: Tables and Relationships; More about SQL; Views and Stored Procedures; Indexes and Constraints; Data Security.- Advanced ADO.NET: ADO.NET and XML; Handling ADO.NET Errors; Transactions; Irregular Data.