Iterating an ADODB RecordSet using System.Reflection

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Everyone,

I have to be able to retrieve data from ADODB RecordSet, but without
referencing the ADODB interop. I do get a RecordSet object, but when I
try to use a DataAdapter to populate a Dataset:
myDataAdapter.Fill(myDataSet, myRecordSetObject, "MyTableName");
I get the exception:
Row handles must be released before new ones can be created.

Any simple ideas how I can do this? It woudl only be a few records, in
read-only access.

Many thanks,
Jules

.

Relevant Pages

  • Re: VB.Net Datagrid
    ... >> Is there a way to bind a datagrid in VB.Net to an ADODB Recordset ... it is the second parameter that is causing the error. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Iterating an ADODB RecordSet using System.Reflection
    ... Why don't you get direct the adonet dataset. ... needs investigation by yourself if you try it and it goes wrong. ... I have to be able to retrieve data from ADODB RecordSet, ... I do get a RecordSet object, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: syntax on ADODB recordset
    ... Dim rstClone As ADODB.Recordset ... Do you know that the recordset of frmActive is an ADODB recordset? ... Recordset and its RecordsetClone will both be DAO recordsets, ...
    (microsoft.public.access.formscoding)
  • Re: HELP - Connecting to ADODB Datasource for a MaiMerge
    ... you can't merge directly from an ADO recordset - you have to save the ... data to some sort of disk file in a format Word can work with. ... > I am trying to make a connection to a datasource that is an ADODB ... > I have an ADODB Recordset that is created from a query executed from a ...
    (microsoft.public.word.mailmerge.fields)
  • Re: ADO->Jet, seek method EOF, all subsequent setting the index fa
    ... 10,000 lookups using command method: ... table direct recordset into my important table, ... > I would setup a Command object with an-adhoc SQL query on the PK and Record ... > parameters and close the Recordset object when finished. ...
    (microsoft.public.data.ado)