专家一对一Visual Basic 2005数据库编程 EXPERT ONE-ON-ONE VISUAL BASIC
点此进入淘宝搜索页搜索分类: 图书,计算机/网络,程序设计,Basic VB VB Script,
作者： Roger Jennings 著
出 版 社： John Wiley & Sons
出版时间： 2006-12-1字数：版次： 1页数： 585印刷时间： 2006/12/01开本：印次：纸张： 胶版纸I S B N ： 9780764576782包装： 平装内容简介
Are you hesitant to migrate to Visual Studio(r) 2005? Maybe you're ready to upgrade to Visual Basic 2005 but feel a bit overwhelmed by ADO.NET 2.0 and the Visual Data Tools of this new release. In this hands-on guide, I'll share with you the best practices, the latest features, and advanced data management techniques with Visual Basic 2005 and SQL Server or SQL Server Express 2005. Plus, I'll incorporate simple to moderately complex project examples that feature real-world, database front-end applications with Windows and Web forms.
First, I'll begin with ADO.NET 2.0 basics, then I'll move on to designing and programming smart clients with typed DataSets as their data sources. Gradually, I'll walk you through using DataSource, GridView, and DetailsView Web controls. Finally, I'll demonstrate how to take advantage of the new T-SQL extensions, in-process Web services, and notifications.
作者简介：
Roger Jennings is the author of more than 20 books about Microsoft database platforms and Windows operating systems. He is also a principal of OakLeaf Systems, a columnist for Fawcette Technical Publications' online newsletters, and a contributing editor for Visual Studio Magazine. His U.S. Code of Federal Regulations Web services won the 2001 Microsoft .NET Best Award for horizontal solutions.
目录
Acknowledgments
Introduction
Part Ⅰ: ADO.NET 2.0 Basics
Chapter 1: Migrating from ADO to ADO.NET
A New Approach to Data Access
The System.Data Namespace
ADO.NET Data Providers
Basic ADO.NET Data Objects
Creating Basic ADO.NET Data Objects with SqlClient
Applying Transactions to Multi-Table Updates
Using OleDb, SqlXml, and Odbc Member Classes
Working with Typed DataReader and SqlResultSet Data
ADO.NET Typed DataSet Objects
Add a Typed DataSet from an SQL Server Data Source
Add a DataGridView and BindingNavigator Controls
Persist and Reopen the DataSet
Change from a DataViewGrid to a Details Form
Add a Related DataBound Control
Summary
Chapter 2: Introducing New ADO.NET 2.0 Features
Working with New ADO.NET 2.0 Runtime Windows Form Objects
Use the DbProviderFactories to Create Database-Agnostic Projects
Retrieve Base Table Schemas
Check Available SQL Server Instances and ADO.NET 2.0 Data Providers
Batch Inserts to SQL Server Tables with the SqlBulkCopy Object
Get SQL Server Connection Statistics
Execute SqlCommands Asynchronously
Create Standalone DataTables
Use Nullable Types to Support DBNull Values
Using New ADO.NET 2.0 Persistent Windows Form Objects
Compare ADO.NET 1.x and 2.0 Data Designers
Add Missing ADO.NET Controls to the Toolbox
Upgrade l.x Projects to ADO.NET 2.0 Components
Add Multi-Level Subforms
Parameterize the MasterDetailsForm
Batch Multiple Updates
Design and Display Reports with the ReportViewer Control
Summary
Chapter 3: Adopting Best Practices for Data-Centric Projects
Establish Architectural Best Practices
Reference Architectures
Find Patterns for Projects
Enterprise Solution Patterns Using Microsoft .NET
Data Patterns
Distributed Systems Patterns
Integration Patterns
Try Application Block Libraries
The Data Access Application Block
The DataAccessQuickStart Client
Adhere to Design Guides
The .NET Data Access Architecture Guide
Improving .NET Application Performance and Scalability
Designing Data Tier Components and Passing Data Through Tiers
Apply Class Library Design Guidelines
Naming Guidelines
Class Member Usage Guidelines
Prepare for Service-Oriented Architecture
The Road to Service-Oriented Architecture
Implement SOA with Web Services
Ensure Fully Interoperable Web Services
Use FxCop to Validate Project Code
Automate Test-Driven Development
Add a Unit Test Project to a VS 2005 Solution
Edit and Run the Wizard-Generated Tests
Run the SQL Server 2000 Best Practices Analyzer
Apply Specific Best Practices to ADO.NET 2.0 Projects
Use Identical Connection Strings to Pool Database Connections
Run SQL Server Profiler to Inspect SQL and RPC Queries
Avoid Adding Runtime CommandBuilder Instances
……
Part Ⅱ: Data Binding in Windows Forms and Controls
Chapter 4: Programming TableAdapters, BindingSources, and DataGridViews
Chapter 5: Adding Data Validation and Concurrency Management
Chapter 6: Applying Advanced DataSet Techniques
Part Ⅲ: Data Binding in ASP.NET 2.0
Chapter 7: Working with ASP.NET 2.0 DataSources and Bound Controls
Chapter 8: Applying Advanced ASP.NET 2.0 Data Techniques
Chapter 9: Publishing Data-Driven Web Services
Part Ⅳ: SQL Server 2005 and ADO.NET 2.0
Chapter 10: Upgrading from SQL Server 2000 to 2005
Chapter 11: Creating SQL Server Projects
Chapter 12: Exploring the XML Data Type
Index
