Hi,
Never worked with Oracle, though I guess my idea might still be helpful.
Assuming you use .NET 1.1, there is a managed data provider for Oracle
(System.Data.Oracle namespace if I am not mistaken).
Now, open the connection to the Oracle database by creating the
OracleConnection class and calling its Open method.
Now, create a new instance of the OracleCommand class, configure it with the
appropriate query and parameters, then call the command's ExecuteReader
method.
Assign the result of this method to a variable of type DataReader.
Then, create a new ArrayList and while the DataReader can read a value, read
it and add to the ArrayList.
--
Sincerely,
Dmytro Lapshyn [Visual Developer - Visual C# MVP]
"Thoraxx" <Th************@no-mx.msusenet.com> wrote in message
news:Th************@no-mx.msusenet.com...
I have been thrown in the the cSharp grinder and I'm lost, I have to
connect to a web service and sent is some data, well I can connect just
fine thanks to some very busy friends. Now that I'm not getting any
errors when I build the web page, I need to build dynamic array based
off a connection to an orcale db.
How do I make a connection to orcale, and how do I make a dynamic array
based on the sql results?
"Please help OB1 your our last hope"
-EP
--
Thoraxx
------------------------------------------------------------------------
Thoraxx's Profile: http://www.msusenet.com/member.php?userid=960
View this thread: http://www.msusenet.com/t-1870404604