There are two separate methods of retrieving XML data from a data source: one uses CStreamRowset and the other uses CXMLAccessor.

While CStreamRowset provides a more overall efficient way of retrieving data in XML format, it is only supported by SQL Server 2000.

You specify CStreamRowset as the rowset type in your CCommand or CTable declaration. You can use it with your own accessor or no accessor, for example:

CCommand<CAccessor<CMyAccessor>, CStreamRowset> myCmd;  

-or-

CCommand<CNoAccessor, CStreamRowset> myCmd;  

Normally when you call CCommand::Open (specifying, for example, CRowset as the TRowset class), it obtains an IRowset pointer. ICommand::Execute returns an IRowset pointer, which is stored in the m_spRowset member of the CRowset object. Methods such as MoveFirst, MoveNext, and GetData use that pointer to retrieve the data.

By contrast, when you call CCommand::Open (but specify CStreamRowset as the TRowset class), ICommand::Execute returns an ISequentialStream pointer, which is stored in the m_spStream data member of CStreamRowset. You then use the Read method to retrieve the (Unicode string) data in XML format. For example:

myCmd.m_spStream->Read()  

SQL Server 2000 performs the XML formatting and returns all columns and all rows of the rowset as one XML string.

For an example using the Read method, see "Adding XML Support to the Consumer" in Implementing a Simple Consumer.

CXMLAccessor allows you to access data from a data source as string data when you have no knowledge of the data store's schema. CXMLAccessor works like CDynamicStringAccessorW except that the former converts all data accessed from the data store as XML-formatted (tagged) data. The XML tag names match the data store's column names as closely as possible.

Use CXMLAccessor as you would any other accessor class, passing it as a template parameter to CCommand or CTable:

CTable<CXMLAccessor, CRowset> rs;  

Use GetXMLRowData to retrieve data from the table one row at a time, and navigate rows using methods such as MoveNext, for example:

// Open data source, session, and rowset  
hr = rs.MoveFirst();  
while( SUCCEEDED(hr) && hr != DB_S_ENDOFROWSET )  
{  
    CStringW strRowData;  
    myCmd.GetXMLRowData(strRowData);  
  
    printf_s( "%S\n", strRowData );  
  
    hr = rs.MoveNext();  
}  

You can use GetXMLColumnData to retrieve the column (data type) information as XML-formatted string data.

Using Accessors