Re: COM Interoperability - Object type to Dataset

From: Martin Dechev (detcheff__at_hotmail.com)
Date: 02/18/04 

Date: Wed, 18 Feb 2004 16:49:08 +0100

Hi, Prasad,

The recommendation is the following:

The .OLE DB .NET Data Provider includes overloads to the
OleDbDataAdapter.Fill method which take as input an ADO Recordset or Record
object returned by existing COM components, and populate a DataSet with the
data contained in the ADO object.
http://msdn.microsoft.com/library/en-us/dnsql2k/html/sql_adonetprimer.asp

Greetings
Martin
"Prasad" <anonymous@discussions.microsoft.com> wrote in message
news:67965B12-6CC6-4E78-9770-FB1797E4878F@microsoft.com...
> Hi,
>
> I have a legacy DLL, that has functions which accept and return type
"Variant".
> I want to use that DLL in .NET. I am able to use functions well that
return variants but that return common data types like string, int etc.
>
> There is one function that has a return type variant, but actually returns
a recordset.
> the return type of variant in .NET is treated as Syste.Object.
>
> I am unable to type cast the Object(actually a recordset) to dataset.
>
> Any ideas on this?
>
> Thanks
> Prasad

Relevant Pages

  • Re: how to assign a recordset of ado to a variant?
    ... V contains ADO recordset that you can use in your COM library. ... >> Regards, ... >>> And the 'variant' should contain all data in the recordset of ado. ...
    (borland.public.delphi.database.ado)
  • Re: how to assign a recordset of ado to a variant?
    ... V contains ADO recordset that you can use in your COM library. ... >> Regards, ... >>> And the 'variant' should contain all data in the recordset of ado. ...
    (borland.public.delphi.database.ado)
  • Re: Problem with the output of Split
    ... to the recordset and made them both advarcharjust to test this. ... The Array and Split statements here seem equivalent except when I try ... Dim varFieldNames As Variant ...
    (microsoft.public.vb.general.discussion)
  • Re: Using WSH to populate a pivot cache with an ADO recordset
    ... I've tried this method and it works OK from WSH. ... However, in this case, I still need to be able to populate the pivot cache ... using an ADO recordset, because I've run previous statements on the ADO data ...
    (microsoft.public.excel.programming)
  • Re: Concatenate problem
    ... > Function sCostDesc(lcindex As Variant) As Variant ... Rs As Recordset ... The first column is an ID ... the second is a description keyword. ...
    (microsoft.public.excel.programming)