• Create a new project in Visual Studio using eight C# or VB.Net

• Add reference to Oracle.DataAccess.dll file. Typically this file can be found in C:\oracle\product\10.2.0\client_1\BIN directory. This directory may be different based on your oracle configuration.
• Once library is referenced, go to your class file where you want to create oracle connection.
• Add following statements based on language you selected for project.

Imports Oracle.DataAccess.Client ' VB.NET

using Oracle.DataAccess.Client;  // C#

• An Oracle connection string is inseparable from Oracle names resolution. Suppose we had a database alias of OraDb defined in a tnsnames.ora file as follows:

OraDb=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=TCP)(HOST=OTNSRVR)(PORT=1521))
    )
    (CONNECT_DATA=
      (SERVER=DEDICATED)
      (SERVICE_NAME=ORCL)
    )
  )

•  The OraDb alias defines the database address connection information for the client. To use the OraDb alias defined in the tnsnames.ora file shown above, you would use the following syntax:

Dim oradb As String = "Data Source=OraDb;User Id=scott;Password=tiger;" ' VB.NET

string oradb = "Data Source=OraDb;User Id=scott;Password=tiger;"; // C#

• You can modify the connection string to obviate the need for the tnsnames.ora file, however. Simply replace the name of the alias with how it would be defined in a tnsnames.ora file.

   ' VB.NET
  

Dim oradb As String = "Data Source=(DESCRIPTION=" _
           + "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=OTNSRVR)(PORT=1521)))" _
           + "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)));" _
           + "User Id=scott;Password=tiger;"

// C#
string oradb = "Data Source=(DESCRIPTION="
             + "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ORASRVR)(PORT=1521)))"
             + "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)));"
             + "User Id=scott;Password=tiger;";

• Now you can create connection object from the connection string above. The connection string must be associated with the connection object.

Dim conn As New OracleConnection(oradb) ' VB.NET

OracleConnection conn = new OracleConnection(oradb); // C#

• Now you can use this connection like any other connection and do various database tasks.
• To open a connection, use following statements,

conn.Open() ' VB.NET

conn.Open(); // C#

• To create a command object, use following statements,

Dim sql As String = "select dname from dept where deptno = 10" ' VB.NET
Dim cmd As New OracleCommand(sql, conn)
cmd.CommandType = CommandType.Text

string sql = "select dname from dept where deptno = 10"; // C#
OracleCommand cmd = new OracleCommand(sql, conn);
cmd.CommandType = CommandType.Text;

• You can retrieve values from command object using following statement,

Dim dr As OracleDataReader = cmd.ExecuteReader() ' Visual Basic
dr.Read()

Label1.Text = dr.Item("dname") ' retrieve by column name
Label1.Text = dr.Item(0) ' retrieve the first column in the select list
Label1.Text = dr.GetString(0) ' return a .NET data type
Label1.Text = dr.GetOracleString(0) ' return an Oracle data type

OracleDataReader dr = cmd.ExecuteReader(); // C#
dr.Read();

label1.Text = dr["dname"].ToString(); // C# retrieve by column name
label1.Text = dr.GetString(0).ToString();  // return a .NET data type
label1.Text = dr.GetOracleString(0).ToString();  // return an Oracle data type

• All open connection objects should be closed once you are done using them.

conn.Close()   ' Visual Basic
conn.Dispose() ' Visual Basic

conn.Close();   // C#
conn.Dispose(); // C#

Comments

Add New Search

Write comment

Name: Email:   Website: Title: UBBCode:         -color-aquablackbluefuchsiagraygreenlimemaroonnavyolivepurpleredsilvertealwhiteyellow -size-tinysmallmediumlargehuge   Please input the anti-spam code that you can read in the image.

eldavan  - 3 capas c# oracle |190.233.199.xxx |2010-04-28 01:00:25 ::::::::::::::::::::::::::::::::: using System; using System.Collections.Generic; using System.Text; using PRYDATA; using System.Data; namespace PryNegocio { public class ClsNegocio { Clsdata obj = new Clsdata(); //instanciando la clase Clsdata public DataTable FacMes(int anio) { return obj.TraeTabla("Spmes", anio); } ::::::::::::::::::::::::::::::::::: using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.OracleClient; using System.Configuration; namespace PRYDATA { public class Clsdata { public String Conexion() { return ConfigurationManager.ConnectionStrings["conex& #34;].ConnectionString; } //un metodo general para ejecutar cualquier procedure , pasando n parametros public DataTable TraeTabla(string nompro, params object[] lista) { OracleConnection cn = new OracleConnection(Conexion()); OracleCommand cmd = new OracleCommand(nompro, cn); cmd.CommandType = CommandType.StoredProcedure; cn.Open(); OracleCommandBuilder.DeriveParameters(cmd); int cuenta = 0; string parm; foreach (OracleParameter pr in cmd.Parameters) { parm = pr.OracleType.ToString();//obtener el tipo de parametro if (parm.ToUpper() != "CURSOR") { pr.Value = lista[cuenta]; cuenta++; } }//fin foraech OracleDataAdapter da = new OracleDataAdapter(cmd); ... ReplyQuote 2 0

eldavan  - proyectos resueltos |190.233.199.xxx |2010-04-28 01:02:30 visitame encontraras proyectos resueltos http://my.opera.com/eldavan/blog/ ReplyQuote 0 1

Powered by !JoomlaComment 4.0 beta2