ADO.Net DataSet to ADO Recordset

29 Mar 2005 9:13 PM

Ganesh

I have two applications, one on ASP.Net and the other on ASP (both have
different explicit databases). It so happens that the ASP application now
wants to use the dataset created in ASP.Net for further information
processing.
How do i make this happen?

29 Mar 2005 11:42 PM

Robbe Morris [C# MVP]

You don't. The ADODB recordset requires its xml to
be specially formatted in a way that the ADO.NET DataSet
just can't generate.

It would be easier to implement the xml document in
classic ASP rather than work with ADO.

--
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.learncsharp.net/home/listings.aspx

Show quote

"Ganesh" <Gan***@discussions.microsoft.com> wrote in message
news:D7561ED8-F2DC-441A-BF5C-EA3DFF9FD30E@microsoft.com...
>I have two applications, one on ASP.Net and the other on ASP (both have
> different explicit databases). It so happens that the ASP application now
> wants to use the dataset created in ASP.Net for further information
> processing.
> How do i make this happen?

30 Mar 2005 1:48 AM

Val Mazur (MVP)

Hi,

There are several ways to handle it

1. You could try to convert DataSet into ADO Recordset. See next KB with an
example how to do this

http://support.microsoft.com/default.aspx?scid=kb;en-us;316337

2. You could create .NET component that will use DataSet inside, but will be
exposed as a COM and you could use it from ASP

--
Val Mazur
Microsoft MVP

http://xport.mvps.org

Show quote

"Ganesh" <Gan***@discussions.microsoft.com> wrote in message
news:D7561ED8-F2DC-441A-BF5C-EA3DFF9FD30E@microsoft.com...
>I have two applications, one on ASP.Net and the other on ASP (both have
> different explicit databases). It so happens that the ASP application now
> wants to use the dataset created in ASP.Net for further information
> processing.
> How do i make this happen?

30 Mar 2005 8:10 AM

Cor Ligthert

Ganesh,

Just set an X after your ASP pages and extend them with code as you can see
in samples here.

(Assuming that you have installed dotNet on your webserver)

http://samples.gotdotnet.com/quickstart/

I hope this helps a little bit?

Cor