Surveys indicate that 80% of projects assigned to Visual Basic programmers require a knowledge of database programming. This comprehensive guide gives these programmers the hands-on techniques they need to create cutting-edge database applications for client/server networks and the Web using ADO (ActiveX Data Objects), COM+, XML, and other state-of-the-art programming tools. The CD-ROM includes all example code.
Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.
It takes exposure to quite a few tools and APIs to be successful with database development today. The Visual Basic 6 Database Programming Bible lets the beginning reader master what's really important, with a wide-ranging and effective tutorial on databases, along with some excellent coverage of the latest in XML and Oracle support in VB.
This book starts from the ground up, with a nicely digestible tour of the essentials of databases and SQL that's aimed at the beginner. Of course, it's de rigueur for VB titles to cover ActiveX Data Objects (ADOs), Microsoft's recommended set of objects for database programming. This book does a good job here, with three excellent chapters on how to be effective with ADO within your VB programs, both with "bound" controls and through custom code. Besides the fundamentals of ADO, this title also will serve as a handy reference, as each section lists all of the objects and methods that you'll need to use everyday. Other sections look at COM+ transactions and message-queue services, which provide much of the power for building robust, scalable database applications on the Microsoft Windows platform.
But this text goes much further than the "official" Microsoft way, with excellent coverage of administering and programming stored procedures on Oracle 8i (as well as MS SQL Server 7.0). With plenty of screen shots, this book does a great job of demystifying Oracle, and helps put this popular database into the reach of any VB developer. Several sections even look at XML done in VB, along with a basic tutorial of what XML is and how to combine it with ADO to deliver intermediate datasets. It's this cross-vendor perspective that distinguishes Visual Basic 6 Database Programming Bible from the rest of the pack. Clearly, today's VB programmers no longer can afford to have a narrow, Microsoft-only focus. This up-to-date text will help you gain a wider view of some of the more popular APIs and tools that you'll need to use to succeed with VB in real software for real organizations. --Richard Dragan
Topics covered: History and overview of databases, relational databases, basic database-design principles: tables, views, and indexes; ODBC, RDO, and ADO database connectivity compared; SQL primer, introduction to Visual Basic 6 and tools, "codeless" database applications with bound controls, report design with the Microsoft Data Report Designer, ADO 2.5 (and ADOX) objects and methods, using SQL stored procedures and the Command object, writing and debugging stored procedures, the Connection, Recordset, and Field objects; basic COM+ principles, building custom VB COM objects, transaction basics with COM+, message queues and asynchronous messaging, XML tutorial (XML, XSL, and the XML Document Object Model), XML used with ADO and IIS applications, SQL Server 7.0 and Oracle 8i administration and database-programming tutorials (including stored procedures on both platforms), and a tutorial for the Microsoft Jet database engine.From the Publisher:
Inside you'll find complete coverage of Visual Basic database programming:
Jump start your programming with Data Environments and Data Report Designer
Harness the power of the ADO 2.5 object model, from connections to commands
Integrate XML with Internet Information Server applications
Manipulate Recordsets to optimize the performance of your application
Create custom bound controls, COM+ transactions, and message queuing modules
Tailor an application for Microsoft SQL Server 7, Oracle 8i, or Microsoft Jet 3.51/4.0
Capitalize on custom utilities and SQL language extensions, such as PL/SQL
Construct platform-specific data types and manage security, logins, roles, and users
Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.
Descrizione libro John Wiley & Sons Inc (Compute, 2000. Paperback. Condizione libro: New. Codice libro della libreria P110764547283
Descrizione libro John Wiley & Sons Inc (Computers). PAPERBACK. Condizione libro: New. 0764547283 New Condition. Codice libro della libreria NEW6.0410961
Descrizione libro John Wiley & Sons Inc (Computers), 2000. Paperback. Condizione libro: New. Codice libro della libreria DADAX0764547283