Publisher's Synopsis
Meet the Challenge of Any Database Project with Visual Basic and ADOMastering Database Programming with Visual Basic 6 offers highly focused coverage of the techniques that make Visual Basic the ideal tool for database development. Assuming no prior experience with database programming, this book teaches you every aspect of the craft, from GUI design to server–side development to middle–tier implementation. Rather than waste your time with outmoded data access technologies, it takes you straight to the leading edge––ADO 2.5––helping you build database applications that will meet your organization′s needs now and into the future. Coverage includes:
- Understanding data access architectures and technologies
- Understanding relational database concepts
- Getting acquainted with SQL, including the most important features of SQL Server 7 for the VB programmer
- Understanding ADO and what it offers your database application
- Using the visual database tools
- Using ADO 2.5 to access databases from within your VB applications
- Getting the most from SQL Server using T–SQL and stored procedures
- Simplifying client application coding with stored procedures
- Constructing data–aware classes
- Implementing middle–tier components and data–bound ActiveX controls
- Supporting remote data access
- Encapsulating database operations with ActiveX controls
- Accessing a database from within Web applications using Active Server Pages
- Building applications that work with Internet Information Server and Microsoft Transaction Server
- Mapping data structures to hierarchical Recordsets and making the most of disconnected Recordsets
