Oracle connection

  • Thread starter Thread starter Francis Awofeso
  • Start date Start date
F

Francis Awofeso

Please if anyone with experience with VB.Net and Oracle can describe the
steps it will take to connect to Oracle, or can refer me to a link where I
can lookup the ateps or process required to connect to Oracle database. Also
references to any booksor documentation will be appreciated.

Thanks
 
www.connectionstrings.com

Basically, declare a new connection object with a valid conne tion string.

OracleConnection cn = new OracleConnection("YourConnectionStringHere");

Once you have your connection, you'll want to do something with it so you'll
need a command object or a dataadapter which will need at a minimum a select
command object.

Command's have many methods lik command.ExecuteReader (will fire a
datareader) .ExcecuteScalar (will return one value), ExecuteNonQuery
(execute Insert/delete etc). This is a very simplified view, but it should
get you going.

Just google on ADO.NET, there are tons of examples.

HTH,

Bill
 
Back
Top