Oracle.DataAccess.Client – Retrieve Record

Oracle.DataAccess.Client – Retrieve Record

 
   using System;
   using System.Collections.Generic;
   using Oracle.DataAccess;
   using Oracle.DataAccess.Client;
 
   static List<SoocerMove.TEAM> getTeam()
   {
 
      try
      {
 
         String connectionString = "Data Source=(DESCRIPTION="
                                               + "(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.86)(PORT=1521))"
                                               + "(CONNECT_DATA=(SERVICE_NAME=orcl)));"
                                               + "User Id=APPUSER1;Password=P@ssw0rd;";
 
         String queryString = "SELECT * FROM TEAM ORDER BY TEAM_ID";
 
         OracleConnection OrclConnection = new OracleConnection();
 
         OrclConnection.ConnectionString = connectionString;
 
         OracleCommand OrclORACCommand = OrclConnection.CreateCommand();
 
         OrclORACCommand.CommandText = queryString;
 
         OrclConnection.Open();
 
         OracleDataReader OrclDataReader = OrclORACCommand.ExecuteReader();
 
         System.Data.DataTable dt = new System.Data.DataTable();
         dt.Load(OrclDataReader);
 
         List<SoocerMove.TEAM> list = new List<SoocerMove.TEAM>();
 
         foreach (System.Data.DataRow dr in dt.Rows)
         {
            SoocerMove.TEAM team = new SoocerMove.TEAM();
 
            team.TEAM_ID = Int32.Parse(dr["TEAM_ID"].ToString());
            team.TEAM_NAME = dr["TEAM_NAME"].ToString();
            team.TEAM_LEAGUE = Int32.Parse(dr["TEAM_LEAGUE"].ToString());
 
            list.Add(team);
         }
 
         OrclDataReader.Close();
 
         OrclConnection.Close();
 
         return list;
      }
      catch (Exception ex)
      {
         Console.Write("Error" + ex.Message);
 
         Console.ReadLine();
 
         return null;
      }
 
   }