private void UpdateHourlyReservation() { reservation_hourly = new List <Reservation_Hourly>(); OleDbConnection cn = new OleDbConnection(); //Connection OleDbCommand cmd = new OleDbCommand(); //Command OleDbDataReader dr; String path = Assembly.GetExecutingAssembly().Location; path = path.Replace("bin\\Debug\\ICTProjectPOS.exe", "RestaurantDB.accdb"); String connectionString = String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0}", path); cn.ConnectionString = @connectionString; cmd.Connection = cn; try { cmd.CommandText = "SELECT * FROM Reservation WHERE ResDate = @date AND ResTime = @time"; cmd.Parameters.AddWithValue("@date", _date); cmd.Parameters.AddWithValue("@time", _time); cn.Open(); dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { Reservation_Hourly res = new Reservation_Hourly(Int32.Parse(dr[0].ToString()), Int32.Parse(dr[6].ToString())); reservation_hourly.Add(res); } } cn.Close(); } catch { // empty } }
private void UpdateHourlyReservation() { reservation_hourly = new List<Reservation_Hourly>(); OleDbConnection cn = new OleDbConnection(); //Connection OleDbCommand cmd = new OleDbCommand(); //Command OleDbDataReader dr; String path = Assembly.GetExecutingAssembly().Location; path = path.Replace("bin\\Debug\\ICTProjectPOS.exe", "RestaurantDB.accdb"); String connectionString = String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0}", path); cn.ConnectionString = @connectionString; cmd.Connection = cn; try { cmd.CommandText = "SELECT * FROM Reservation WHERE ResDate = @date AND ResTime = @time"; cmd.Parameters.AddWithValue("@date", _date); cmd.Parameters.AddWithValue("@time", _time); cn.Open(); dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { Reservation_Hourly res = new Reservation_Hourly(Int32.Parse(dr[0].ToString()), Int32.Parse(dr[6].ToString())); reservation_hourly.Add(res); } } cn.Close(); } catch { // empty } }