C #-Oracle database connection method

Using System;
Using System.Collections.Generic;
Using System.ComponentModel;
Using System.Data;
Using System.Drawing;
Using System.Linq;
Using System.Text;
Using System.Windows.Forms;
Using System.Data.OracleClient;

Namespace Orawinapp
{
public partial class Form1:form
{
Public Form1 ()
{
InitializeComponent ();
}

private void Button1_Click (object sender, EventArgs e)
{
String myConnString = "Data Source=192.168.30.9;user id=test;password=1";
OracleConnection myconnection = new OracleConnection (myConnString);

OracleCommand catcmd = Myconnection.createcommand ();
Catcmd.commandtext = "Select T.p_nm,t.c_nm,t.a_nm,t.full_name from T_zip_district_phonecode T";

Myconnection.open ();

OracleDataReader myreader = Catcmd.executereader ();

while (Myreader.read ())
{
Console.WriteLine ("-{0}-{1}-{2}-{3}", Myreader.getstring (0), myreader.getstring (1), myreader.getstring (2), Myreader.getstring (3));
}

Myreader.close ();

Myconnection.close ();

}
}
}

Note: Add a reference to the System.Data.OracleClient.