conexion AspNet Oracle, quien tiene ejmplos

[carlostapia]

quien tiene ejmplos oracle asp net


me da error el que toy usando por eso necesito mas

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: BC30466: Namespace or type 'OracleClient' for the Imports 'System.Data.OracleClient' cannot be found.

Source Error:



Line 19: Imports System.Data
Line 20: Imports System.Data.OleDb
Line 21: Imports System.Data.OracleClient
Line 22: Imports System.Text
Line 23: Imports System.Text.RegularExpressions

[Zyanya_80]

Hola:

Lo que pasa es que tienes que agregar una referencia de un odbc de oracle para .NET

un ejemplo de una consulta es el siguiente:

public void InsertRow(string myConnection)

{

// If the connection string is null, use a default.

if(myConnection == "")

{

myConnection = "Data Source=Oracle8i;Integrated Security=yes";

}

OracleConnection myConn = new OracleConnection(myConnection);

string myInsertQuery = "INSERT INTO Dept (DeptNo, Dname, Loc) values (50, 'TECHNOLOGY', 'DENVER')";

OracleCommand myOracleCommand = new OracleCommand(myInsertQuery);

myOracleCommand.Connection = myConn;

myConn.Open();

myOracleCommand.ExecuteNonQuery();

myConn.Close();

}


espero que esto te sirva de algo.

[suncreative]

http://www.able-consulting.com/ADO_Conn.htm

espero que te sirva de algo