DescriptionAre 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.
What you will learn from this book
- How to build usable Windows(r) and Web forms from a sample database in less than five minutes-without writing a line of code
- Effective writing of data validation code for bound text boxes and DataGridViews
- Ways to apply advanced ASP.NET 2.0 data techniques
- The process of creating and deploying VB 2005 SQL CLR projects
Who this book is for
This book is for experienced VB programmers who are upgrading from VB6 or VS 2002/2003 to VB 2005. Basic familiarity with the VS 2005 or VB Express 2005 environment is helpful but not assumed. No prior VB6, VBA, or VBScript experience is necessary.
Wrox Expert One-On-One books present the wisdom accumulated by an experienced author who is recognized as an expert by the programming community. These experts challenge professional developers to examine their current practices in pursuit of better results.
Part I: ADO.NET 2.0 Basics.
Chapter 1: Migrating from ADO to ADO.NET.
Chapter 2: Introducing New ADO.NET 2.0 Features.
Chapter 3: Adopting Best Practices for Data-Centric Projects.
Part II: 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 III: 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 IV: 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.
|Code Replacement / Errata Download,The code update for this title has been posted and may be accessed via:|
|8||Error in Text (Figure),Figure 1-2, Top left block:|
|9||Error in code,running code returns error message:|
There is already an open datareader associated with this command which must be closed first.
remove the code line that reads:
sdrReader = cmdReader.ExecuteReader
|25||Error in Text (Figure),Figure 1-5, Top left block:|
OLE CB Provider
OLE DB Provider
|4||138||Typo,'Clean Up the UI and Code':|
Bullet point 2 should read:
. . . delete the FillByCustomerIDToolStripButton_Click and FillByCustomerIDToolStripButton1_Click
Note the removal of the number '1' in the earlier click event.