By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,407 Members | 1,753 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,407 IT Pros & Developers. It's quick & easy.

Stupid NUBE Question

P: n/a

I have been thrown in the the cSharp grinder and I'm lost, I have t
connect to a web service and sent is some data, well I can connect jus
fine thanks to some very busy friends. Now that I'm not getting an
errors when I build the web page, I need to build dynamic array base
off a connection to an orcale db.

How do I make a connection to orcale, and how do I make a dynamic arra
based on the sql results?

"Please help OB1 your our last hope"

-E

--
Thorax
-----------------------------------------------------------------------
Thoraxx's Profile: http://www.msusenet.com/member.php?userid=96
View this thread: http://www.msusenet.com/t-187040460

Nov 17 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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


Nov 17 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.