Shailaja ICFAI

• Jul 16th, 2005

 

recordset-is used in DAO control to access the data 
resultset-is used in RDO control to access the data

vishnu bobade

• Sep 8th, 2005

 

Resultsets in streams  
ADO can return resultsets from a data source in a Stream, rather than a Recordset object. Using the latest version of the Microsoft OLE DB Provider for SQL Server, you can get XML results from the provider by executing a "For XML" query. A Stream that receives the resultset can be opened with a "For XML" command as the source. 
Single row resultset  
The ADO Record object can now be opened on a command string or Command object that returns one row of data from the provider. This results in improved performance with MDAC 2.6 providers