Dotnetcat » .NET Books » Database books

Now in its 4th Edition, this book shows Visual Basic developers how to use Visual Studio and ADO.NET to develop database applications the way the best professionals do. You'll learn how to:

• quickly create Windows and web applications by dragging-and-dropping data controls in Visual Studio 2010
  
• code your own presentation, business, and database classes with ADO.NET 4 to build 3-layer applications...the route the professionals take for flexibility and control
  
• display and manipulate data in web applications by using ASP.NET data controls designed specifically for that purpose, like GridView and DetailsView
  
• work with XML-specific features of ADO.NET and SQL Server to read, write, and manipulate XML data in your applications
  
• create local reports using Visual Studio's Report Designer and Report Viewer to display data easily...and clearly!...in tables, matrices, lists, and charts
  
• Use the Entity Framework to create an entity data model that maps business objects to database objects, then retrieve and maintain data through that model
  
• Use LINQ to query datasets, SQL Server databases, and entity data

Practice exercises at the end of every chapter and complete database applications throughout help you master every skill along the way. And Murach's distinctive "paired-pages" format...where each skill is presented with examples and advice in a single 2-page spread...is great for both targeted learning and reference.

Now in its 4th Edition, this book shows C# developers how to use Visual Studio and ADO.NET to develop database applications the way the best professionals do. You'll learn how to:

• quickly create Windows and web applications by dragging-and-dropping data controls in Visual Studio 2010


• code your own presentation, business, and database classes with ADO.NET 4 to build 3-layer applications...the route the professionals take for flexibility and control


• display and manipulate data in web applications by using ASP.NET data controls designed specifically for that purpose, like GridView and DetailsView


• work with XML-specific features of ADO.NET to read, write, and manipulate XML data in your applications


• use Visual Studio's Report Designer and ReportViewer control to create and display reports in both Windows and web applications


• use LINQ to SQL instead of standard SQL so you can query databases using C# constructs


• create Entity Data Models so you can use LINQ to Entities to work with business objects, like invoices, while the Entity Framework handles the database details

Practice exercises at the end of every chapter and complete database applications throughout help you master every skill along the way. And Murach's distinctive "paired-pages" format...where each skill is presented with examples and advice in a single 2-page spread...is great for both targeted learning and reference.

A novel approach to developing and applying databases with Visual C#.NET

Practical Database Programming with Visual C#.NET clearly explains the considerations and applications in database programming with Visual C#.NET 2008 and in developing relational databases such as Microsoft Access, SQL Server, and Oracle Database. Sidestepping the traditional approach of using large blocks of code, Ying Bai utilizes both Design Tools and Wizards provided by Visual Studio.NET and real-time object methods to incorporate over sixty real sample database programming projects along with detailed illustrations and explanations to help readers understand the key techniques and programming technologies in database programming. This invaluable resource features:

• Fundamental and advanced database programming techniques for beginning and experienced students as well as programmers

• A real completed sample database CSE_DEPT with three versions (Microsoft Access 2007, SQL Server 2005 SP2, and Oracle Database 10g XE Release 2) used throughout the entire book

• Step-by-step details on designing and building a practical relational database

• Discussion and analysis of the new database query technique, LINQ API—which includes LINQ to Objects, LINQ to DataSet, LINQ to SQL, LINQ to Entities, and LINQ to XML—and implementation in actual projects with line-by-line explanation

• Homework and selected solutions for each chapter to strengthen and improve learning and understanding

• An Instructor's Manual (MS PPT), example codes and exercise questions, homework/exercise solutions, and database projects available for free download

• E-mail assistance from the author

Readers who will benefit highly from this reference are undergraduate or graduate students majoring in computer science and engineering, graduate students in all engineering departments, and software engineers and researchers in academic and industrial fields.

To obtain instructor materials please send an email to pressbooks@ieee.org

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

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.

Beginning Visual Basic 2005 Databases teaches you everything you need to know about relational databases, SQL, and ADO.NET 2.0, giving you a sound start in developing console and Windows database applications. The book also includes chapters on the new SQL Server XML data type and the forthcoming LINQ enhancements to the next version of Visual Basic.

