C # Methods to connect Oracle databases

The example in this article describes C # 's approach to connecting Oracle databases. Share to everyone for your reference. The implementation methods are as follows:

?

1 2 3 4 5 6 7 8 9 10 11-12

1, add Reference System.data.oracleClient//2, set connection string data source is the service name (that is, the host string to be entered in the client Sqlplus)/3, the following usage and SQL Server Access Usage has been string strconn = "Data source=oamis;user=scott;password=tiger;"; OracleConnection conn = new OracleConnection (strconn); Conn. Open (); OracleCommand cmd = new OracleCommand (); Cmd.commandtext = "SELECT * from EMP"; Cmd. Connection = conn; DataSet ds = new DataSet (); OracleDataAdapter ad = new OracleDataAdapter (cmd); Ad. Fill (DS);

I hope this article will help you with the C # program.