예제 #1
0
        public Winkel GetWinkel(string naam)
        {
            Winkel w   = null;
            string sql = @"SELECT naam, locatie, awards FROM Winkel WHERE Naam= :Naam";

            try
            {
                conn.Open();
                OracleCommand cmd = new OracleCommand(sql, conn);
                cmd.CommandType = CommandType.Text;
                cmd.Parameters.Add("Naam", OracleDbType.Varchar2, naam, ParameterDirection.Input);
                OracleDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    w = new Winkel(reader.GetOracleString(0).ToString(),
                                   reader.GetOracleString(1).ToString(),
                                   reader.GetOracleString(2).ToString(),
                                   new List <WinkelReview>());
                }
            }
            catch { }
            finally
            {
                conn.Close();
            }
            return(w);
        }
예제 #2
0
 public Winkel GetWinkel(string naam)
 {
     Winkel w = null;
     string sql = @"SELECT naam, locatie, awards FROM Winkel WHERE Naam= :Naam";
     try
     {
         conn.Open();
         OracleCommand cmd = new OracleCommand(sql, conn);
         cmd.CommandType = CommandType.Text;
         cmd.Parameters.Add("Naam", OracleDbType.Varchar2, naam, ParameterDirection.Input);
         OracleDataReader reader = cmd.ExecuteReader();
         while (reader.Read())
         {
             w = new Winkel(reader.GetOracleString(0).ToString(),
                 reader.GetOracleString(1).ToString(),
                 reader.GetOracleString(2).ToString(),
                 new List<WinkelReview>());
         }
     }
     catch { }
     finally
     {
         conn.Close();
     }
     return w;
 }