In addition to teaching you database basics like using SQL to communicate with databases, this book provides you with detailed, code-practical techniques to access data in VB 2005 across a range of coding situations. Code-heavy and full of practical detail, this book has been fully revised and upgraded for .NET 2.0 and offers you the best contemporary practice in this core programming area, so that youll find yourself using it in nearly all your .NET projects.

This book is for anyone who wants to learn how to build rich and interactive web sites that run on the Microsoft platform. With the knowledge you gain from this book, you create a great foundation to build any type of web site, ranging from simple hobby-related web sites to sites you may be creating for commercial purposes.

Anyone new to web programming should be able to follow along because no prior background in web development is assumed. The book starts at the very beginning of web development by showing you how to obtain and install Visual Web Developer. The chapters that follow gradually introduce you to new technologies, building on top of the knowledge gained in the previous chapters.

Do you have a strong preference for Visual Basic over C# or the other way around? Or do you think both languages are equally cool? Or maybe you haven't made up your mind yet and want to learn both languages? Either way, you'll like this book because all code examples are presented in both languages!

Even if you're already familiar with previous versions of ASP.NET, with the 1.x versions in particular, you may gain a lot from this book. Although many concepts from ASP.NET 2.0 are brought forward into ASP.NET 3.5, you'll discover there's a host of new stuff to be found in this book, including an introduction to LINQ, the new CSS and JavaScript debugging tools, new ASP.NET controls, and integrated support for ASP.NET Ajax.

To build effective and attractive database-driven web sites, you need two things: a solid and fast framework to run your web pages on and a rich and extensive environment to create and program these web pages. With ASP.NET 3.5 and Visual Web Developer 2008 you get both. Together they form the platform to create dynamic and interactive web applications.

ASP.NET 3.5 builds on top of its popular predecessor ASP.NET 2.0. While maintaining backward compatibility with sites built using this older version, the Microsoft .NET Framework 3.5 in general and ASP.NET 3.5 in particular add a lot of new, compelling features to the mix.

Continuing the path of "less code" that was entered with the 2.0 version of the .NET Framework, ASP.NET 3.5 lets you accomplish more with even less code. New features like LINQ that are added to the .NET Framework allow you to access a database with little to no hand written code. The integration of Microsoft ASP.NET Ajax into the ASP.NET Framework and Visual Web Developer means you can now create fast responding and spiffy web interfaces simply by dragging a few controls onto your page and setting a few properties. This book gives you an in-depth look at both these technologies.

The support for cascading style sheets (CSS), the language to lay out and format web pages, has undergone a major overhaul in Visual Web Developer. The design time support, that shows you how a page will eventually look in the browser, has been vastly improved. Additionally, Visual Web Developer now ships with a lot of tools that make writing CSS a breeze.

However, drag-and-drop support and visual tools are not the only things you'll learn from this book. ASP.NET 3.5 and Visual Web Developer 2008 come with a great and extensive set of tools to help you program your web applications. These tools range from the new LINQ syntax that allows you to query data and databases in your web applications, to the vastly improved debugging capabilities that allow you to debug your application from client-side JavaScript all the way up into your server-side code, all with the same familiar user interface, commands, and actions.

Under the hood, ASP.NET 3.5 makes use of the same run-time as version 2.0. This ensures a great backward compatibility with that version, which means that ASP.NET 2.0 applications continue to run under the new framework. But don't be fooled by the fact that the run-time hasn't changed. Although the technical underpinnings needed to execute your web application haven't changed, the .NET 3.5 Framework and ASP.NET add a lot of new features, as you'll discover in this book.

Probably the best thing of Visual Web Developer 2008 is its price: it's available for free. Although the commercial versions of Visual Studio 2008 ship with Visual Web Developer, you can also download and install the free Express Edition. This makes Visual Web Developer 2008 and ASP.NET 3.5 probably the most attractive and compelling web development technologies available today.

This book teaches you how to create a feature-rich, data-driven, and interactive web site. Although this is quite a mouthful, you'll find that with Visual Web Developer 2008 this isn’t as hard as it seems. You'll see the entire process of building a web site, from installing Visual Web Developer 2008 in Chapter 1 all the way up to putting your web application on a live server in Chapter 18. The book is divided into 18 chapters, each dealing with a specific subject.

