Database
  Home arrow Database arrow ADO`s Stream Object
Iron Speed
ASP Free Forums 
.NET  
ASP  
ASP Code  
ASP.NET  
ASP.NET Code  
BrainDump  
C#  
Code Examples  
Database  
Database Code  
IIS  
Microsoft Access  
MS SQL Server  
Visual Basic.NET  
Windows Scripting  
Windows Security  
XML  
ASP Web Hosting  
ASP.NET Web Hosting 
Dedicated Servers 
Download TestComplete 
Windows Web Hosting
 
IBM® developerWorks 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
IBM Rational Software Development Conference
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
DATABASE

ADO`s Stream Object
By: Jayaram Krishnaswamy
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 5 stars5 stars5 stars5 stars5 stars / 3
    2006-09-19

    Table of Contents:
  • ADO`s Stream Object
  • How to open a Stream object using ADO
  • Syntax for opening a Stream
  • Opening a Stream using an open Record Object
  • Opening a Stream using an URL reference
  • Opening a Stream with no argument, Memory Stream

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    Iron Speed
     
    ADVERTISEMENT

    TestComplete™ automates software testing for a fraction of what the big guys charge. Easy functional and load testing for all Windows, .NET, Java and Web apps. Download a free trial now.

    ADO`s Stream Object
    (Page 1 of 6 )

    The Record and Stream objects were introduced with ADO 2.5 (the present version is ADO 2.8) to extend the then data manipulation capabilities of ADO to cover a much larger information base. Especially with the Internet emerging as a global repository of data of all kinds, a means was necessary to look at the details of such a repository. Since these were file- and folder-based, methodologies to look at these hierarchical data sources were necessary. The Record and Stream objects provide such a capability and exist in the ADO Object Model.

    Introduction

    The Record object navigates through the file and folder structure, manipulating (copying, moving, and deleting) the files and folders. The Record object is inherently associated with a Stream object, a buffer area from which the content of the Stream can be read. The nature of the contents of a Stream could be text or binary type of information, although Microsoft documentation mentions just the binary part.

    Tutorial content

    In an earlier tutorial we have seen how Record objects can be created using the URL of a web site and also as an object riding on top of a recordset. The recordset in this case was opened using the URL as an argument. The focus of this tutorial is to describe how one may create a Stream object using ADO.

    The properties of the Stream created will be described using examples of documents on the intranet site as the record; Stream objects are really meant for looking at such objects. As for the platform for testing, MS Access 2003 is used. Of course all this can be done in VB 6. But most readers already have MS Access;  that is the reason the tutorial uses this platform for examples. Typically a form is used for testing with a single button. The URL used in the tutorial is the local IIS (5.1).

    More Database Articles
    More By Jayaram Krishnaswamy


       · There will be a follow up article that shows you how to manipulate the web files on...
     

    DATABASE ARTICLES

    - Database Programming in C# with MySQL : Usin...
    - Formatting Techniques for Data Access from E...
    - Data Access from Excel VBA
    - Generating a Multiple Table Crystal Report u...
    - ADO and the Command Object
    - On Wiring Up an ADO Data Control
    - Reading and Writing to Files on the Intranet
    - Using ADO Record to Create and Navigate Intr...
    - Using Data Access Pages to Access Data on a ...
    - Using ADO with the SQL Native Client
    - ADO`s Stream Object
    - Opening a Record Object Referencing an Open ...
    - Introducing Jasper (SQL Anywhere 10 Beta)
    - Creating a Database Project in VS 2005
    - Manipulating ADO Recordsets

     
    Accelerating Trading Partner Performance
     
    Competing on Analytics
     
    Cost Effective Scaling with Virtualization and Coyote Point Systems
     
    Five Checkpoints to Implementing IP Telephony
     
    Hosted Email Security: Staying Ahead of New Threats
     




    © 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway