Dataset to an oracle stored procedure

[Jawahar Rajan]

Is it possible for a Dataset that is added to a C# project to be based on a
stored Procedure?
Can I use either a OracleClient or Microsoft Oracle Client?

Any help is appreciated.
Jawahar

[Miha Markic]

Yes, it is possible with both.
There is no design time support for retrieving dataset metadata with MS'
Oracle provider.
I don't know about Oracle's one.

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"Jawahar Rajan" <jr****@nc.rr.com> wrote in message
news:3M*********************@twister.southeast.rr. com...

Is it possible for a Dataset that is added to a C# project to be based on a stored Procedure?
Can I use either a OracleClient or Microsoft Oracle Client?

Any help is appreciated.
Jawahar

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

Miha and Jawahar,

While there isn't design time support for retrieving the results of a
stored procedure using the managed provider for oracle, if you have the OLE
DB provider installed, you can get the results through that in design time
and get the data set through that.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Miha Markic" <miha at rthand com> wrote in message
news:ON**************@TK2MSFTNGP09.phx.gbl...

Yes, it is possible with both.
There is no design time support for retrieving dataset metadata with MS'
Oracle provider.
I don't know about Oracle's one.

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"Jawahar Rajan" <jr****@nc.rr.com> wrote in message
news:3M*********************@twister.southeast.rr. com...

Is it possible for a Dataset that is added to a C# project to be based

on a

stored Procedure?
Can I use either a OracleClient or Microsoft Oracle Client?

Any help is appreciated.
Jawahar

[Miha Markic]

Hi Nicholas,

Nice trick :)

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote in
message news:%2****************@TK2MSFTNGP11.phx.gbl...

Miha and Jawahar,

While there isn't design time support for retrieving the results of a
stored procedure using the managed provider for oracle, if you have the OLE DB provider installed, you can get the results through that in design time
and get the data set through that.