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. 作者簡(jiǎn)介：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
鄂公網(wǎng)安備 42010302001612號(hào) 