Mastering Database Programming With Visual Basic 6

Evangelos Petroutsos is a computer engineer who gained much of his experience at the California Institue of Technology and MCI.

Enter a New World of Database Programming Visual Basic .NET and ADO.NET facilitate the development of a new generation of database applications, including disconnected applications that run on the Web. Mastering Visual Basic .NET Database Programming is the resource you need to thrive in this new world. Assuming no prior experience with database programming, this book teaches you every aspect of the craft, from GUI design to server development to middle-tier implementation. If you're familiar with earlier versions of ADO, you'll master the many new features of ADO.NET all the more quickly. You'll also learn the importance of XML within the new .NET paradigm. Coverage includes: Getting familiar with the ADO.NET object model Using the data access wizards Taking advantage of new SQL Server 2000 features Carrying out XSL Transformations and XPath queries Generating XML using the T-SQL FOR XML statement Binding controls to ADO.NET result sets Arriving at a sound database design Tuning your SQL Server 2000 database Using the XML Designer in Visual Studio .NET Leveraging the data access tools available in the Visual Studio .NET IDE Working with .NET data providers Choosing between streaming data and caching data Working with the Data Form Wizard in Visual Studio .NET Using advanced ADO.NET techniques Building a threaded application Using .NET's advanced exception handling capabilities Using the .NET Deployment Project Template Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Designed for experienced Visual Basic programmers needing to master the details of building applications that access relational and other data stores. This guide is organized as a reference with entries that include tutorials, step-by-step instructions, code samples and other elements designed to speed mastery of the subject matter.

VB Programmers: Get in Step with .NET With the introduction of Visual Basic .NET, VB transcends its traditional second-class status to become a full-fledged citizen of the object-oriented programming, letting you access the full power of the Windows platform for the first time. Written bythe author of the best-selling Mastering Visual Basic 6 this all-new edition is the resource you need to make a successful transition to .NET. Comprising in-depth explanations, practical examples, and handy reference information, its coverage includes: Mastering the new Windows Forms Designer and controls Building dynamic forms Using powerful Framework classes such as ArrayLists and HashTables Persisting objects to disk files Handling graphics and printing Achieving robustness via structured exception handling and debugging Developing your own classes and extending existing ones via inheritance Building custom Windows controls Building menus and list controls with custom-drawn items Using ADO.NET to build disconnected, distributed applications Using SQL queries and stored procedures with ADO.NET Facilitating database programming with the visual database tools Building web applications with ASP.NET and the rich web controls Designing web applications to access databases Using the DataGrid and DataList web controls Building XML web services to use with Windows and web applications Special topics like the Multiple Document Interface and powerful recursive programming techniques Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

While previous versions of Visual Basic had some database facilities, with Visual Basic 6, Microsoft has created a robust, fully-fledged database programming language. VB6 includes a raft of highly effective database features and toolsincluding hundreds of efficiencies, step-through wizards, and shortcutsthat in most cases are extremely easy to understand and master. Among the most important of these are ADO Data Control, Data View window, Query Designer, DataRepeater Control, Data Environment Designer, ActiveX Document Migration Wizard, WebClass Designer, and Visual Data Manager. Visual Basic 6 Database Programming For Dummies is a friendly, no-nonsense guide for programmers already familiar with Visual Basic who want to take advantage of all of version 6s powerful database features. Packed with real-world examples and plain-English explanations, it cuts through the jargon and shows you, step-by-step, how to: Build professional-looking database programs Craft user-friendly interfaces and robust reports Automate programming with built-in tools Maximize Internet connectivity with ActiveX Develop ASP and IIS applications Transitions from DAO to ADO Understand how best to use all of VBs built-in database features Get the most out of VBs Data Environment Designer Know ho to use SQL Author Richard Mansfield gives you a solid understanding of what databases are, how they work, and what you can do with them. Then he walks you through all the steps to creating powerful database applications. Topics covered include: Getting connected with data controls and the Data Form Wizard Using the Data Environment Designer Designing a user interface Building a new database from scratch Translating Windows applications to Web pages using ActiveX Document Migration Wizard Combining HTML and VB to create active server pages Creating IIS applications Data access programming Using the Query Designer Have you been baffled by the alphabet soup of VB6 acronyms? Have you tried other books on the subject and found them sourly lacking in clarity? Dont despair, relax and let Visual Basic 6 Database Programming For Dummies gently ease you into the world of database programming.

* Provides a good foundation for Microsoft Access and Visual Basic database programming * Offers thorough coverage of object-oriented programming, including how to create data handling classes and ActiveX controls for code reusability * Covers DAO, ADO, ASP, and SQL, and demonstrates how to take data mining to the next level

Enter a new world of database programming,,Visual basic .NET and ADO.NET facilitate the development of a new generation of database applications, including disconnected applications that run on the web. Mastering Visual Basic .NET database programming is the resource you need to thrive in this new world. assuming no prior experience with the database programming, this book teaches you every aspect of the craft, from GUI design to server development to middle tier implementation. If you're familiar with earlier version of ADO, you will master the many new features of ADO.NET all the more quickly. you will also learn the importance of XML within .NET paradigm.Coverage include,a) Getting familiar with the ADO.NET object model,b) Using the data access wizards,c) Taking advantage of new SQL Server 2000 features,d) Carrying out XSL Transformation and XPath queries,e) Generating XML using T-SQL for XML statement,f) Binding controls to ADO.NET results set,g) Tuning your SQL Server 2000 database,h) Using XML Designer in Visual Studio .NET,i) Leveraging the data access tools available in the visual studio .NET IDE,j) Working with .NET data providers,k) Choosing between streaming data and caching data,l) Working with the data form wizards in Visual Studio .NET,m) Using advanced ADO.NET techniques,n) Building a threaded application,o) Using .NET's advanced exception handling capabilities,p) Using .NET Deployment Project Template

This expert guide covers what you need to know to program with Visual Basic 2008, employ the latest Visual Studio 2008 tools, and operate efficiently within the .NET Framework. In an easy-to-follow style, the book moves from in-depth explanations to practical instruction to real-world examples. Explore basic coding in VB 2008 and learn to build interfaces without coding by using Visual Studio 2008's drag-and-drop visual tools. You?ll get up to speed on LINQ and handle key tasks such as programming TreeView controls, and more.