Chapter 1, “Getting Started With ASP.NET 3.5.” In this chapter you'll see how to obtain and install Visual Web Developer 2008. You'll get instructions for downloading and installing the free edition of Visual Web Developer 2008, called the Express Edition. You are also introduced to HTML, the language behind every web page. The chapter closes with an overview of the customization options that Visual Web Developer gives you.

Chapter 2, “Building an ASP.NET Web Site.” This chapter shows you how to create a new web site and how to add new elements like pages to it. Besides learning how to create a well-structured site, you also see how to use the numerous tools in Visual Web Developer to create HTML and ASP.NET pages.

Chapter 3, “Designing Your Web Pages.” Visual Web Developer comes with a host of tools that allow you to create well-designed and attractive web pages. In this chapter, you see how to make good use of these tools. Additionally, you learn about CSS, the language that is used to format web pages.

Chapter 4, “Working with ASP.NET Controls.” ASP.NET Server controls are one of the most important concepts in ASP.NET. They allow you to create complex and feature-rich web sites with very little code. This chapter introduces you to the large number of server controls that are available, explains what they are used for, and shows you how to use them.

Chapter 5, “Programming Your ASP.NET Web Pages.” Although the built-in CSS tools and the ASP.NET server controls can get you a long way in creating web pages, you are likely to use a programming language to enhance your pages. This chapter serves as an introduction to programming with a strong focus on programming web pages. Best of all: all the examples you see in this chapter (and the rest of the book) are in both Visual Basic and C#, so you can choose the language you like best.

Chapter 6, “Creating Consistent Looking Web Sites.” Consistency is important to give your web site an attractive and professional appeal. ASP.NET helps you create consistent-looking pages through the use of master pages, which allow you to define the global look and feel of a page. Skins and themes help you to centralize the looks of controls and other visual elements in your site. You also see how to create a base page that helps to centralize programming code that you need on all pages in your site.

Chapter 7, “Navigation.” To help your visitors find their way around your site, ASP.NET comes with a number of navigation controls. These controls are used to build the navigation structure of your site. They can be connected to your site's central site map that defines the pages in your web site. You also learn how to programmatically send users from one page to another.

Chapter 8, “User Controls.” User Controls are reusable page fragments that can be used in multiple web pages. As such, they are great for repeating content like menus, banners, and so on. In this chapter, you learn how to create and use User Controls and enhance them with some programmatic intelligence.

Chapter 9, “Validating User Input.” A large part of interactivity in your site is defined by the input of your users. This chapter shows you how to accept, validate, and process user input using ASP.NET server controls. Additionally, you see how to send e-mail from your ASP.NET web application and how to read from text files.

Chapter 10, “ASP.NET Ajax.” Microsoft ASP.NET Ajax allows you to create good looking, flicker free web pages that close the gap between traditional desktop applications and web applications. In this chapter you learn how to use the built-in Ajax features to enhance the presence of your web pages, resulting in a smoother interaction with the web site.

Chapter 11, “Introduction to Databases.” Understanding how to use databases is critical to building modern web sites, as most modern web sites require the use of a database. You'll learn the basics of SQL, the query language that allows you to access and alter data in a database. In addition, you are introduced to the database tools found in Visual Web Developer that help you create and manage your SQL Server databases.

Chapter 12, “Displaying and Updating Data.” Building on the knowledge you gained in the previous chapter, this chapter shows you how to use the ASP.NET data-bound and data source controls to create a rich interface that enables your users to interact with the data in the database that these controls target.

Chapter 13, “LINQ.” LINQ is Microsoft's new solution for accessing objects, databases, XML, and more. In this chapter you'll see how to use LINQ to SQL to access SQL Server databases. Instead of writing a lot of manual code, you create a bunch of LINQ objects that do the heavy work for you. This chapter shows you what LINQ is all about, how to use the visual LINQ designer built into Visual Web Developer, and how to write LINQ queries to get data in and out of your SQL Server database.

Chapter 14, “Presenting Data: Advanced Topics....

