Prev Next

ADO Stream

The Stream object in ADO is used to read, write, and manage binary or text data. It is commonly used for handling files and large data objects.

Key Topics

Writing to a Stream

Example

<%
    Dim stream
    Set stream = Server.CreateObject("ADODB.Stream")
    stream.Type = 2 ' Text
    stream.Open
    stream.WriteText "Hello, this is a text stream!"
    stream.SaveToFile "C:\\output.txt", 2 ' Overwrite
    stream.Close
    Set stream = Nothing
%>

Explanation: This example demonstrates writing text data to a file using the Stream object.

Reading from a Stream

Example

<%
    Dim stream
    Set stream = Server.CreateObject("ADODB.Stream")
    stream.Type = 2 ' Text
    stream.Open
    stream.LoadFromFile "C:\\output.txt"
    Response.Write stream.ReadText
    stream.Close
    Set stream = Nothing
%>

Explanation: This example demonstrates reading text data from a file using the Stream object.

Key Takeaways

  • The Stream object handles binary and text data efficiently.
  • Use methods like WriteText and ReadText for managing text streams.
  • Always close the Stream object after use to release resources.
Prev Next