using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using Oracle.DataAccess.Client;//引用的dll

namespace ConsoleApplication2

{

    class Program

    {

        static void Main(string[] args)

        {

            string constr = "User Id=Leo;Password=m123;Data Source=orcl";

            OracleConnection con = new OracleConnection(constr);

            con.Open();

            // Display Version Number

            Console.WriteLine("Connected to Oracle " + con.ServerVersion);

            OracleCommand cmmd = new OracleCommand("select * from Leo_Person ", con);

            OracleDataAdapter oa = new OracleDataAdapter(cmmd);

            System.Data.DataSet ds = new System.Data.DataSet();

            oa.Fill(ds, "person");

            foreach (System.Data.DataRow row in ds.Tables[0].Rows)

            {

                int count = 0;

                foreach (System.Data.DataColumn column in ds.Tables[0].Columns)

                {

                    Console.Write(column.ColumnName + ":" + row[column] + "\t");

                    count++;

                }

                if (count == 3)

                {

                    Console.Write("\n");

                }

          }

            // Close and Dispose OracleConnection

            con.Close();

            con.Dispose();

            Console.Read();