Oracle Database Connection

 
String ConnectionString = "user id = ordtrc; pwd = ordtrc; data source =" FRAME2DB "; persist security info = False;"; // write a connection string
OracleConnection conn = new OracleConnection (ConnectionString); // create a new connection
Try
     {
Conn. Open ();
OracleCommand cmd = conn. CreateCommand ();
Cmd. CommandText = "select * from AUTH_BUSI"; // write an SQL statement here
OracleDataReader odr = cmd. ExecuteReader (); // Create an OracleDateReader object
DataSet ds = new DataSet ();
While (odr. Read () // Read data. If odr. Read () returns false, it indicates the end of the record set.
    {
Response. Write (odr. GetOracleString (1). ToString (); // output Field 1. This number is a field index. How to use the field name remains to be studied.
    }
Odr. Close ();
     }
Catch (Exception ee)
     {
Response. Write (ee. Message); // if an error occurs, the error Message is output.
     }
Finally
     {
Conn. Close (); // Close the connection
     }