Dataset to ADODB.Recordset

[Katit]

Basically, I need to return data for legacy app in a way of
ADODB.Recordset.

http://support.microsoft.com/kb/316337

This article pretty much covers it, but I would like to do that
without writing files.
So, I may need to know how to fill up ADODB.Stream from .NET Dataset.
Anyone did that? Any suggestions?

I need simple 1 table conversion. I'm just thinking on building
recordset manually in code if above doesn't work..

Thanks

 

[Nicholas Paldino [.NET/C# MVP]]

Katit,

As a site note, you can't really copy a DataSet to a Recordset, as the
DataSet can potentially contain multiple tables. You really are looking to
convert a DataTable to a Recordset.

You are probably better of creating the recordset manually in code based
on the structure of the datatable. The format that a recordset saves data
in is one of two formats, neither of which is easy to build a converter for
(as opposed to just creating the recordset programatically).

 

[=?ISO-8859-1?Q?Arne_Vajh=F8j?=]

Basically, I need to return data for legacy app in a way of
ADODB.Recordset.

http://support.microsoft.com/kb/316337

This article pretty much covers it, but I would like to do that
without writing files.
So, I may need to know how to fill up ADODB.Stream from .NET Dataset.
Anyone did that? Any suggestions?

I need simple 1 table conversion. I'm just thinking on building
recordset manually in code if above doesn't work..

There are some other code available at:
http://www.codeproject.com/cs/database/DataTableToRecordset.asp

But one question: why not just generate the ADODB.Recordset
in C# ??

You can by definition not avoid native code.

Arne

 

[Katit]

There are some other code available at:
http://www.codeproject.com/cs/database/DataTableToRecordset.asp

But one question: why not just generate the ADODB.Recordset
in C# ??

You can by definition not avoid native code.

Arne

I thought about it too. There is one problem with that. Component that
get's data is .NET remote component. Then I need to transfer data
over .NET remoting protocol. I wonder how ADODB.Recordset will
travel

I was thinking about getting data table, then send XML over and parse
it into ADODB.Recordset locally.