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; } } |