Visual Basic 2005 Database Expert Programming

Author: (USA) Roger Jennings
Publisher:
Publish Date: 2006-11-01
Features: Are you still hesitating whether to migrate to Visual Studio 2005? You might already be ready to upgrade to Visual Studio 2005, but you may have doubts about ADO.NET and the new version of Visual Studio Tools. This book introduces best practices, new features, and advanced data management techniques for Visual Studio 2005 and SQL Server or SQL Server Express 2005, along with project examples ranging from simple to medium complexity, which are real database front-end applications featuring Windows and Web forms. The book first covers the basics of ADO.NET 2.0, then explains how to design and write smart clients using typed DataSets as data sources, and introduces the use of DataSource, GridView, and DetailsView web controls. Finally, it covers the use of new T-SQL extensions, web services, and notifications. This book is suitable for those preparing to migrate from VB6 or VS2002/2003 to VB2005 and who have VB programming experience. Basic familiarity with the VB2005 or VB Express 2005 environment is helpful for learning this book but is not required. The book does not require readers to have experience with VB6, VBA, or VBScript. This book is written by Microsoft database development expert and renowned author Roger Jennings, targeting experienced Visual Basic programmers. It contains rich data development techniques and experience in VB2005, covering ADO.NET 2.0, SQL Server 2005, and ASP.NET 2.0 data processing technologies, helping readers significantly improve their skills in developing database applications using VB2005 and SQL Server 2005. This book is written by Microsoft database development expert and renowned author Roger Jennings, targeting experienced Visual Basic programmers. It contains rich data development techniques and experience in VB2005, covering ADO.NET 2.0, SQL Server 2005, and ASP.NET 2.0 data processing technologies, helping readers significantly improve their ability to develop database applications using VB2005 and SQL Server 2005. Are you still hesitating whether to migrate to Visual Studio 2005? You might already be ready to upgrade to Visual Studio 2005, but you may have doubts about ADO.NET and the new version of Visual Studio Tools. This book introduces best practices, new features, and advanced data management techniques for Visual Studio 2005 and SQL Server or SQL Server Express 2005, along with project examples ranging from simple to medium complexity, which are real database front-end applications featuring Windows and Web forms. The book first covers the basics of ADO.NET 2.0, then explains how to design and write smart clients using typed DataSets as data sources, and introduces the use of DataSource, GridView, and DetailsView web controls. Finally, it covers the use of new T-SQL extensions, web services, and notifications. Main Content: ● How to build practical Windows and Web forms using an example database in less than 5 minutes without writing any code. ● Writing data validation code for bound text boxes and DataGridView. ● Advanced applications of ASP.NET 2.0 data technologies. ● Creating and deploying VB2005 SQLCLR projects. Target Audience This book is suitable for those preparing to migrate from VB6 or VS2002/2003 to VB2005 and who have VB programming experience. Basic familiarity with the VB2005 or VB Express 2005 environment is helpful for learning this book but is not required. The book does not require readers to have experience with VB6, VBA, or VBScript.