Dataset connected to an Oracle stored Proc

[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

 

[William Ryan]

Yes you can. Here's the code to call a stored proc done with SqlClient,
but substitute the OracleClient equivalents and it'll work for you
http://www.knowdotnet.com/articles/storedprocsvb.html The only difference
is that you'd declare a DataAdapter, set it's SelectCommand to your stored
proc name, and fire DataAdapter.Fill(DataSet, DataTable)