Pro ODP.NET for Oracle Database 11g is the "go to" book for .NET programmers wanting to use the Oracle Database. The authors are well-known for their expertise in the Oracle Data Provider for .NET. A highlight of the book is the author's application of "Gang of Four" design patterns to ODP.NET programming.

Now you can uncover the secrets behind accessing and retrieving data from a wide range of data sources such as SQL Server and XML sources. This book walks you through the array of ADO.NET 2.0 features and clearly shows you how they can be used to develop database-driven web applications in ASP.NET.

You’ll first gain an in-depth understanding of the data source controls that enable data binding in the ASP.NET platform. Next you’ll uncover the advanced features of ASP.NET, including site navigation, implementing sorting and paging, and editing data in templates. You’ll then focus on designing transactions in ADO.NET 2.0, displaying data, and utilizing SQL Server 2005 XML.

Throughout the chapters, you’ll find examples and source code (with ASP.NET examples written in C#) that you can integrate into your applications. This will enable you to leverage ADO.NET and ASP.NET features so you can easily create a scalable N-Tier web site.

Some of the topics covered include:

• ASP.NET 2.0 Data Controls
• Data Binding with the SqlDataSource Control, XML Data, and Objects
• Selecting, Updating, Deleting Records
• Programmatically Creating and Adding Controls
• XSL Transformations with XmlDataSource Control
• Using Generics with the ObjectDataSource Control
• ASP.NET 2.0 Site Navigation including Implementing Breadcrumbs and Binding to Other Controls
• Displaying and Editing Data Using Templates
• GridView Sorting and Paging
• Advanced Data Source and Data-Bound Controls including Master/Detail Display, Displaying Images from a Database, and Using Themes with Data Bound Controls
• Transactions in .NET and Interoperability between System.Transactions and System.EnterpriseServices
• Advanced ADO.NET for ASP.NET Data Display including DataSet Object, ADO.NET 2.0 DataTable, and Provider-Independent Data Access Code
• Accessing Data from SQL Server 2005 including CLR in SQL Server 2005, New XML Features in SQL Server 2005, and Working with XML Data-Typed Columns from ADO.NET
• N-Tier Architecture with ASP.NET 2.0 and SQL Server 2005
• Best Practices for Creating ASP.NET Web Sites including Implementation of CLR Stored Procedures and Implementation of Layers

Visual Basic.NET Database Programming For Dummies covers everything you need to get up and running with this substantially changed version of Visual Basic and to begin creating databases for the new Microsoft .NET Platform. This book introduces programmers to quick database solutions with Visual Basic.NET; provides step-by-step instructions on how to design and build databases from scratch; and shows you how to create reports, validate and index data, and create custom controls. The book also demonstrates how to connect your database to the Internet.

Whether you are using WinForms, WebForms, or Web Services, Database Access with Visual Basic® .NET, Third Edition, is your practical guide to developing database applications with Visual Basic .NET and ADO.NET. The authors provide real-world solutions to the data-access issues Visual Basic .NET developers face every day and share their secrets for becoming a more effective database programmer using .NET technologies.

The book begins by reviewing the fundamentals of database development, Structured Query Language (SQL), and Microsoft SQL Server™ 2000. It then examines how to use the major ADO.NET objects to access data stored in relational databases. Through detailed examples, readers learn how to use properties and methods, as well as more advanced features and techniques. Extensive code listings in Visual Basic .NET illustrate each concept, while business cases apply concepts to real-world applications. The final chapters provide a solid examination of how XML and ASP.NET integrate with ADO.NET to create various types of database applications. A companion Web site provides the code used in the book's myriad examples, all of which is compatible with Visual Basic .NET 2003.

Key topic coverage includes:

SQL queries and commands

Using SQL Server 2000

ADO.NET objects

Advanced ADO.NET features and techniques

SQL Server and OLEDB, as well as ODBC .NET Data Providers

Using Visual Studio .NET Data Projects for managing SQL Scripts

Integrating XML with ADO.NET

Developing Web-based database applications with ASP.NET

Web services and middle-tier objects

Database Access with Visual Basic® .NET, Third Edition, equips VB developers with the knowledge and skills needed to build a powerful new generation of database applications in less time using .NET technologies.

0672323435B01092003