Dataset connected to an Oracle stored Proc

  • Thread starter Thread starter Jawahar Rajan
  • Start date Start date
J

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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dataset to an oracle stored procedure 3
return value from Oracle stored proc 2
calling oracle stored proc from .net 3
DataSet Max Length Compared to Oracle Varchar2 1
'user id' is an invalid connection string attribute error on Oracle.... 7
oracle transaction for stored procedure? 1
VS2005, dataSets and stored procs (how annoying!) 1
converting tableAdaptor queries into stored procs 2

Back
Top