ASP.NET, SQL Server, WPF, C#, VB.NET

Hi, 
 
I'm trying to follow ADO calls for the scenario of select statement, 
 
change value and update it. 
 
set rs = CreateObject("ADODB.RecordSet") 
 
.. 
 
.. 
 
rs.fields("name").value = "new_value" 
 
rs.update 
 
Select statement in ADO creates ICommandText object. Its method Execute 
 
creates IRowset object. 
 
I understand IRowsetUpdate should be created so its method Update can 
 
be used. However, I don't see any QueryInterface from IRowset to 
 
IRowsetUpdate or anything else after IColumnsInfo. 
 
How does IRowsetUpdate being created then ? Maybe QueryInterface from 
 
another object ? 
 
Thanks, 
 
Gilad.

I figured it out. Execute creates IMultipleResults and on GetData it 
 
creates a IUnknown object that QueryInterface to IRowsetUpdate. 
 
gilad wrote: