Stupid NUBE Question  
Author Message
corrieknor





PostPosted: Thu May 05 02:07:38 CDT 2005 Top

Visual C#.Net >> Stupid NUBE Question

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.hide-link.com/
View this thread: http://www.hide-link.com/

DotNet99  
 
 
Dmytro





PostPosted: Thu May 05 02:07:38 CDT 2005 Top

Visual C#.Net >> Stupid NUBE Question 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]




>
> 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
>