Robert MacDonald's Serious ADO: Universal Data Access with Visual Basic PDF

By Robert MacDonald

ISBN-10: 1430208627

ISBN-13: 9781430208624

ISBN-10: 1893115194

ISBN-13: 9781893115194

From pro developer and coach Rob Macdonald comes Serious ADO: common info entry with visible Basic, which teaches skilled visible uncomplicated builders find out how to utilize ADO, Microsoft's flagship product for database entry. Serious ADO covers the entire variety of makes use of for ADO, from uncomplicated use of the ADO know-how to really good issues and complex concepts that might profit even the main skilled developers.

The first a part of the e-book offers thorough insurance of ADO's parts and what they could do. alongside the way in which, Macdonald deals real-world code examples besides whole reasons of precisely what's happening at every one degree of the improvement technique. This half additionally covers the various key techniques upon which ADO programming relies, resembling locking and transactions, connection pooling, marshalling, and Inter procedure communique, between others.

The moment a part of the booklet addresses using ADO in real-world improvement situations. the following, Macdonald demonstrates complex person interface production, together with new how you can keep watch over the binding technique. you are going to additionally easy methods to use Microsoft Transaction Server of COM+ functions to create transactional component-based systems.

Show description

Read or Download Serious ADO: Universal Data Access with Visual Basic PDF

Best visual basic books

Download e-book for kindle: Visual Basic .NET Power Coding by Paul Kimmel

Visible BasicR . internet strength Coding is the skilled developer's consultant to gaining knowledge of complicated visible uncomplicated . internet options. Paul Kimmel saves readers money and time by means of supplying thorough motives of crucial issues so that you can speedy start growing powerful courses that experience fewer insects. the writer additionally demonstrates very important techniques through the use of quite a few real-world examples that come with operating code that has been proven opposed to visible easy .

Download e-book for kindle: Advanced Microsoft Visual Basics 6.0 by Mandelbrot Set International Ltd

Within the authors' phrases, "Our major goal in penning this publication is to put in writing the main complicated e-book but on hand" on Microsoft visible uncomplicated. Written from the viewpoint of the pro visible uncomplicated developer, complicated MICROSOFT visible easy, second variation explores all of the percentages open to a developer utilizing visible uncomplicated as his or her fundamental client/server improvement device.

Download e-book for iPad: Expert one-on-one Visual BASIC 2005 database programming by Roger Jennings

Are you hesitant emigrate to visible Studio(r) 2005? probably you are ready to improve to visible simple 2005 yet think a section crushed by way of ADO. internet 2. zero and the visible info instruments of this generation. during this hands-on advisor, i will proportion with you the simplest practices, the newest beneficial properties, and complicated info administration recommendations with visible easy 2005 and SQL Server or SQL Server exhibit 2005.

Download e-book for kindle: Visual Basic and Visual Basic .NET for Scientists and by Christopher M. Frenz

Visible easy and visible easy . internet for Scientists and Engineers starts off with an summary of the visible simple and visible easy . web IDEs, their vital features, and the way the advance environments could be manipulated to fit builders' wishes. After an exceptional dialogue of VB and VB . internet types, controls, and namespaces, writer Christopher Frenz exhibits you the way to place controls to paintings via applying different keep watch over occasions.

Extra info for Serious ADO: Universal Data Access with Visual Basic

Example text

Three properties are involved in Recordset paging: 1. PageSize: You set this property to specify how many records should appear on a page. 2. PageCount: This read-only property tells you how many pages there are. It's based on dividing PageSize by RecordCount. 3. AbsolutePage: You set this property to turn to a particular page. It's equivalent to AbsolutePosition, but with page-granularity instead of record -granularity. ll. There is an interesting design issue here. Does fat client mean too much processing on the client, or too much custom processing on the client?

9 The Filter property is an altogether more wonderful thing than the Find method. It allows a Recordset to appear as though it only has a subset of the actual records it contains. Operations applied to the Recordset work on the filtered subset of records until another filter is applied or the existing one is removed. 9. Why this discrepancy? I can only guess, but I suspect it's done this way for the benefit of Access programmers. Find is a familiar type of operation for DAO and Access, and the Jet database engine uses the same nonstandard wildcards.

Sort It's very annoying when you are debugging your code and you find that a function you called changed the Filter property on your Recordset. If anything, this exemplifies one of the potential pitfalls of ADO-its power makes it all too easy to leave something in an unexpected state. One ofVB's weakpoints over the years has been its lack of decent sorting capabilities. 10 It may please you to know that Recordsets have excellent built-in sorting-so good in fact, that you may be tempted to fabricate Recordsets simply in order to sort data.

Download PDF sample

Serious ADO: Universal Data Access with Visual Basic by Robert MacDonald

by James

Rated 4.38 of 5 – based on 10 votes