C # - Oracle Database Connection Method

Using system.data; using system.data.oracleclient;

Class sample {public static void main () {string myconnstring = "User ID = zk; data source = zkqx; password = *****"; OracleConnection myconnection = new OracleConnection;

OracleCommand catcmd = myconnection.createCommand (); catcmd.commandtext = "SELECT CZYDM, CZYMC, CZYMM, CZYQX from ZC_CZY";

MyConnection.open ();

OracleDataReader MyReader = Catcmd.executeReader ();

While (MyReader.Read ()) {console.writeline ("/ t {0} / t {1} / t {2} / t {3}", MyReader.getstring (0), MyReader.getstring (1), MyReader.getstring (2), MyReader.getstring (3));

MyReader.Close ();

MyConnection.Close ();}}